dbfile = $dbfile; //if db file doesn't exist, fill with skeleton if (file_exists($this->dbfile)) { $this->dbres = sqlite_open($this->dbfile, 0666, $sqliteerror); } else { //fill with skeleton $folder = dirname($this->dbfile); if (!is_writable($folder)) { //we need write permission to create database die("

cannot create dabase. check permissions.

\n"); } else { $this->dbres = sqlite_open($this->dbfile, 0666, $sqliteerror); //photo table $sql = "create table photo (id INTEGER PRIMARY KEY, caption TEXT, "; $sql .= "counter INTEGER, number INTEGER, album TEXT, name TEXT)"; $this->query($sql); //comment table $sql = "create table comment (id INTEGER PRIMARY KEY, user TEXT, "; $sql .= "comment_body TEXT, photo_id INT, date DATETIME)"; $this->query($sql); } } } function query($sql) { global $page; if (!$this->result = sqlite_query($this->dbres, $sql)) { print "Query failed,

$sql

\n"; print sqlite_error_string (sqlite_last_error($this->dbres)); $page->footer(); exit; } } function count() { return sqlite_num_rows($this->result); } function rewind() { //just to abstract from sqlite sqlite_rewind($this->result); } } $db = new SQLiteDatabase("$dbfile"); ?>