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).
MySQL version of GBook
Thanks Andreas, great for people who have access to a MySQL database!
Thanks for your contribution.
Best regards
Thanks for your contribution.
Best regards
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here 
You should follow me on Twitter here
Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...
Also browse for php hosting companies, read php books, find php resources and use webmaster tools
You should follow me on Twitter hereHelp desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...
Also browse for php hosting companies, read php books, find php resources and use webmaster tools
-
morningsun76
- Posts: 7
- Joined: Sat Jul 22, 2006 7:49 pm
Advantages of MySQL db for Guestbook
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.
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.