note 116638 added to pdostatement.bindparam
| From: | gilhildebrand at gmail dot com | Date: | Mon, 02 Feb 2015 16:50:19 +0000 |
| Subject: | note 116638 added to pdostatement.bindparam | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-201579@lists.php.net to get a copy of this message | ||
MySQL will return an error if a named placeholder has a hyphen in it:
UPDATE wardrobe SET
T-Shirt=:T-SHIRT WHERE id=:id
Will return the following error: PDOException' with message 'SQLSTATE[HY093]: Invalid
parameter number: parameter was not defined'
To resolve, just remove hyphens from named placeholders:
UPDATE wardrobe SET T-Shirt=:TSHIRT WHERE id=:id
----
Server IP: 72.52.91.14
Probable Submitter: 24.252.91.231
----
Manual Page -- http://php.net/manual/en/pdostatement.bindparam.php
Edit -- https://master.php.net/note/edit/116638
Del: integrated -- https://master.php.net/note/delete/116638/integrated
Del: useless -- https://master.php.net/note/delete/116638/useless
Del: bad code -- https://master.php.net/note/delete/116638/bad+code
Del: spam -- https://master.php.net/note/delete/116638/spam
Del: non-english -- https://master.php.net/note/delete/116638/non-english
Del: in docs -- https://master.php.net/note/delete/116638/in+docs
Del: other reasons-- https://master.php.net/note/delete/116638
Reject -- https://master.php.net/note/reject/116638
Search -- https://master.php.net/manage/user-notes.php