1--TEST-- 2sqlite: Simple insert/select 3--INI-- 4sqlite.assoc_case=0 5--SKIPIF-- 6<?php # vim:ft=php 7if (!extension_loaded("sqlite")) print "skip"; ?> 8--FILE-- 9<?php 10include "blankdb.inc"; 11 12sqlite_query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))", $db); 13sqlite_query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)", $db); 14$r = sqlite_query("SELECT * from foo", $db); 15var_dump(sqlite_fetch_array($r)); 16sqlite_close($db); 17?> 18--EXPECT-- 19array(6) { 20 [0]=> 21 string(10) "2002-01-02" 22 ["c1"]=> 23 string(10) "2002-01-02" 24 [1]=> 25 string(8) "12:49:00" 26 ["c2"]=> 27 string(8) "12:49:00" 28 [2]=> 29 NULL 30 ["c3"]=> 31 NULL 32} 33
