IP Address to Country in PHP

<?php // LOAD SCRIPT
error_reporting(E_ALL);


// DEMONSTRATE HOW TO LOAD THE IP-TO-COUNTRY DATA FROM MAXMIND GEOLITE
// http://geolite.maxmind.com/download/geoip/database/GeoIPCountryCSV.zip
// ON JULY 1, 2010 THE FILE HAD 129,763 ROWS


// PUT THE NAME OF THE DOWNLOADED CSV FILE HERE
$csv = 'GeoIPCountryWhois.csv';


// CONNECTION AND SELECTION VARIABLES FOR THE DATABASE
$db_host = "localhost"; // PROBABLY THIS IS OK
$db_name = "??";        // GET THESE FROM YOUR HOSTING COMPANY
$db_user = "??";
$db_word = "??";

// OPEN A CONNECTION TO THE DATA BASE SERVER
if (!$dbcx = mysql_connect("$db_host", "$db_user", "$db_word"))
{
   $errmsg = mysql_errno() . ' ' . mysql_error();
   echo "<br/>NO DB CONNECTION: ";
   echo "<br/> $errmsg <br/>";
}

// SELECT THE MYSQL DATA BASE
if (!$db_sel = mysql_select_db($db_name, $dbcx))
{
   $errmsg = mysql_errno() . ' ' . mysql_error();
   echo "<br/>NO DB SELECTION: ";
   echo "<br/> $errmsg <br/>";
   die('NO DATA BASE');
}
// IF WE GOT THIS FAR WE CAN DO QUERIES

// REMOVE THE OLD DATA BASE TABLE, IF ANY (IGNORE ERRORS)
mysql_query('DROP TABLE ip2country');

// CREATE THE NEW TABLE
$sql 
= " CREATE TABLE ip2country "
. " ( "
. " ip_string_lo VARCHAR(16)  NOT NULL, "
. " ip_string_hi VARCHAR(16)  NOT NULL, "
. " ip_number_lo INT UNSIGNED NOT NULL, "
. " ip_number_hi INT UNSIGNED NOT NULL, "
. " country_code VARCHAR(2)   NOT NULL, "
. " country_name VARCHAR(64)  NOT NULL "
. " ) "
;
if (!$res = mysql_query($sql, $dbcx))
{
    // MAN PAGE: http://us.php.net/manual/en/function.mysql-error.php
    $errmsg = mysql_errno() . ' ' . mysql_error();
    echo "<br/>QUERY FAIL: ";
    echo "<br/>$sql <br/>";
    die($errmsg);
}

// OPEN THE CSV FILE AND LOAD THE TABLE
$fp = fopen($csv, 'r');
if (!$fp) die("FAIL: UNABLE TO OPEN $csv");

// READ EACH ROW OF THE IP AND COUNTRY INFORMATION
$kount = 0;
while (!feof($fp))
{
    $row = fgetcsv($fp);
    
    // IGNORE ERRORS
    if (!$row) continue;
    
    // COUNT VALID RECORDS
    $kount++;

    // IF COUNTRY IS LIKE Korea, Republic of - RECONSTRUCT THE NAME
    if (strpos($row[5], ','))
    {
        $x = explode(',', $row[5]);
        $row[5] = trim($x[1]) . ' ' . $x[0];
    }
    
    // CONSTRUCT AND RUN A QUERY TO INSERT THE DATA
    $sql 
    = " INSERT INTO ip2country ( ip_string_lo, ip_string_hi, ip_number_lo, ip_number_hi, country_code, country_name ) "
    . " VALUES "
    . " ( "
    . " '" . mysql_real_escape_string($row[0]) . "', "
    . " '" . mysql_real_escape_string($row[1]) . "', "
    .        mysql_real_escape_string($row[2]) . ", "
    .        mysql_real_escape_string($row[3]) . ", "
    . " '" . mysql_real_escape_string($row[4]) . "', "
    . " '" . mysql_real_escape_string($row[5]) . "' "
    . " ) "
    ;
    if (!$res = mysql_query($sql, $dbcx))
    {
        $errmsg = mysql_errno() . ' ' . mysql_error();
        echo "<br/>QUERY FAIL: ";
        echo "<br/>$sql <br/>";
        die($errmsg);
    }
}
echo "IP-TO-COUNTRY TABLE LOADED WITH " . number_format($kount) . " RECORDS<br/>";

// ALTER THE TABLE TO ADD INDEXES
mysql_query("ALTER TABLE `ip2country` ADD INDEX ( `ip_number_lo` )" );
mysql_query("ALTER TABLE `ip2country` ADD INDEX ( `ip_number_hi` )" );

// ALL DONE.
die("INDEXING COMPLETE");

                                    

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:

<?php // REST
error_reporting(E_ALL);


// DEMONSTRATE HOW TO USE THE IP-TO-COUNTRY DATA FROM MAXMIND GEOLITE
// A RESTful SERVICE TO LOOK UP THE COUNTRY INFORMATION FOR A GIVEN IP ADDRESS
// http://www.maxmind.com/app/geoip_country
// ON JULY 1, 2010 THE FILE HAD 129,763 ROWS


// CONNECTION AND SELECTION VARIABLES FOR THE DATABASE
$db_host = "localhost"; // PROBABLY THIS IS OK
$db_name = "??";        // GET THESE FROM YOUR HOSTING COMPANY
$db_user = "??";
$db_word = "??";

// OPEN A CONNECTION TO THE DATA BASE SERVER
if (!$dbcx = mysql_connect("$db_host", "$db_user", "$db_word"))
{
    die("ERROR: QUERY FAILED " . mysql_errno() . ' ' . mysql_error() );
}

// SELECT THE MYSQL DATA BASE
if (!$db_sel = mysql_select_db($db_name, $dbcx))
{
    die("ERROR: QUERY FAILED " . mysql_errno() . ' ' . mysql_error() );
}
// IF WE GOT THIS FAR WE CAN DO QUERIES

// IF NO IP ADDRESS IS GIVEN, USE THE REMOTE ADDRESS OF THE CLIENT
$ip = $_SERVER["REMOTE_ADDR"];
if (!empty($_GET["ip"])) $ip = $_GET["ip"];

// CONVERT TO BINARY - SEE http://php.net/manual/en/function.ip2long.php
$x = ip2long($ip);
if ($x === FALSE) die('ERROR: INVALID IP ADDRESS');

// IP ADDRESSES ARE UNSIGNED AND MAY RETURN NEGATIVE VALUES
$ip_number = sprintf('%u', $x);

// QUERY FOR THE BINARY VALUE
$sql
= " SELECT country_code, country_name FROM ip2country WHERE $ip_number "
. " BETWEEN ip_number_lo AND ip_number_hi "
. " LIMIT 1 "
;
if (!$res = mysql_query($sql, $dbcx))
{
    die("ERROR: QUERY FAILED " . mysql_errno() . ' ' . mysql_error() );
}

// DID WE FIND ANYTHING?
$num = mysql_num_rows($res);
if (!$num) die("ERROR: NO DATA FOUND");

// YES, WE FOUND THE COUNTRY
$row = mysql_fetch_assoc($res);
die("{$row["country_code"]},{$row["country_name"]}");
                                    

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58: