PDO not returning result

Question

I'm having trouble figuring out what I'm doing wrong. If i use this set of code I get the result I intend:

$x =  $db->prepare('SELECT * FROM table LIMIT 2');
$x->execute();
print_r($x->fetchALL());

When I use this set of code I don't get anything in return:

$a = "table";
$b = "2";
$x =  $db->prepare('SELECT * FROM ? LIMIT ?');
$x->execute(array($a,$b));
print_r($x->fetchALL());

Is there something I'm missing? Thanks in advance.

`SELECT * FROM ? LIMIT ?` You can't do this => http://stackoverflow.com/q/182287/ nor http://stackoverflow.com/q/11312737/ — Funk Forty Niner, Dec 30 '14 at 17:52
Btw, I don't put in answers for questions like these (anymore). Asked way too many times. — Funk Forty Niner, Dec 30 '14 at 17:58

score 2 · Answer 1 · answered Dec 30 '14 at 17:53

Parameter placeholders can only be used to replace column values; not table names, column names, or other syntax elements (including LIMIT values).

In order to make your query dynamic with respect to things that can't be parameterized, you have to build it yourself, without PDO's help. However, you should still build it so that the values that can be parameterized, are paramerized.

PDO not returning result

1 Answers1