You must have been thinking the same things I was last weekend. I’m doing the same thing the ghetto way now through my ppc stuff but I’m going to take you up on this script and try that out.

I am looking to show ads on organic results based on coutry IP later on too but this is a good start. Nice stuff Eric.

Hey Eric good explanation … I’ve always wondered how to do this. Thanks!

Hi,

My name is akram. I am software engineer and running my own company named ‘hive’.I am developing a website in which i want to get the country name object, I have redden your post and found very helpful but i could not access the country object please tell me how can i access and country object.

Hey guys….i am an EXTREME newbie to this, but REALLY want to learn it. I did what you said with the three files and the database, and then copied the code intothe page like this:

include(“geoip.inc”;);
include(“geoipcity.inc”;);
include(“geoipregionvars.php”;);

$gi = geoip_open(“;http://www.hiringcontractorsnow.com/GeoT/GeoLiteCity.dat“;, GEOIP_STANDARD);

$rsGeoData = geoip_record_by_addr($gi, $_SERVER['REMOTE_ADDR']);

echo(“;”;);
print_r($rsGeoData);
echo(“;”;);

geoip_close($gi);

I then copied the bit of code for the city and state like this:

So now your landing page will say, “Find singles in city . “, ” . $rsGeoData->region) ? >”.

but i do not get anything that works.

Can oneof you folks give me a hand?

Thanks
AL

I’m a little confused – putting this directly onto a PHP page does not work?

include(”geoip.inc”);
include(”geoipcity.inc”);
include(”geoipregionvars.php”);

$gi = geoip_open(”./GeoLiteCity.dat”, GEOIP_STANDARD);

$rsGeoData = geoip_record_by_addr($gi, $_SERVER['REMOTE_ADDR']);

echo(””);
print_r($rsGeoData);
echo(””);

geoip_close($gi);

Here is the a javascript version that takes directly from google.


<script type="text/javascript" src="http://www.google.com/jsapi"&gt; </script>
<script type="text/javascript">
if (typeof(google.loader.ClientLocation.address.city) != null) {
document.write(google.loader.ClientLocation.address.city
+", "
+google.loader.ClientLocation.address.region);
} else {
document.write("Unknown location")
}
</script>


I enter in the following code to my header.php file. I’ve placed all four files into the same directory as my header.php file.

<?php
include(“geoip.inc”);
include(“geoipcity.inc”);
include(“geoipregionvars.php”);

$gi = geoip_open(“./GeoLiteCity.dat”, GEOIP_STANDARD);

$rsGeoData = geoip_record_by_addr($gi, $_SERVER['REMOTE_ADDR']);

echo(””);
print_r($rsGeoData);
echo(””);

geoip_close($gi);
?>

After placing this into my header and saving it my website shows me a blank page.

Any suggestions?

Hi, this is nice ! My question is : would you know how to get the continent_code ?

@Eric:
Ok, I see. But if you use Apache Module (mod_geoip), you can do :

apache_note(‘GEOIP_CONTINENT_CODE’)

I was hoping there was such a method like $rsGeoData->continent_code …

this is exactly what I need for my US only campaigns. Thank you so much for sharing this!

thank you / it works great

Hi all,

I want to know if it is possible to use the any of the (
[country_code] => US
[country_code3] => USA
[country_name] => United States
[region] => NY
[city] => Buffalo
[postal_code] => 14217
[latitude] => 42.9761
[longitude] => -78.8727
[area_code] => 716
[dma_code] => 514
)

in a mysql GET query?

e.g. SELECT *
FROM geobytes_countries
WHERE ISO3 = country (Param is $_rsGeoData['country_code3']) or something like?

Simply is there must be a $_GET['country_code3'] or $_SERVER['country_code3'] statement to get the variable detail in a RS.

Cheers,
Joe

Can you pleas explain how to use this script on wordpress, I don’t understand much of the thing you explained above. Pleas explain with more details, I will be thankful to you.

To those getting a blank screen when trying this script: try running: php -f in shell — this should give you some more useful info. in my case, i was missing the mbstrings php extension. fixed (on CentOS) with: “yum install php-mbstring” followed by http server restart.

Hi Eric, Hope you’re well!

I was reviewing Maxmind and the GEO City Lite which says it does “MaxMind GeoLite City/ISP/Organization Edition Results” But I can seem to find the query strings for the ISP info, City, Etc?

I wondered if you could help me and knew what they were.

Cheers in advance,
Joe

is geoip_close necessary?

i have it in a foreach loop then use flush at the end.

any issues with not using geoip_close?