Announcement

Collapse
No announcement yet.

IP Address Geolocation From MySQL

Collapse

Ads on showthread pages

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • IP Address Geolocation From MySQL

    WordPress Hosting on SSD Servers
    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

  • #2
    ASP.Net Hosting starts @ $3.18/Mo.
    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.

    Comment

    Working...
    X
    Sign up for a News Letter Click here to sign up