Page 1 of 1
MySQL version of GBook
Posted: Tue Aug 02, 2005 10:06 am
by fisherman
MySQL version of GBook
SCRIPT: gbooksql.php
AUTHOR: Andreas Kakanis-Silk
DATE: 02 August 2005
Click here to download (WinZip File)
Working Site
The guestbook operates exactly the same as the text file based version (GBook V1.33).
Posted: Tue Aug 02, 2005 10:34 am
by Klemen
Thanks Andreas, great for people who have access to a MySQL database!
Thanks for your contribution.
Best regards
Posted: Tue Jul 25, 2006 9:58 am
by morningsun76
Is there any advantage to using an SQL database instead of the entries.txt file?
Advantages of MySQL db for Guestbook
Posted: Tue Jul 25, 2006 1:21 pm
by fisherman
It depends on what you want I guess. My reasons for writing the MySQL version and using it are (in no particular order)
1. The db is stored outside of the web root, so is more secure (of course, you could always put your text file outside the web root, but I don't even have to think about it).
2. I find it easier to manipulate via MySQL Administrator, rather than just using the web pages.
3. When viewing the file outside of the web the presentation of the entries is much clearer than a text editor can give you for a simple text file.
In case you are thinking of using it, I should point out that it does not include Klemen's updates to Gbook (for spam/junk or whatever) and I have disabled the database in the "working site" as it was getting filled with rubbish.
One day I will get round to updating the MySQL version to incorporate the changes in the latest text-based version.