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