Google Maps Guestbook - How Its Made
See the Google Maps Guestbook in action here
This set of files can be used in conjunction with Google Maps to produce an interactive Guest Book for visitors to your website.
Instead of a list of name/email/comments, Google Maps Guestbook has a visual interface where entries to the Guestbook are indicated by a 'Marker' on top of a map of the world
- Web hosting capable of compiling PHP files
- MySQL database
Please download the following two files:
Installation and Setup
(1) Setup MySQL database
Use the contents of guestbook-table-schema.sql, or the script below to create a table "guestbook" on your MySQL database
`id` int(11) NOT NULL AUTO_INCREMENT,
`lat` varchar(30) NOT NULL,
`lng` varchar(30) NOT NULL,
`comments` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
(2) Edit Files
Unzip the files in google-maps-guestbook.zip to a new folder. Edit the contents of the following files...
- addgbentries.php & findgbentries.php :
Add the details for your MySQL database to replaces the asterisks below
$server = "********";
$user = "********"; ;
$password = "********";
$database = "********";
- google-maps-guestbook.js - No Edit's Required
- google-maps-guestbook.php - No Edit's Required
- GXml.js - No Edit's Required
(3) Upload Files to Web Server
Upload all files to your webserver in the following relative structure:
Browse to google-maps-guestbook.php and ensure you see a map of the world with no markers ... yet.
Test the guestbook by clicking on the map and adding an entry.
How To Use
Google Maps Guestbook is intended to be used by visitors to your website.
The interface has a minimal set of options to make the new entry process as simple and as quick as possible.
How it Works:
Guestbook entries are stored in the MySQL database.
Version 1.0 (15/12/2005) - Allow visitors to add there comments and save in a mysql DB
Version 2.0 (14/04/2011) - Some updates in between, but finally go round to updating to match the current version
Version 2.1 (31/07/2011) - Update to addgbentries.php ... $doc = preg_replace("/\\\\/","",$doc);
Version 2.2 (02/11/2013) - Minor updates. Add debug option on google-maps-guestbook.js
Comments For This Page
Hello, I really appreciate posts which contain interesting info and which I am always eager to read! Great site!
By Hum TV Dramas on 16th March 2015
Very nice site!By Pharme320 on 15th May 2014
Very nice site!By Pharmg633 on 3rd May 2014
I have to agree with your statement with this issue and akkdedcceekdfkdbBy Smithf879 on 30th April 2014
Some updates to code and instructions.By Daft Logic on 10th May 2011
You can now download the codeBy Daft Logic on 14th April 2011
Where exactly do we download this awesome guestbook?On 9th November 2009
where to obtain?By adam on 26th July 2008
Add your own comment below and let others know what you think: