1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
|
<?php
/* SQLite DB class for storing
- image views,
- user comments
*/
$dbfile = "$root/$gallery_dir/photos.db";
//unfortunately in php4, the SQLiteDatabse class isn't created so we have to
class SQLiteDatabase {
var $dbfile;
function SQLiteDatabase ($dbfile) {
$this->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("<p style=\"color:red;\">cannot create dabase. check permissions.</p>\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, <span style=\"color: blue;\"><pre>$sql</pre></style>\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");
?>
|
