note 116220 added to pdo.prepare

From: 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

« previous php.notes (#201014) next »