1--TEST-- 2sqlite-oo: 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 10require_once('blankdb_oo.inc'); 11var_dump($db); 12 13var_dump($db->query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))")); 14var_dump($db->query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)")); 15$r = $db->query("SELECT * from foo"); 16var_dump($r); 17var_dump($r->fetch()); 18?> 19--EXPECTF-- 20object(SQLiteDatabase)#%d (0) { 21} 22object(SQLiteResult)#%d (0) { 23} 24object(SQLiteResult)#%d (0) { 25} 26object(SQLiteResult)#%d (0) { 27} 28array(6) { 29 [0]=> 30 string(10) "2002-01-02" 31 ["c1"]=> 32 string(10) "2002-01-02" 33 [1]=> 34 string(8) "12:49:00" 35 ["c2"]=> 36 string(8) "12:49:00" 37 [2]=> 38 NULL 39 ["c3"]=> 40 NULL 41} 42
