mirror of
https://github.com/php/php-src.git
synced 2025-08-15 21:48:51 +02:00
7f2f0c007c
For rationale, see #6787 Extensions migrated in part 4: * simplexml * skeleton * soap * spl * sqlite3 * sysvmsg * sysvsem * tidy - also removed a check for an ancient dependency version
69 lines
1.2 KiB
PHP
69 lines
1.2 KiB
PHP
--TEST--
|
|
Bug #68849 bindValue is not using the right data type
|
|
--EXTENSIONS--
|
|
sqlite3
|
|
--FILE--
|
|
<?php
|
|
|
|
$db = new SQLite3(':memory:');
|
|
|
|
$db->exec("CREATE TABLE test (a INTEGER, b TEXT, c REAL);" .
|
|
"INSERT INTO test VALUES (1, 'hello', 3.14);" .
|
|
"INSERT INTO test VALUES (3, 'world', 3.15);" .
|
|
"INSERT INTO test VALUES (0, '42', 0.42);"
|
|
);
|
|
|
|
$s = $db->prepare('SELECT * FROM test WHERE (a+2) = ?;');
|
|
$s->bindValue(1, 3);
|
|
$r = $s->execute();
|
|
var_dump($r->fetchArray(SQLITE3_ASSOC));
|
|
|
|
$s = $db->prepare('SELECT * FROM test WHERE a = ?;');
|
|
$s->bindValue(1, true);
|
|
$r = $s->execute();
|
|
var_dump($r->fetchArray(SQLITE3_ASSOC));
|
|
|
|
$s = $db->prepare('SELECT * FROM test WHERE a = ?;');
|
|
$s->bindValue(1, false);
|
|
$r = $s->execute();
|
|
var_dump($r->fetchArray(SQLITE3_ASSOC));
|
|
|
|
$s = $db->prepare('SELECT * FROM test WHERE c = ?;');
|
|
$s->bindValue(1, 3.15);
|
|
$r = $s->execute();
|
|
var_dump($r->fetchArray(SQLITE3_ASSOC));
|
|
|
|
?>
|
|
--EXPECT--
|
|
array(3) {
|
|
["a"]=>
|
|
int(1)
|
|
["b"]=>
|
|
string(5) "hello"
|
|
["c"]=>
|
|
float(3.14)
|
|
}
|
|
array(3) {
|
|
["a"]=>
|
|
int(1)
|
|
["b"]=>
|
|
string(5) "hello"
|
|
["c"]=>
|
|
float(3.14)
|
|
}
|
|
array(3) {
|
|
["a"]=>
|
|
int(0)
|
|
["b"]=>
|
|
string(2) "42"
|
|
["c"]=>
|
|
float(0.42)
|
|
}
|
|
array(3) {
|
|
["a"]=>
|
|
int(3)
|
|
["b"]=>
|
|
string(5) "world"
|
|
["c"]=>
|
|
float(3.15)
|
|
}
|