<?php
$db = new SQLite3(':memory:');
$db->enableExceptions(true);
$stmt = $db->prepare('SELECT :a;');
$a = 42;
$stmt->bindParam(':a', $a);
echo "Execute statement\n";
var_dump($res = $stmt->execute());
echo "Statement result\n";
var_dump($res->fetchArray(SQLITE3_NUM));
$a = 50;
echo "Change binded values\n";
$stmt->bindValue(':a', 'TEST');
echo "Execute statement\n";
var_dump($res = $stmt->execute());
echo "Statement result\n";
var_dump($res->fetchArray(SQLITE3_NUM));
$stmt->reset();
- 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.27, 8.2.0 - 8.2.17, 8.3.0 - 8.3.4
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(4) "TEST"
}
- Output for 7.0.0 - 7.0.31, 7.1.0 - 7.1.1, 7.1.7 - 7.1.23, 7.2.0 - 7.2.11
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) ":a"
}
- Output for 7.1.2 - 7.1.6
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "TE"
}
- Output for 5.4.4, 5.4.10, 5.4.15, 5.4.21, 5.4.27, 5.4.29, 5.5.1, 5.5.9, 5.6.17, 5.6.38
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�`"
}
- Output for 5.4.5 - 5.4.6, 5.4.37, 5.4.45, 5.5.3, 5.5.7, 5.6.1, 5.6.35 - 5.6.37
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�"
}
- Output for 5.6.0, 5.6.4, 5.6.6 - 5.6.8, 5.6.10 - 5.6.11, 5.6.21, 5.6.23, 5.6.26, 5.6.29, 5.6.33 - 5.6.34
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�"
}
- Output for 5.5.0, 5.5.2, 5.5.17, 5.5.27, 5.5.29, 5.5.33, 5.6.5, 5.6.12, 5.6.20, 5.6.25, 5.6.32
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "� "
}
- Output for 5.4.3, 5.4.17, 5.4.26, 5.4.31, 5.5.19, 5.5.25, 5.5.36, 5.6.31
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(1) "�"
}
- Output for 5.4.1, 5.4.28, 5.4.34 - 5.4.35, 5.5.6, 5.5.35, 5.6.16, 5.6.30
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�p"
}
- Output for 5.4.0, 5.5.10, 5.5.22, 5.5.34, 5.6.2, 5.6.19, 5.6.28
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�P"
}
- Output for 5.3.4, 5.3.7 - 5.3.8, 5.3.16 - 5.3.18, 5.3.20, 5.3.22, 5.3.24, 5.3.26, 5.4.8 - 5.4.9, 5.4.11 - 5.4.14, 5.4.18, 5.4.20, 5.4.22, 5.4.24 - 5.4.25, 5.4.32 - 5.4.33, 5.4.36, 5.4.38, 5.4.42, 5.4.44, 5.5.4 - 5.5.5, 5.5.8, 5.5.11 - 5.5.12, 5.5.15, 5.5.18, 5.5.20 - 5.5.21, 5.5.23 - 5.5.24, 5.5.26, 5.5.28, 5.5.30 - 5.5.32, 5.5.38, 5.6.3, 5.6.9, 5.6.13 - 5.6.14, 5.6.18, 5.6.22, 5.6.27
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "��"
}
- Output for 5.4.2, 5.4.7, 5.4.16, 5.4.23, 5.4.39, 5.5.13 - 5.5.14, 5.5.16, 5.6.24
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�@"
}
- Output for 5.4.19, 5.4.30, 5.4.40 - 5.4.41, 5.4.43, 5.5.37, 5.6.15
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�0"
}
- Output for 5.3.29
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "X
"
}
- Output for 5.3.28
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "X="
}
- Output for 5.3.27
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "X�"
}
- Output for 5.3.25
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�Z"
}
- Output for 5.3.15, 5.3.23
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�J"
}
- Output for 5.3.21
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�:"
}
- Output for 5.3.19
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�z"
}
- Output for 5.3.14
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�"
}
- Output for 5.3.13
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�*"
}
- Output for 5.3.12
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "Ȋ"
}
- Output for 5.3.11
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "Ț"
}
- Output for 5.3.10
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "@H"
}
- Output for 5.3.9
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "@�"
}
- Output for 5.3.6
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�6"
}
- Output for 5.3.5
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�"
}
- Output for 5.3.1, 5.3.3
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "`�"
}
- Output for 5.3.2
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) " "
}
- Output for 5.3.0
- Execute statement
object(SQLite3Result)#3 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "42"
}
Change binded values
Execute statement
object(SQLite3Result)#4 (0) {
}
Statement result
array(1) {
[0]=>
string(2) "�"
}
- Output for 5.0.0 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17
- Fatal error: Class 'SQLite3' not found in /in/vkcnQ on line 3
Process exited with code 255. - Output for 4.3.2 - 4.3.11, 4.4.0 - 4.4.9
- Fatal error: Cannot instantiate non-existent class: sqlite3 in /in/vkcnQ on line 3
Process exited with code 255. - Output for 4.3.0 - 4.3.1
- Fatal error: Cannot instantiate non-existent class: sqlite3 in /in/vkcnQ on line 3
preferences:
300.94 ms | 401 KiB | 407 Q