Online PHP editor | refs for Kb25H

<?php $db = sqlite_open(':memory:'); sqlite_query('CREATE TABLE mytable (foo INTEGER);'); sqlite_query('INSERT INTO mytable (foo) VALUES (1), (2), (3);'); $sql = "SELECT * FROM mytable"; $res = sqlite_query($sql, $db); sqlite_close($db); while ( $thisRow = sqlite_fetch_array($res) ) { print_r($thisRow); }