==============================
Create Mysql Table
==============================
CREATE TABLE iptocountry (
ip_from varchar(12) NOT NULL default '',
ip_to varchar(12) NOT NULL default '',
country_code2 char(2) default NULL,
country_code3 char(3) default NULL,
country_name varchar(50) default NULL
) TYPE=MyISAM;
==============================
Make a file example upload.php
==============================
$mysql_host = 'localhost';
$mysql_username = 'username';
$mysql_password = 'password';
$mysql_dbName = 'database';
$dbh = mysql_connect("$mysql_host", "$mysql_username", "$mysql_password");
mysql_select_db("$mysql_dbName");
$fl="ip-to-country.txt";
?>
========================
$fp=fopen($fl, "r");
$fr=fread($fp, filesize($fl));
$line=explode("\n", $fr);
$fno = 0;
for($i=1; $i
mysql_query("INSERT INTO iptocountry (ip_from,ip_to,country_code2,country_code3,country_name) VALUES ('$lin[0]','$lin[1]','$lin[2]','$lin[3]','$lin[4]')");
}
mysql_close($dbh);
Demo site http://iptocountry.mallam.com
========================
