Echo or print a value from sql table using PHP PDO [duplicate]

Question

I am trying to echo or print the last value of column usercode using PHP PDO. I tried to do this by using name column and SESSION var which will be the last values as references, but it doesn't work.

$name = $_SESSION['name'];

$query = $db->prepare("SELECT usercode from users where name = $name ");
$query->execute();

$result = $query->setFetchMode(PDO::FETCH_ASSOC); 

echo $result;

There are examples in the PDO manual. Try doing proper research before posting question. — Barmar
– Barmar, Commented Feb 4, 2017 at 10:52
You should be getting an error from that query, since you didn't put quotes around $name. But you should use bound parameters, then that's not a problem. — Barmar
– Barmar, Commented Feb 4, 2017 at 11:10

The Codesee · Accepted Answer · 2017-02-04 10:59:09Z

0

Here you go:

$name = $_SESSION['name'];

$query = $db->prepare("SELECT usercode from users where name=:name");
$query = $db->bindParam(':name', $name);
$query->execute();

$row = $query->fetch();

echo $row['usercode'];

bindParam is used when you just want to bind a variable reference to a parameter in the query.

answered Feb 4, 2017 at 10:59

The Codesee

3,7937 gold badges44 silver badges80 bronze badges

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

5 Comments

SuperDJ Over a year ago

Dont need to use named paramaters. You can also use question marks which is similar to mysqli

The Codesee Over a year ago

@SuperDJ I don't really see a difference between the two... really it depends if you're using PDO with MySQLi or PDO with prepared statements... I've always gone with the second one.

Barmar Over a year ago

@SuperDJ You don't have to, but why wouldn't you? It makes queries and bindParam() calls so much easier to read.

Ryan Vincent Over a year ago

just thoughts: I think it is a bit long when there is only one parameter. also, I am not a fan of bound parameters. I would: $db->prepare("SELECT usercode from users where name = ?); and: $query->execute([$name]); in this case.

Your Common Sense Over a year ago

@TheCodesee, JFYI: fetchColumn()

Collectives™ on Stack Overflow

Echo or print a value from sql table using PHP PDO [duplicate]

1 Answer 1

5 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Linked

Related