PHP PDO prepare statement

Asked Dec 01 '14 at 02:55

Active Dec 01 '14 at 02:57

Viewed 53 times

I am learning PHP Pdo and I got a question and answer.

Assuming that the PDO connection is valid. the following code returns none because the prepared statement is invalid.

I want to know why/how the prepared statement is invalid.

$pdo = new PDO(...);
$sql = "SELECT :cols FROM names WHERE name = :name";
$stmt = $pdo->prepare($sql);
$stmt->bindValue(':cols', 'COUNT(id)');
$stmt->bindValue(':name', 'anna');
$stmt->execute();

edited Dec 01 '14 at 02:57

asked Dec 01 '14 at 02:55

zeroweb

2,453
2
19
28

5

You can't bind columns `SELECT :cols` – Funk Forty Niner Dec 01 '14 at 02:55
Why do you want to bind `COUNT(id)` instead of just writing it there as-is? – zerkms Dec 01 '14 at 02:56
1

Use `"SELECT COUNT(id) FROM names WHERE name = :name"` as the query instead; also, I'm not sure how this is related to `__get` and `__set`. – Ja͢ck Dec 01 '14 at 02:57

PHP PDO prepare statement

0 Answers0