How do I fetch data from this column in pdo? [duplicate]

Question

I'm very new to PDO. The issue I'm currently facing is that I'm trying to grab a users first name from a column however I have no idea how to fetch it properly. I've managed to find verify the user email with the email in the database now I just need to fetch the UserFirstName column and store it in a variable.

$data = array();
 if(isset($_POST['email'])){
  $data = $_POST['email'];


            if (!filter_var($_POST['email'], FILTER_VALIDATE_EMAIL) === false) {
                $data = $_POST['email'];

            $stmt = $pdo->prepare('SELECT * FROM users WHERE UserEmail = :UserEmail');
                $stmt->execute(array(':UserEmail' => $data));

$stmt->execute( should be $result = $stmt->execute( and var_dump($result); — samayo
– samayo, Commented Jan 16, 2017 at 15:50

Imran Qamer · Accepted Answer · 2017-01-17 06:40:21Z

-1

change query to:

$stmt = $pdo->prepare('SELECT UserFirstName FROM users WHERE UserEmail = :UserEmail');

To execute:

$stmt->execute(array(':UserEmail' => $data));

then to fetch single column

$result = $stmt ->fetchColumn();
print("name = $result\n");

for reference http://php.net/manual/en/pdostatement.fetchcolumn.php

edited Jan 17, 2017 at 6:40

answered Jan 16, 2017 at 15:56

Imran Qamer

2,2633 gold badges33 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

jake Over a year ago

It returns Invalid parameter number: no parameters were bound in "$result = $stmt ->fetchColumn();"

Qirel Over a year ago

That's because you need to bind the parameters, use the execute you already had in the question: $stmt->execute(array(':UserEmail' => $data));

jake Over a year ago

Oh I see now! Thank you for clearing that up and taking your time!

Collectives™ on Stack Overflow

How do I fetch data from this column in pdo? [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related