3v4l.org

run code in 200+ PHP versions simultaneously
<?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.4.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(4) "TEST" }
Output for 7.0.0 - 7.1.1, 7.1.7 - 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.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.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