This application is the result of being sick for a few days and playing around with Google Maps when it was relatively new.  Much of the Google-specific code, such as occurs in googlemap.inc, was borrowed and customized from code I came across on the Internet.  Sorry I can't provide citations.  Anyway, this application uses php to collect the IP addresses of browsers visiting the page, send address to hostip.info, to geolocate the address, adds the address to a MySQL database, and displays the last x IP address in an embedded Google map.  It is in now way a replacement for site statistic software.  If you're looking for something good for statistics, I recommend http://www.phpmyvisites.us/ or http://awstats.sourceforge.net/, depending on whether you have access to the site logs or not.  

Included in this tarball are index.php, googlemap.inc, and this README file.  Index.php contains the php scripting that is the logic behind the application.  Googlemap.inc is a template into which results are deposited for display.  I've removed some of the more context specific content, such as my navigation links, and the whole thing is unlikely to work in its present state.  However, one should be able to figure out how to make it work from what's included in this file and by using the Google group for the Maps API. This was written for API v1 and I haven't modified it since v2 was released.   

This script requires the use of MiniTemplator, a compact template engine for HTML files.  It is distributed from http://www.source-code.biz/MiniTemplator/ under the GNU LGPL and is free.  The PHP version my be downloaded from http://www.source-code.biz/MiniTemplator/php/MiniTemplator_php.zip .  You'll need to download and import this or do the templating another way.  MiniTemplator makes it very easy to import a template HTML file, replace variables in the template with data, and display the modified template.

The VisitorMap table in my MySQL database consists of the following columns:
ipaddr
tstamp
hostname
city
country
lat
lng

Some random notes:  A quirk of hostip.info, the geolocation service I used, is that US cities are followed by a comma and two letter state code, whereas non-US cities are not.  I also chose not to display the hostname portion of DNS names to preserve the privacy of visitors, although they are stored in their entirety in the database.  The ignoreAddress function makes it possible to avoid recording your own visits.

Everything I've included here is free as in freedom, but it would be nice if you let me know you're using it.  Hope it's useful.

jim

http://www.braggtown.com