#43130 [Opn->Asn]: bind parameter cannot contain dashes

ID: 43130 Updated by: iliaa@php.net Reported By: joel at purerave dot com -Status: Open +Status: Assigned Bug Type: PDO related Operating System: Windows XP Home PHP Version: 5.2.4 -Assigned To: +Assigned To: iliaa Previous Comments: ------------------------------------------------------------------------ [2007-10-29 18:07:00] joel at purerave dot com Description: ------------ Parameters to bind in a prepared statement cannot contain dashes (-) in the name. It probably assumes that "-value" should be another variable. If this cannot be fixed, then at least update the documentation to make it clear what names can and cannot be used. Using {} around the variable name would be nice too! Reproduce code: --------------- $db = new PDO("mysql:host=localhost;dbname=testing", 'xxxx', 'xxxx'); $stmt = $db->prepare("SELECT id FROM testing WHERE id=:id-value"); $stmt->bindParam(':id-value', $id); $id = 1; $stmt->execute(); var_dump($stmt->fetch()); Expected result: ---------------- array(2) { ["id"]=> string(1) "1" [0]=> string(1) "1" } Actual result: -------------- Warning: PDOStatement::execute() [function.PDOStatement-execute]: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined in C:\htdocs\test.php on line 8 bool(false) ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=43130&edit=1