note 118046 added to pdostatement.bindvalue

The parameter must names like a php variable. e.g. <?php $dbh = new PDO("mysql:dbname=test;host=127.0.0.1", "user", "password"); $sth = $dbh->prepare("SELECT * FROM table WHERE last-name=:last-name"); if($sth !== false && $sth->bindValue(":last-name", "Ngo")) { $sth->execute(); } // output: PHP Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: parameter was not defined ?> ---- Server IP: 72.52.91.14 Probable Submitter: 210.13.211.180 ---- Manual Page -- http://php.net/manual/en/pdostatement.bindvalue.php Edit -- https://master.php.net/note/edit/118046 Del: integrated -- https://master.php.net/note/delete/118046/integrated Del: useless -- https://master.php.net/note/delete/118046/useless Del: bad code -- https://master.php.net/note/delete/118046/bad+code Del: spam -- https://master.php.net/note/delete/118046/spam Del: non-english -- https://master.php.net/note/delete/118046/non-english Del: in docs -- https://master.php.net/note/delete/118046/in+docs Del: other reasons-- https://master.php.net/note/delete/118046 Reject -- https://master.php.net/note/reject/118046 Search -- https://master.php.net/manage/user-notes.php