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, Sep 21 '16 at 17:21

Your Common Sense · Accepted Answer · 2016-11-22T13:59:46.810

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 '16 at 13:59

answered Sep 21 '16 at 10:52

Your Common Sense

156,878
40
214
345

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 Sep 21 '16 at 17:19
Why is just. $var = "bing"; $sth->execute([$var]); better? – Igor Unger Nov 22 '16 at 13:55
How much writing does it take? – Your Common Sense Nov 22 '16 at 13:58
You're right its shorter, does that also mean, that it's faster? – Igor Unger Nov 22 '16 at 14:00
1

You shouldn't be concerned in "faster" things at all. – Your Common Sense Nov 22 '16 at 14:01
I try to make things good, not just 'right'. so faster is a Point – Igor Unger Nov 22 '16 at 14:02
Every time you are doing a thing "faster" you are doing it wrong. This pointless obsession will lead you to nowhere. – Your Common Sense Nov 22 '16 at 14:06
Okay, I will think about your words. Thank you. :-) – Igor Unger Nov 22 '16 at 14:08
1

JFYI: http://stackoverflow.com/questions/2823600/php-image-resize-on-the-fly-vs-storing-resized-images/9468009#9468009 – Your Common Sense Nov 22 '16 at 14:10
You got it on the point. I get what you mean. Nevertheless I try in some cases (sql querys for example) to get them as fast as I can. Or do you mean optimizing querys is a bad point, too? – Igor Unger Nov 22 '16 at 14:19
1

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. – Your Common Sense Nov 22 '16 at 14:27

PDO bind Parameter

1 Answers1