WorldIP - free geolocation database, service and tools

The table worldip contains fields start, end and code. Every row means a network. start and end are integer fields with IP numbers, code is a double-character country code, like "US".
You can convert every IP address to IP number with following formula:

IP Number = 16777216*A + 65536*B + 256*C + D
where IP Address = A.B.C.D

There is function ip2long($ip_address) in PHP that returns IP number.
For example, IP Address 91.121.147.207 converts to the IP number 1534694351

Than you can get the country code with following request:

SELECT code FROM worldip WHERE start<=IP_NUMBER and end>=IP_NUMBER

If you install second table with country names, you get both country code and name with this request:

SELECT wl.code,wl.country FROM worldip w LEFT JOIN worldip_land wl ON (w.code=wl.code) WHERE w.start<=IP_NUMBER and w.end>=IP_NUMBER

or just country name:

SELECT wl.country FROM worldip_land wl LEFT JOIN worldip w ON (w.code=wl.code) WHERE w.start<=IP_NUMBER and w.end>=IP_NUMBER

If you use API (to get the most current date), you can install only one tabel with country names.

SELECT country FROM worldip_land WHERE code="GB"

gives back "United Kingdom"

INSERT INTO `worldip` (`start`, `end`, `code`) VALUES 

(3648419328, 3648419455, 'FR'),

(3648446464, 3648447055, 'FR');

SELECT inet_ntoa(start), inet_ntoa(end) FROM worldip WHERE code="FR"

+------------------+-----------------+

| 212.43.192.0     | 212.43.255.255  |

| 212.44.224.0     | 212.44.255.255  |

| 212.47.224.0     | 212.47.255.255  |

+------------------+-----------------+

<?php

echo ip2long('130.244.196.90').' '.ip2longer('130.244.196.90');

//-2097888166 2197079130



function ip2longer($ip)

{

	return sprintf("%u", ip2long($ip));

}

?>