Tweet
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
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+CFor 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+CFor 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
Comment