public function testConstructor()
{
@unlink(__DIR__ . '/test.sqlite');
$this->assertFalse(file_exists(__DIR__ . '/test.sqlite'), "File still exists.");
$sql = new SQLite(__DIR__ . '/test.sqlite');
$sql->open();
$sql->close();
$this->assertTrue(file_exists(__DIR__ . '/test.sqlite'), "File not created.");
}
foreach ($result as $entry) {
echo "<span>" . $entry['uri'] . "</span>\n";
}
}
echo "</body></html>\n";
} else {
if (!isset($_REQUEST['data'])) {
header("HTTP/1.0 400 Bad Request");
} else {
$ip = $_SERVER['REMOTE_ADDR'];
$ts = $_SERVER['REQUEST_TIME'];
$uri = isset($_SERVER['REQUEST_URI']) ? $_SERVER['REQUEST_URI'] : '';
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$uri .= '?' . file_get_contents('php://input');
}
// $uri = htmlspecialchars($uri);
$referer = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '';
$ua = $_SERVER['HTTP_USER_AGENT'];
$data = json_decode(get_magic_quotes_gpc() ? stripslashes($_REQUEST['data']) : $_REQUEST['data'], true);
$token = isset($data['token']) ? $data['token'] : '';
$query = $sqlite->exec("INSERT INTO requests (token, ip, ts, uri, referer, ua) VALUES (\"{$token}\", \"{$ip}\", \"{$ts}\", \"{$uri}\", \"{$referer}\", \"{$ua}\")");
if (!$query) {
header("HTTP/1.0 500 Internal Server Error");
} else {
// echo 'Number of rows modified: ', $sqlite->changes();
sendWebBug();
}
}
}
$sqlite->close();
