<?php require "./cache.php"; // our cache code // Simple guestbook script. $db = new sqlite_db("gb.sqlite"); $r = $db->array_query("SELECT * FROM guestbook", SQLITE_ASSOC); foreach ($r as $row) { echo $r->user . ' wrote on ' . date("Ymd", $r->date) . ":<br />\n"; echo $r->message . "<hr /><hr />"; }
<?php $db = new sqlite_db(":memory:"); $db->query("CREATE TABLE foobar (id INTEGER PRIMARY KEY, misc CHAR(10))"); $db->query("INSERT INTO foobar (misc) VALUES('Marcus');\n\t\t\tINSERT INTO foobar (misc) VALUES('Ilia')"); /* When performing multiple inserts within a single query * only the id of very last insert is returned */ echo "Last id: " . $db->last_insert_rowid() . "<br />\n"; echo '<pre>'; print_r($db->array_query("SELECT * FROM foobar", SQLITE_ASSOC)); echo '</pre>';
<?php $db = new sqlite_db(dirname(__FILE__) . "/ip.db"); $r = $db->array_query("SELECT * FROM sqlite_master LIMIT 1", SQLITE_ASSOC); echo '<pre>' . print_r($r, true) . '</pre>';
<?php function encode($str) { return str_pad(strlen($str), 10, "0", STR_PAD_LEFT) . $str; } if (!empty($_GET['q'])) { $query = sqlite_escape_string($_GET['q']); /* Query SQLite database */ $db = new sqlite_db("my_db.sqlite"); $result = $db->array_query("SELECT id, descr FROM bug_db WHERE dev='{$query}'"); /* If there are results, encode them using IPIP and send to client */ if ($rows = count($result)) { echo str_pad($rows, 10, "0", STR_PAD_LEFT); foreach ($result as $ent) { echo encode($ent['id']) . encode($ent['descr']); } exit; } } echo str_repeat("0", 10);