diff options
| -rwxr-xr-x | ext/sqlite/tests/sqlite_003.phpt | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/ext/sqlite/tests/sqlite_003.phpt b/ext/sqlite/tests/sqlite_003.phpt new file mode 100755 index 0000000000..4ae38b33d6 --- /dev/null +++ b/ext/sqlite/tests/sqlite_003.phpt @@ -0,0 +1,49 @@ +--TEST-- +sqlite: Simple insert/select, different result represenatation +--SKIPIF-- +<?php +if (!extension_loaded("sqlite")) print "skip"; ?> +--FILE-- +<?php +include "blankdb.inc"; + +sqlite_query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))", $db); +sqlite_query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)", $db); +$r = sqlite_query("SELECT * from foo", $db); +var_dump(sqlite_fetch_array($r, SQLITE_BOTH)); +$r = sqlite_query("SELECT * from foo", $db); +var_dump(sqlite_fetch_array($r, SQLITE_NUM)); +$r = sqlite_query("SELECT * from foo", $db); +var_dump(sqlite_fetch_array($r, SQLITE_ASSOC)); +?> +--EXPECT-- +array(6) { + [0]=> + string(10) "2002-01-02" + ["c1"]=> + string(10) "2002-01-02" + [1]=> + string(8) "12:49:00" + ["c2"]=> + string(8) "12:49:00" + [2]=> + NULL + ["c3"]=> + NULL +} +array(3) { + [0]=> + string(10) "2002-01-02" + [1]=> + string(8) "12:49:00" + [2]=> + NULL +} +array(3) { + ["c1"]=> + string(10) "2002-01-02" + ["c2"]=> + string(8) "12:49:00" + ["c3"]=> + NULL +} |