The IP to Country Database

You could alternatively use MySQL's LOAD DATA

Great service! Thank you very much.

I run a remotley hosted server and updating the files on the MySQL database mostly caused timeouts, etc.
As i only need the FROM and TO range and the top level domain output (US, AU, etc.) i wrote the small utility below.
The 'ip-to-country.csv' raw file can be uploaded to the server, the file containing the utility can be called and the MySQL db is updated in a flash.


$db = mysql_connect("localhost","username", "password");
mysql_select_db("database_name",$db);

$query="DELETE FROM ip_num";
$result = mysql_query($query,$db);

$fp=fopen('ip-to-country.csv', 'r');

while(!feof($fp)) {

$row=fgets($fp, 4096);
$data=explode("\"", $row);

$query="insert into ip_num VALUES ('$data[1]','$data[3]','$data[5]')";
$result = mysql_query($query,$db);

$num++;
}
mysql_close($db);
fclose($fp);

I had this thing working!!!

I downloaded the latest .csv but it won't load into the mySQL properly. Depending on how I do it, I either get only half the number of rows or I get them all but only the first row has the ip_from and the rest have 0000000

It's got to be me. What am I doing wrong?!?!


Tom Mahoney, Director
merchant911.org

the SQL-statement should be changed to

$sql="insert into ".$mysql["table"]["name"]." ".
"(`".$mysql["table"]["ip_from"]."`, "
."`".$mysql["table"]["ip_to"]."`, "
."`".$mysql["table"]["code"]."`, "
."`".$mysql["table"]["country"]."`) values ".
"('".$ip_start."', '".$ip_end."', '".$code."', '".addslashes($country)."')";

You have to add 'addslashes' because the country name is Cote D'Ivoir.

This should solve the problem!