1--TEST-- 2sqlite: single query 3--SKIPIF-- 4<?php # vim:ft=php 5if (!extension_loaded("sqlite")) print "skip"; ?> 6--FILE-- 7<?php 8include "blankdb.inc"; 9 10sqlite_query($db, "CREATE TABLE test_db ( id INTEGER PRIMARY KEY, data VARCHAR(100) )"); 11for ($i = 0; $i < 10; $i++) { 12 sqlite_query($db, "INSERT INTO test_db (data) VALUES('{$i}data')"); 13} 14sqlite_query($db, "INSERT INTO test_db (data) VALUES(NULL)"); 15 16var_dump(sqlite_single_query($db, "SELECT id FROM test_db WHERE id=5")); 17var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id=4")); 18var_dump(sqlite_single_query($db, "SELECT data FROM test_db WHERE id=6")); 19var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id < 5")); 20var_dump(sqlite_single_query($db, "SELECT * FROM test db WHERE id < 4")); 21var_dump(sqlite_single_query($db, "SELECT * FROM test_db WHERE id=999999")); 22var_dump(sqlite_single_query($db, "SELECT id FROM test_db WHERE id=5", FALSE)); 23 24sqlite_close($db); 25?> 26--EXPECTF-- 27string(1) "5" 28string(1) "4" 29string(5) "5data" 30array(4) { 31 [0]=> 32 string(1) "1" 33 [1]=> 34 string(1) "2" 35 [2]=> 36 string(1) "3" 37 [3]=> 38 string(1) "4" 39} 40 41Warning: sqlite_single_query(): no such table: test in %s on line %d 42bool(false) 43NULL 44array(1) { 45 [0]=> 46 string(1) "5" 47} 48
