<?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);
