<?php
$db = new SQLite3(':memory:');
$db->enableExceptions(true);
$stmt = $db->prepare('SELECT :a, :b, ?;');
$a = 42;
$stmt->bindParam(':a', $a, SQLITE3_INTEGER);
$stmt->bindValue(':b', 'php');
$stmt->bindValue(':b', 'PHP');
$stmt->bindValue(3, 43);
echo "Execute statement\n";
var_dump($res = $stmt->execute());
echo "Statement result\n";
var_dump($res->fetchArray(SQLITE3_NUM));
//$stmt->reset();
echo "Change binded values\n";
$stmt->bindValue(':a', 'TEST');
$stmt->bindValue(':b', '!!!');
$stmt->bindValue(3, 40, SQLITE3_INTEGER);
$a = 50;
echo "Execute statement\n";
var_dump($res = $stmt->execute());
echo "Statement result\n";
var_dump($res->fetchArray(SQLITE3_NUM));
- Output for 7.2.29 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.4, 8.3.6
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(3) {
[0]=>
int(42)
[1]=>
string(3) "PHP"
[2]=>
int(43)
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(3) {
[0]=>
string(4) "TEST"
[1]=>
string(3) "!!!"
[2]=>
int(40)
}
- Output for 8.3.5
- Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(3) {
[0]=>
int(42)
[1]=>
string(3) "PHP"
[2]=>
int(43)
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(3) {
[0]=>
string(4) "TEST"
[1]=>
string(3) "!!!"
[2]=>
int(40)
}
- Output for 7.1.0 - 7.1.23, 7.2.0 - 7.2.11
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(3) {
[0]=>
int(42)
[1]=>
string(3) "PHP"
[2]=>
int(43)
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(3) {
[0]=>
int(42)
[1]=>
string(3) "PHP"
[2]=>
int(43)
}
- Output for 5.6.38
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(3) {
[0]=>
int(42)
[1]=>
string(3) "PHP"
[2]=>
string(2) "43"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(3) {
[0]=>
int(42)
[1]=>
string(3) "PHP"
[2]=>
string(2) "x�"
}
preferences:
156.19 ms | 402 KiB | 173 Q