2
sqlite-oo: Simple insert/select
7
if (!extension_loaded("sqlite")) print "skip"; ?>
10
require_once('blankdb_oo.inc');
13
var_dump($db->query("CREATE TABLE foo(c1 date, c2 time, c3 varchar(64))"));
14
var_dump($db->query("INSERT INTO foo VALUES ('2002-01-02', '12:49:00', NULL)"));
15
$r = $db->query("SELECT * from foo");
17
var_dump($r->fetch());
20
object(SQLiteDatabase)#%d (0) {
22
object(SQLiteResult)#%d (0) {
24
object(SQLiteResult)#%d (0) {
26
object(SQLiteResult)#%d (0) {
30
string(10) "2002-01-02"
32
string(10) "2002-01-02"