IP Address Geolocation From MySQL

In this short tutorial I will use a local MySQL database to do IP addresses geolocation.

First download the database from this page: http://blogama.org/node/58

And then go in your favorite MySQL interface and type:

SELECT * FROM `ip_group_city` where `ip_start` <= 4881709 order by ip_start desc limit 1;

IP addresses use this format (example IP A.B.C.D):

ip = (A*256+B)*256+C

For example, if you have an ip of (Google):

It would become in the database:

ip = (74*256+125)*256+45 = 4881709
Share this page:

9 Comment(s)