PDO bind Parameter

Question

I'm getting involved in PDO now and theres one thing I try to understand:

If I try:

$var = "bing";
$sth-> bindParam(":parameter",$var);
$sth-> execute ();

I get no results.

But if I try:

$sth-> bindParam(":parameter",$var);
$var = "bing";
$sth-> execute ();

I do. WHY???

@Martin Yes, I did. @ Ryan I like the colon writing, because it I think its better to read. — Igor Unger
– Igor Unger, Commented Sep 21, 2016 at 17:21

Your Common Sense · Accepted Answer · 2016-11-22 13:59:46Z

2

It should work both ways.

Double-check your premises, create a minimal working example that clearly demonstrates the problem. E.g.

$sth = $pdo->prepare("SELECT :parameter");
$var = "bing";
$sth->bindParam(":parameter",$var);
$sth->execute();
var_dump($sth->fetchColumn());

$sth = $pdo->prepare("SELECT :parameter");
$sth->bindParam(":parameter",$var2);
$var2 = "bong";
$sth->execute();
var_dump($sth->fetchColumn());

Most of time, in the process of creation, you will find that simple typo which caused your mistake.

P.S. Either way, better make it just

$sth = $pdo->prepare("SELECT ?");
$var = "bing";
$sth->execute([$var]);
var_dump($sth->fetchColumn());

edited Nov 22, 2016 at 13:59

answered Sep 21, 2016 at 10:52

Your Common Sense

158k42 gold badges226 silver badges372 bronze badges

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

11 Comments

Igor Unger Over a year ago

Thank you, for your answer. I tried it again and everything worked perfectly well. I don't know, where my problem was the last time. It never gets boring! ;-)

Igor Unger Over a year ago

Why is just. $var = "bing"; $sth->execute([$var]); better?

Your Common Sense Over a year ago

You shouldn't be concerned in "faster" things at all.

Your Common Sense Over a year ago

JFYI: stackoverflow.com/questions/2823600/…

Your Common Sense Over a year ago

Nope, optimizing SQL queries is a good thing. But still, only if it's not premature optimization out of nowhere. Blunt optimization (like adding useless indexes) will lead to opposite results as well.

|

Collectives™ on Stack Overflow

PDO bind Parameter

1 Answer 1

11 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Linked

Related