Database to match IP to location

Are they available?

[Jeremy_H]

Hello,

I would like to take an IP address and be able to search by it in a MySQL database to find its location.

Ideally it would give country, city (and if in US the ZIP code too) in CSV format.

I don't want to rely on a third party tool, but would like to obtain/purchase a database like this.

Are such databases possible or obtainable, and might they be feasible?

[BlackRaven]

google "ip2nation" its a mysql db and free. Also has a script to get you started on how to find user ip and their corresponding country.

[adb64]

A free database to connect an IP address to a country (not a city) can be downloaded from [ip-to-country.webhosting.info...]

[aspdaddy]

You might also want to look at look at GeoLite (Free) and GeoIP (not free).

[Jeremy_H]

Thank you, those are some great options.

I'm very excited because I can correlate data now from the ip database I have now to match a zip code database I already had (if they live in the US).

This opens up so many possibilities!

[solly]

There's also hostip.info, but the data are not that accurate, it seems (at least for my IP address).

[DanA]

Be careful, whatever the database, the precision is not too bad for countries but it is not reliable with states or cities.