Online PHP editor | refs for kNQuO

<?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); }