IP Address Geolocation From MySQL

[kilter]

Re: IP Address Geolocation From MySQL

Hi Ryan,

It is nice way to know the ip address location through my sql. I like this.

But i got information about the ip address from this IP-Details.com : Find your IP address Information only. It is also very helpful for me.It contains more information about this ip address.

cheers.

[ryan]

Follow the steps to locate the IP address:

1) First download the database from this page: IP address geolocation SQL database :: IPInfoDB

IP addresses use this format (example IP A.B.C.D):
ip = (A*256+*256+C
For example, if you have an ip of 74.125.45.100 (Google):
It would become in the database:
ip = (74*256+125)*256+45 = 4881709

2) 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+*256+C
For example, if you have an ip of 74.125.45.100 (Google):
It would become in the database:
ip = (74*256+125)*256+45 = 4881709