I spent a few minutes with Dr_Ngo and Neil Turner at Affiliate Summit, and we were talking about geo-targeting users. Pretty powerful stuff, if your landing page can say, “Find singles in Buffalo, NY” or something similar (whatever your offer is about).

The easy (but ghetto) way to do this to put the city & state in the query string. So it’d be like page.php?city=Buffalo&state=NY. Then in your code, you just echo the city and state variables, like < ?= htmlentities(stripslashes($_GET['city'])) ? >. But what if you just want 1 landing page, without using the query string? It’s actually pretty simple, and I’m going to walk you though it.

So first, you need a database. Here’s a good free one. So from your ssh line, you’ll want to get this database by typing:
wget http://www.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz

Cron this to run monthly (looks like they do updates on the 1st, so run your cron on the 5th or so) and then unzip it:
gunzip GeoLiteCity.dat.gz

OK, now you’re going to want to get the PHP module to use this data. From this directory, download

  • geoip.inc
  • geoipcity.inc
  • geoipregionvars.php

So in a single directory, you’ll have these 3 files and GeoLiteCity.dat. Now you’re about to see how unbelievably easy this script is:

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("<pre>");
print_r($rsGeoData);
echo("</pre>");

geoip_close($gi);

You’ll see I just do a print_r to show all the variables available to you, but for me, I see:

geoiprecord Object
(
[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
)

So now your landing page will say,

Find singles in <?= htmlentities($rsGeoData->city . ", " . $rsGeoData->region) ?>

With the latitude & longitude, you can even show a map of the area using the Google Maps API. Having the Zip Code would be great for zip submit offers (only 2 1 left in 14217! – Enter your Zip Code to claim the prize!) or lots of other great ideas using a Zip Code database.

Beware of foreign IPs, though. If you’re not in the US, I don’t know what city or region will give back. You can replace $_SERVER['REMOTE_ADDR'] above with a known IP to see what it returns.

In case you were wondering, I started this installing this script at 3:40 and had it done at 3:50. It took me longer to write this blog post than it did to install the script, so don’t be afraid to try it yourself. If you have problems, though, just contact me.

Tagged with:

53 Comments » for Geo-Targeting PHP Script
  1. Ken Savage says:

    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.

  2. Neil says:

    Nice! Thanks for script. The zip submit idea is great.

  3. Dave says:

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

  4. Kevin Carlson says:

    Just FYI, some hosting providers have disabled the fopen() function used by geoip_open, for security reasons.
    To make it work, the geoip.inc file would need to be rewritten to use the CURL library instead of fopen().

    I’ve alerted Maxmind to this issue, hopefully they will update their API to address this…

  5. Akram says:

    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.

  6. Akram says:

    Thanks for your post it is very helpful for me and i get the answer “$rsGeoData->country_name”.

    thanks,
    akram.

  7. Eric says:

    As Akram said, $rsGeoData is an object, so you’d access the object variables with ->, like “$rsGeoData->country_name”

  8. garry egan says:

    That was an awesome post. Once I found out what this piece was ‘called’ (geotargeting), your site made it easy to deploy.

    Way cool. I think this will most certainly increase conversions…

  9. Al says:

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

  10. Eric says:

    Al – what does print_r($rsGeoData); give you?

  11. Josh says:

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

  12. Kojak says:

    Any demo that already running this geo targetted script?

  13. Eric says:

    I don’t have a demo (that I’m going to share), but basically any affiliate dating website will use this. After all, people only want to date others that live around them.

  14. Kojak says:

    Hi thanks for the reply eric. I just installed the database earlier which you can see here http://nurseownedbusiness.com/geo/test.php do you know how to change the country abbreviation into full country name? for example:

    US change into United States

    Kojak

  15. Eric says:

    Use country_name instead of country_code or country_code3.

  16. Greg says:

    just curious – is there any other way to do this? just wondered if you had tinkered with any other methods(?)

    btw, thank you / it works great

    http://www.syrbot.com/tools/geoip/test.php

  17. Eric says:

    Greg,

    There’s a Javascript one out there somewhere, but they require a link back to their website. Sorry, but for the life of me, I can’t find it. Besides, you don’t want to link back to someone else :)

  18. Greg says:

    please let me know if you remember… i’ll be googl’ing too. thank you!

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


    <script type="text/javascript" src="http://www.google.com/jsapi"> </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>

  20. I inserted this into the head of my document.

    Then I inserted this into the body of the document. Now My whole page is blank. Can you help?

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

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

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

    geoip_close($gi); ?>

    city . “, ” . $rsGeoData->region) ? >

  21. newbienoob says:

    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?

  22. Eric says:

    Check your quotes – make sure you’re using " and not ”. Sorry, but WordPress puts “smart” quotes in my posts, which PHP does NOT like.

  23. Stephane says:

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

  24. Eric says:

    @Stephane: – you’ll need an associative array and this data. So you’ll have:

    $rsContinents['US'] = ‘NA';
    $rsContinents['TN'] = ‘AF';

    Then you’ll know that if I’m in the US, I’m in NA (North America) and if I’m in TN (Tunisia) I’m in AF (Africa)

  25. Stephane says:

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

  26. chris says:

    CashTactics, your javascript works fine! In fact i had been looking for that kind of thing for ages. The method talked about in the post is probably easy too, but
    I didn’t understand a thing. Copy&paste is all my lazy brain can do.

  27. Mark Heppner says:

    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!

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

  29. Soufia says:

    thank you / it works great

  30. Carl says:

    Thanks for the info, Eric! You made it really easy for a PHP newb like me to follow.

    For those who aren’t very skilled with using SSH, this came in really handy for me – http://nevcal.com/eclectic/bluessh/bluehost-ssh.html

    It’s specific to bluehost, but i’m sure can apply to any other hosting service as well.

  31. Joe says:

    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

  32. Eric Nagel says:

    Hi Joe – yes, simply:
    SELECT * FROM geobytes_countries WHERE ISO3 = ‘$rsGeoData->country_code3′

  33. Chetan says:

    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.

  34. qu says:

    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.

  35. Evan says:

    For those who are interested, I wrote a script (Lambda GeoIP) to do all the normal Geo-targeting stuff but also find the nearest major city to the user. Its helpful if you want the user to think you’re nearby but also make it believable.

  36. 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

  37. i was missing the mbstrings php extension. fixed (on CentOS) with: “yum install php-mbstring” followed by http server restart.

  38. Greg Ricks says:

    Thanks for this page. Helped a lot.

  39. Anny says:

    Thank you for such useful information…

  40. Steve says:

    Great Script! I wanted to take it one stage further so that I can display the Subcountry codes but can’t seem to work it out!
    Here is the info on MaxMind – http://www.maxmind.com/app/fips10_4
    But can’t get it to work with your script… any ideas?

    • Eric Nagel says:

      When you do a print_r($rsGeoData); do you see Subcountry info?

      • Steve says:

        No, that is the problem! can’t find out how to integrate the Subcountry info into the output
        Should I simply replace the subcountry codes with the main .dat file?

        • Eric Nagel says:

          That may be it, Steve. My scripts use the “GeoLite City” database, so that’s all I’m familiar with.

          • Steve says:

            ok thanks…
            I’ve checked the fips dat file from maxmind and by comparing it to the results I get from your script I can see that
            Example Data Results from your script
            [country_code] => GB
            [region] => M9
            matches correctly with the fips data file
            GB,M9,”Staffordshire”
            Any idea how I could get this to display
            I’m sure alot of your visitors would be interested as it allows for state/county anywhere not just UK

            Thanks

        • Eric Nagel says:

          Unfortunately, it’s not my script that reads the database, it’s from Maxmind.com.

          Looking at that fips file, you’d have to loop through it and find the M9 line, then pull from that “Staffordshire”. The better way would be to store that in a database, so you can access it quicker. The “fips 10-4 region code” to “name” relationship is 1:1

  41. hitman says:

    is geoip_close necessary?

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

    any issues with not using geoip_close?

    • Eric Nagel says:

      Your open should be before the loop, and close after the loop. The only call within the loop is
      $rsGeoData = geoip_record_by_addr($gi, $_SERVER['REMOTE_ADDR']);

      (plus whatever you’re going to do with that data)

  42. Korush says:

    Am i being stupid, but how come i cant get results using my mobile network.

  43. Dave S says:

    This is pretty close to what I want to do but it looks like the last comments are back in 2012. Any reason this wouldn’t work in 2014? I have a database of 60,000 retail pharmacy locations in the US and am trying to create an easy “find the closest pharmacy to me” app. I’d like the pharmacies to sit in a mysql db if possible. Thanks! this is by far the easiest approach I’ve found after digging for hours.

5 Pings/Trackbacks for "Geo-Targeting PHP Script"
  1. [...] can build an excellent, enterprise-grade Geo-Targeting solution by combining a GeoIP script with the zip/area code database available from [...]

  2. [...] should you buy me a coffee? Maybe you use my RSS -> Deeplink -> Twitter script, or my post on geo-targeting saved you hours of programming, or maybe you use this script that rotates offers based on EPC. [...]

  3. [...] point is to have ammunition when assisting a client with assessing their needs.  Here is a good link if you want to keep tabs on a good thread for how to get started with geo caching. The link is [...]

  4. [...] Eric Nagel’s Geo-Targeted PHP script [...]

  5. [...] Eric Nagel has a PHP script you can use to do something similar, and while his method would work the thought of having to maintain the IP Geolocation database, even through a cron job, just sounds like trouble to me. Not to mention some shared web hosts don’t allow you to run cron jobs or to run a cron job that unzips a file. [...]

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>