@ 2014-02-01T13:22:43Z <?php
$db = sqlite_open(':memory:');
sqlite_query('CREATE TABLE mytable (foo INTEGER);', $db);
sqlite_query('INSERT INTO mytable (foo) VALUES (1);', $db);
sqlite_query('INSERT INTO mytable (foo) VALUES (2);', $db);
sqlite_query('INSERT INTO mytable (foo) VALUES (3);', $db);
$sql = "SELECT * FROM mytable";
$res = sqlite_query($sql, $db);
sqlite_close($db);
while ( $thisRow = sqlite_fetch_array($res) )
{
print_r($thisRow);
}
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 7.0.0 - 7.0.20 , 7.1.0 - 7.1.20 , 7.2.0 - 7.2.33 , 7.3.12 - 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.6 Fatal error: Uncaught Error: Call to undefined function sqlite_open() in /in/kNQuO:3
Stack trace:
#0 {main}
thrown in /in/kNQuO on line 3
Process exited with code 255 . Output for 5.4.0 - 5.4.45 , 5.5.24 - 5.5.35 , 5.6.7 - 5.6.28 Fatal error: Call to undefined function sqlite_open() in /in/kNQuO on line 3
Process exited with code 255 . Output for 5.3.0 - 5.3.29 Warning: sqlite_fetch_array(): 5 is not a valid sqlite result resource in /in/kNQuO on line 12
Output for 5.0.0 - 5.0.5 , 5.1.0 - 5.1.6 , 5.2.0 - 5.2.17 Array
(
[0] => 1
[foo] => 1
)
Array
(
[0] => 2
[foo] => 2
)
Array
(
[0] => 3
[foo] => 3
)
Output for 4.4.5 - 4.4.9 Fatal error: Call to undefined function: sqlite_open() in /in/kNQuO on line 3
Process exited with code 255 . Output for 4.3.2 - 4.3.11 , 4.4.0 - 4.4.4 Fatal error: Call to undefined function: sqlite_open() in /in/kNQuO on line 3
Process exited with code 255 . Output for 4.3.0 - 4.3.1 Fatal error: Call to undefined function: sqlite_open() in /in/kNQuO on line 3
preferences:dark mode live preview
254.26 ms | 401 KiB | 314 Q