Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
--TEST-- Bug #68849 bindValue is not using the right data type --EXTENSIONS-- sqlite3 --FI..
Decoded Output download
--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)
}
Did this file decode correctly?
Original Code
--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)
}
Function Calls
None |
Stats
MD5 | 992ed11590c7b3cf549ee35e7cd6bfb7 |
Eval Count | 0 |
Decode Time | 87 ms |