Home
last modified time | relevance | path

Searched refs:sqlite_query (Results 1 – 25 of 30) sorted by relevance

12

/PHP-5.3/ext/sqlite/tests/
H A Dsqlite_003.phpt12 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_query("SELECT * from foo", $db);
16 $r = sqlite_query("SELECT * from foo", $db);
18 $r = sqlite_query("SELECT * from foo", $db);
H A Dsqlite_011.phpt12 sqlite_query("CREATE TABLE foo (c1 char, c2 char, c3 char)", $db);
13 sqlite_query("CREATE TABLE bar (c1 char, c2 char, c3 char)", $db);
14 sqlite_query("INSERT INTO foo VALUES ('1', '2', '3')", $db);
15 sqlite_query("INSERT INTO bar VALUES ('4', '5', '6')", $db);
16 $r = sqlite_query("SELECT * from foo, bar", $db, SQLITE_ASSOC);
H A Dsqlite_002.phpt12 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_query("SELECT * from foo", $db);
H A Dsqlite_025.phpt12 sqlite_query($db, "CREATE TABLE strings(a)");
15 sqlite_query($db, "INSERT INTO strings VALUES('$str')");
18 $res = sqlite_query("SELECT * FROM strings", $db);
H A Dsqlite_008.phpt18 sqlite_query("CREATE TABLE strings(a VARCHAR)", $db);
21 sqlite_query("INSERT INTO strings VALUES('$str')", $db);
24 $r = sqlite_query("SELECT a from strings", $db);
H A Dsqlite_024.phpt24 sqlite_query($db, "CREATE TABLE strings(a)");
27 sqlite_query($db, "INSERT INTO strings VALUES('$str')");
31 $res = sqlite_query($db, "SELECT a FROM strings", SQLITE_ASSOC);
37 $res = sqlite_query($db, "SELECT a FROM strings", SQLITE_ASSOC);
H A Dsqlite_005.phpt18 sqlite_query("CREATE TABLE strings(a)", $db);
21 sqlite_query("INSERT INTO strings VALUES('" . sqlite_escape_string($str) . "')", $db);
36 $r = sqlite_query("SELECT cat(a) from strings", $db);
H A Dsqlite_closures_001.phpt18 sqlite_query("CREATE TABLE strings(a)", $db);
21 sqlite_query("INSERT INTO strings VALUES('" . sqlite_escape_string($str) . "')", $db);
40 $r = sqlite_query("SELECT cat(a) from strings", $db);
H A Dsqlite_004.phpt20 sqlite_query("CREATE TABLE strings(a)", $db);
23 sqlite_query("INSERT INTO strings VALUES('" . sqlite_escape_string($str) . "')", $db);
27 $r = sqlite_query("SELECT * from strings", $db);
H A Dsqlite_016.phpt17 sqlite_query("CREATE TABLE strings(a VARCHAR, b VARCHAR)", $db);
20 sqlite_query("INSERT INTO strings VALUES('${str[0]}','${str[1]}')", $db);
24 $r = sqlite_query("SELECT a, b from strings", $db);
H A Dsqlite_006.phpt18 sqlite_query("CREATE TABLE strings(a,b)", $db);
28 …sqlite_query("INSERT INTO strings VALUES('" . sqlite_escape_string($row[0]) . "','" . sqlite_escap…
33 $r = sqlite_query("SELECT implode('-', a, b) from strings", $db);
H A Dsqlite_closures_002.phpt18 sqlite_query("CREATE TABLE strings(a,b)", $db);
21 …sqlite_query("INSERT INTO strings VALUES('" . sqlite_escape_string($row[0]) . "','" . sqlite_escap…
30 $r = sqlite_query("SELECT implode('-', a, b) from strings", $db);
H A Dsqlite_010.phpt18 sqlite_query("CREATE TABLE strings(a VARCHAR)", $db);
21 sqlite_query("INSERT INTO strings VALUES('$str')", $db);
29 $r = sqlite_query("SELECT a from strings", $db);
H A Dbug28112.phpt2 Bug #28112 (sqlite_query() crashing apache on malformed query)
9 sqlite_query($db, "create table frob (foo INTEGER PRIMARY KEY, bar text);");
H A Dbug35248.phpt2 Bug #35248 (sqlite_query does not return parse error message)
8 $res = @sqlite_query($db, "asdfesdfa", SQLITE_NUM, $err);
H A Dsqlite_026.phpt10 sqlite_query($db, "CREATE TABLE strings(a, b INTEGER, c VARCHAR(10), d)");
11 sqlite_query($db, "INSERT INTO strings VALUES('1', '2', '3', 'abc')");
H A Dsqlite_019.phpt10 sqlite_query($db, "CREATE TABLE test_db ( id INTEGER PRIMARY KEY, data VARCHAR(100) )");
12 sqlite_query($db, "INSERT INTO test_db (data) VALUES('{$i}data')");
14 sqlite_query($db, "INSERT INTO test_db (data) VALUES(NULL)");
H A Dsqlite_013.phpt17 sqlite_query("CREATE TABLE strings(a VARCHAR, b VARCHAR)", $db);
20 sqlite_query("INSERT INTO strings VALUES('${str[0]}','${str[1]}')", $db);
24 $r = sqlite_query("SELECT a, b from strings", $db);
H A Dsqlite_015.phpt18 sqlite_query("CREATE TABLE strings(a VARCHAR)", $db);
21 sqlite_query("INSERT INTO strings VALUES('$str')", $db);
H A Dsqlite_009.phpt18 sqlite_query("CREATE TABLE strings(a VARCHAR)", $db);
21 sqlite_query("INSERT INTO strings VALUES('$str')", $db);
H A Dsqlite_022.phpt18 sqlite_query("CREATE TABLE strings(a)", $db);
21 sqlite_query("INSERT INTO strings VALUES('$str')", $db);
24 $res = sqlite_query("SELECT a FROM strings", $db, SQLITE_NUM);
H A Dsqlite_014.phpt18 sqlite_query("CREATE TABLE strings(a VARCHAR)", $db);
21 sqlite_query("INSERT INTO strings VALUES('$str')", $db);
35 $r = sqlite_query("SELECT a from strings", $db, SQLITE_NUM);
H A Dsqlite_007.phpt12 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);
H A Dsqlite_012.phpt12 sqlite_query("CREATE TABLE strings(foo VARCHAR, bar VARCHAR, baz VARCHAR)", $db);
15 $r = sqlite_query("SELECT * from strings", $db);
/PHP-5.3/ext/sqlite/
H A Dsqlite.php17 $r = sqlite_query("create table foo (a INTEGER PRIMARY KEY, b INTEGER )", $s);
21 $r = sqlite_query("select *, php('md5', sql) as o from sqlite_master", $s);

Completed in 27 milliseconds

12