note 116220 added to pdo.prepare
| From: | jesse dot chisholm at gmail dot com | Date: | Mon, 24 Nov 2014 16:17:26 +0000 |
| Subject: | note 116220 added to pdo.prepare | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-201014@lists.php.net to get a copy of this message | ||
@Simon Le Pine
Be aware that:
$search = "user";
$sth = db->prepare("SELECT * FROM users WHERE $search=:email");
and
$search = "email";
$sth = db->prepare("SELECT * FROM users WHERE $search=:email");
will produce two totally different prepared statements.
Doing this _will not work_:
$search = "user";
$sth = db->prepare("SELECT * FROM users WHERE $search=:email");
$sth->execute(array(email=>"yada"));
$search = "email";
$sth->execute(array(email=>"yada@ya.da"));
----
Server IP: 72.52.91.14
Probable Submitter: 107.218.62.4
----
Manual Page -- http://php.net/manual/en/pdo.prepare.php
Edit -- https://master.php.net/note/edit/116220
Del: integrated -- https://master.php.net/note/delete/116220/integrated
Del: useless -- https://master.php.net/note/delete/116220/useless
Del: bad code -- https://master.php.net/note/delete/116220/bad+code
Del: spam -- https://master.php.net/note/delete/116220/spam
Del: non-english -- https://master.php.net/note/delete/116220/non-english
Del: in docs -- https://master.php.net/note/delete/116220/in+docs
Del: other reasons-- https://master.php.net/note/delete/116220
Reject -- https://master.php.net/note/reject/116220
Search -- https://master.php.net/manage/user-notes.php