PHP sqlite_db::unbuffered_query Beispiele

Beispiel #1

Datei: foreach.php Projekt: SandyS1/presentations

<pre>
<?php 
$db = new sqlite_db(dirname(__FILE__) . "/ip.db");
$res = $db->unbuffered_query("SELECT * FROM country_data WHERE cc_code_2='CA'", SQLITE_ASSOC);
foreach ($res as $row) {
    print_r($row);
}
?>
</pre>

Beispiel #2

Datei: oo_rec2.php Projekt: SandyS1/presentations

<?php

chdir(dirname(__FILE__));
// pres2 hack
// sample IP
$_SERVER['REMOTE_ADDR'] = "24.100.195.79";
$ip_int = sprintf("%u", ip2long($_SERVER['REMOTE_ADDR']));
try {
    $db = new sqlite_db("./ip.db");
} catch (sqlite_exception $err) {
    die($err->getMessage() . " in " . $err->getFile() . ":" . $err->getLine());
}
$res = $db->unbuffered_query("\nSELECT country_name \nFROM ip_ranges ir \nINNER JOIN country_data cd ON ir.country_code=cd.id\nWHERE {$ip_int} BETWEEN ip_start AND ip_end");
echo "User is located in " . $res->fetch_single();