felipe Tue Aug 12 13:37:32 2008 UTC
Added files: (Branch: PHP_5_3)
/php-src/ext/sqlite3/tests bug45798.phpt
Modified files:
/php-src/ext/sqlite3 sqlite3.c
Log:
- MFH: Fixed bug #45798 (sqlite3 doesn't notice if variable was bound)
http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/sqlite3.c?r1=1.1.2.9&r2=1.1.2.10&diff_format=u
Index: php-src/ext/sqlite3/sqlite3.c
diff -u php-src/ext/sqlite3/sqlite3.c:1.1.2.9
php-src/ext/sqlite3/sqlite3.c:1.1.2.10
--- php-src/ext/sqlite3/sqlite3.c:1.1.2.9 Sat Aug 2 04:46:06 2008
+++ php-src/ext/sqlite3/sqlite3.c Tue Aug 12 13:37:32 2008
@@ -16,7 +16,7 @@
+----------------------------------------------------------------------+
*/
-/* $Id: sqlite3.c,v 1.1.2.9 2008/08/02 04:46:06 felipe Exp $ */
+/* $Id: sqlite3.c,v 1.1.2.10 2008/08/12 13:37:32 felipe Exp $ */
#ifdef HAVE_CONFIG_H
#include "config.h"
@@ -1069,6 +1069,7 @@
/* If the ZVAL is null then it should be bound as that
*/
if (Z_TYPE_P(param->parameter) == IS_NULL) {
sqlite3_bind_null(stmt_obj->stmt,
param->param_number);
+ zend_hash_move_forward(stmt_obj->bound_params);
continue;
}
http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/bug45798.phpt?view=markup&rev=1.1
Index: php-src/ext/sqlite3/tests/bug45798.phpt
+++ php-src/ext/sqlite3/tests/bug45798.phpt
--TEST--
Bug #45798 (sqlite3 doesn't notice if variable was bound)
--SKIPIF--
<?php require_once(dirname(__FILE__) . '/skipif.inc'); ?>
--FILE--
<?php
require_once(dirname(__FILE__) . '/new_db.inc');
$db->exec('CREATE TABLE test (time INTEGER, id STRING)');
$db->exec("INSERT INTO test (time, id) VALUES (" . time() . ", 'a')");
$db->exec("INSERT INTO test (time, id) VALUES (" . time() . ", 'b')");
$stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC");
$stmt->bindParam(1, $foo, SQLITE3_TEXT);
$results = $stmt->execute();
while ($result = $results->fetchArray(SQLITE3_NUM)) {
var_dump($result);
}
$results->finalize();
$db->close();
print "done";
?>
--EXPECT--
done
--
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
