5 if (!extension_loaded("sqlite")) print "skip"; ?>
10 sqlite_query($db, "CREATE TABLE test_db ( id INTEGER PRIMARY KEY, data VARCHAR(100) )");
11 for ($i = 0; $i < 10; $i++) {
12 sqlite_query($db, "INSERT INTO test_db (data) VALUES('{$i}data')");
14 sqlite_query($db, "INSERT INTO test_db (data) VALUES(NULL)");
16 var_dump(sqlite_single_query($db, "SELECT id FROM test_db WHERE id=5"));
17 var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id=4"));
18 var_dump(sqlite_single_query($db, "SELECT data FROM test_db WHERE id=6"));
19 var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id < 5"));
20 var_dump(sqlite_single_query($db, "SELECT * FROM test db WHERE id < 4"));
21 var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id=999999"));
22 var_dump(sqlite_single_query($db, "SELECT id FROM test_db WHERE id=5", FALSE));
41 Warning: sqlite_single_query(): no such table: test in %s on line %d