ID: 39398
User updated by: develar at gmail dot com
Reported By: develar at gmail dot com
Status: Open
Bug Type: PDO related
Operating System: Debian 3
PHP Version: 5.2.0
New Comment:
var_dump($Db->query('SELECT * FROM test')->fetchAll());
Previous Comments:
------------------------------------------------------------------------
[2006-11-06 11:56:04] develar at gmail dot com
Description:
------------
PDO does not cast a variable with boolean type in bindValue, does not
do execute and is silent.
I should cast manually - (int).
Reproduce code:
---------------
CREATE TABLE `test` (
`test` tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
$Db = new PDO('mysql:host=localhost;dbname=test', 'root', '');
$Db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$Db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$boolean = 1;
$Pdo = $Db->prepare('INSERT INTO test VALUES (:boolean)');
$Pdo->bindValue(':boolean', isset($boolean), PDO::PARAM_INT);
$Pdo->execute();
Expected result:
----------------
array(1) { [0]=> array(1) { ["test"]=> string(1) "1" } }
Actual result:
--------------
array(0) { }
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=39398&edit=1
