2
sqlite: Simple insert/select (unbuffered)
7
if (!extension_loaded("sqlite")) print "skip"; ?>
10
include "blankdb.inc";
12
sqlite_query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))", $db);
13
sqlite_query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)", $db);
14
$r = sqlite_unbuffered_query("SELECT * from foo", $db);
15
var_dump(sqlite_fetch_array($r, SQLITE_BOTH));
16
$r = sqlite_unbuffered_query("SELECT * from foo", $db);
17
var_dump(sqlite_fetch_array($r, SQLITE_NUM));
18
$r = sqlite_unbuffered_query("SELECT * from foo", $db);
19
var_dump(sqlite_fetch_array($r, SQLITE_ASSOC));
25
string(10) "2002-01-02"
27
string(10) "2002-01-02"
39
string(10) "2002-01-02"
47
string(10) "2002-01-02"