Country Detection

[dragonusthei]

Hello,

How can i detect whitch country a user comes from?

Thanks.

[joquius]

There are many scripts on the net with IP directories. Search for them on Google.

[dragonusthei]

But how would you do this on the fly?

is there no simple way using http codes?

[joquius]

There's no HTTP string which relates to your locale. You need to get an IP directory.

[dragonusthei]

can you recommend any and is this gonna cost me?

[joquius]

There are loads of free ones just "Search for them on Google."

[SharkBait]

There are free databases. Look for Ip2Country they offer a database (cvs file) that you can use and do your queries against.

You need to find the numeric representation of the customers IP address via a formula.  I do it for my employer's website to show various product that is only legally allowed to use in their country.

If you can find the ip2country database, I can look and post my code for looking up the area based on their IP.

[dragonusthei]

Hi if you could post that it would be fantastic.

[Orio]

Just google!
Here's one I found by [b]Googling[/b]:
http://www.brothersoft.com/web_author/site_management/maxmind_geolite_country_database_42917.html

I am sure there are better ones out there... (it has lots of IPs, but it didnt have mine for an example)

Orio.

[dragonusthei]

Ok so i have a .cvs file how do i make that go into my database?

[makeshift_theory]

I'm assuming your using a mysql database, if so then open up your database in phpmyadmin and click import then click import from csv.  Or if if you want to do it from the command line:
[code]LOAD DATA INFILE 'filename.csv' replace INTO TABLE {tablename} FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (examplefield1,examplefield2,examplefield3);
[/code]
I belive that's right if I remember my SQL commands, someone correct me if I'm wrong, don't like giving bad info =).

[dragonusthei]

there is no import button ...........

[dragonusthei]

so do i just run that code in mysql?

[Daniel0]

Yes.