Geo-Targeting PHP Script

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.

Reply

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

Reply

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.

Reply

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

Reply

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);

Reply

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>


Reply

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?

Reply

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

Reply

@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 …

Reply

This is a great script! I am trying to use it to dynamically change the background and header on my website to match the time of day and weather of the user viewing it. To do this, I’m using XML data called from a weather API such as Yahoo, WeatherBug, or NOAA. However, no services let you call the data by the latitude and longitude. When I test your script, it does not throw back the zip code. It does work and it tells my correct location, but it is just blank for the zip. I need the zip codes to call the weather data! How did you get the zip code database to work? Is it included with the main database? Thanks for any help!

Reply

thank you / it works great

Reply

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

Reply

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.

Reply

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.

Reply