ID: 41027 Updated by: [email protected] Reported By: martin at bangaroo dot net -Status: Open +Status: Wont fix Bug Type: PDO related Operating System: Gentoo Linux PHP Version: 5.*, 6CVS (2009-04-27) New Comment:
This behavior is made clear from the documentation: - bindParam() keeps a reference to the variable - the third parameter to bindParam() is $data_type, which defaults to PDO::PARAM_STR. Thus, when execute() is called, the variable is changed a type of $data_type. There does not appear to be a PDO::PARAM_FLOAT or PDO::PARAM_DOUBLE. If that is your complaint, then please open a feature request for PDO. Previous Comments: ------------------------------------------------------------------------ [2009-09-22 17:57:52] [email protected] Thank you for your bug report. A workaround would be to use bindValue instead of bindParam. ------------------------------------------------------------------------ [2009-04-27 20:47:18] martin at bangaroo dot net Same result with php5.3-200904271830: Bug still present. ------------------------------------------------------------------------ [2009-04-26 18:30:35] martin at bangaroo dot net I just checked with the snapshot php5.2-200904261630. Unfortunately the bug still exists. ------------------------------------------------------------------------ [2007-04-09 14:31:34] martin at bangaroo dot net Description: ------------ Executing a prepared statement changes the type of bound parameters to string (Tested only with pgsql driver). This bite me when I wanted to execute an insert statement only when the double value to be inserted actually changed, NULL being a possible value. Unfortunatly, comparing the new value with the old value with the !== operator didn't work, because the type-change made the test always evaluate to TRUE. Reproduce code: --------------- <?php $db = new PDO("pgsql:host=localhost dbname=test user=dummy"); $db->query("CREATE TABLE test_table ( val REAL )"); $qry = $db->prepare("INSERT INTO test_table VALUES (:val)"); $qry->bindParam(":val",$bound_val); $bound_val = 5.2; echo "Type before execute(): ".gettype($bound_val)."\n"; $qry->execute(); echo "Type after execute(): ".gettype($bound_val)."\n"; $db->query("DROP TABLE test"); ?> Expected result: ---------------- Type before execute(): double Type after execute(): double Actual result: -------------- Type before execute(): double Type after execute(): string ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=41027&edit=1
