<?php
@exec('rm /tmp/lb.db');
$db = sqlite_open('/tmp/lb.db', 0666, $sqliteerror);
if ($db) {
sqlite_query($db, 'CREATE TABLE foo (bar varchar(10))');
sqlite_query($db, "INSERT INTO foo VALUES ('fnord')");
$result = sqlite_query($db,'select bar from foo');
$record = sqlite_fetch_array($result);
echo "<pre>";
var_dump($record);
echo "</pre>";
} else {
die ($sqliteerror);
}
?>