#39218 [NEW]: parameter substitution:parameters always empty

From: jan_metzel at gmx dot de Operating system: Linux PHP version: 5.1.6 PHP Bug Type: PDO related Bug description: parameter substitution:parameters always empty Description: ------------ Parameter substitution in PDO::prepare() does not work. Statement has been executed successfully but it seems like values of parameters are just empty strings. Seems to occure no matter what kind of query is used (SELECT, INSERT, DELETE, ...). gentoo-linux ~x86 gcc-4.1.1 mysql-4.1.21 apache-2.0.59 php-5.1.6 (r6) (gentoo) php5.2-200610201630 (php.net snapshot) Strange: On an other box with almost the same software the bug does not occure (gcc-3.4.3 (!), mysql-4.1.21, apache-2.0.59, php-5.1.6 (r6)) Reproduce code: --------------- <?php $conn = new PDO('mysql:host=localhost;dbname=test', 'root', 'extremlysecret'); $conn->query('CREATE TABLE IF NOT EXISTS dummy ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , foo VARCHAR( 64 ) NOT NULL ) ENGINE = MYISAM'); $ps = $conn->prepare("INSERT INTO dummy (foo) VALUES (?)"); $ps->execute(array('first try')); $ps = $conn->prepare("INSERT INTO dummy (foo) VALUES (:val)"); $val = 'second try'; $ps->bindParam(':val', $val); $ps->execute(); $ps = $conn->exec("INSERT INTO dummy (foo) VALUES ('this is lame but works')"); print_r($conn->query('SELECT * FROM dummy')->fetchAll(PDO::FETCH_OBJ)); ?> Expected result: ---------------- Array ( [0] => stdClass Object ( [id] => 1 [foo] => first try ) [1] => stdClass Object ( [id] => 2 [foo] => second try ) [2] => stdClass Object ( [id] => 3 [foo] => this is lame but works ) ) Actual result: -------------- Array ( [0] => stdClass Object ( [id] => 1 [foo] => ) [1] => stdClass Object ( [id] => 2 [foo] => ) [2] => stdClass Object ( [id] => 3 [foo] => this is lame but works ) ) -- Edit bug report at http://bugs.php.net/?id=39218&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=39218&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=39218&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=39218&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=39218&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=39218&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=39218&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=39218&r=needscript Try newer version: http://bugs.php.net/fix.php?id=39218&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=39218&r=support Expected behavior: http://bugs.php.net/fix.php?id=39218&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=39218&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=39218&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=39218&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=39218&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=39218&r=dst IIS Stability: http://bugs.php.net/fix.php?id=39218&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=39218&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=39218&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=39218&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=39218&r=mysqlcfg