hyBook - A Simple Guestbook Application in PHP+MySQL

hyBook - Guestbook in PHP+MySQL
© 2007 Dr. Herong Yang

Table of Contents:

  Description

  Demo

  Download

  Installation

  Versions

  For More Info

Description

hyBook is a simple guestbook script. It can be used as a simple guestbook or as management tool of visitor's comments on multiple topics. Features of hyBook include: page breaking; multiple topics; IP address tracking; and administrator editing. This version of hyBook is based on PHP and MySQL.

Another version is available for ASP and MS Access. Visit "hyBook - A Simple Guestbook Application in ASP+MS Access" for more information.

hyBook is copyright © 2007 by Dr. Herong Yang. All rights reserved.

You may download hyBook from http://www.herongyang.com/hyBook/PHP for your personal use only. Herong Yang makes no warranty of any kind.

You may not publish, rewrite or redistribute hyBook in any form without explicit permission from Herong Yang.

Demonstration

hyBook has been installed to collect comments on Herong's tutorial book site. If you want to see how it works, please use this link.

You can also look at the screen shot of the user public page: . Click here to see the enlarged version.

The admin private page looks like this: . Click here to see the enlarged version.

Screenshots of hyBook used by other Websites:

Download

Click here to download the latest PHP version of hyBook.

Installation of PHP Version

1. Unzip hyBook-PHP.zip. You will see the files in one directory, hyBook-PHP.

2. Update _config.php to change the datbase access parameters in function all of mysql_connect("localhost", "herong", "MyPass"). Also change the database name in the function call of mysql_select_db("hyBook",$ogConn).

3. Update commentAdmin.php, topicAdmin.php, and generalAdmin.php to make sure that $sgAdminPass is assigned with your own password.

3. Move all files in hyBook-PHP directory to your Web server in a document directory, like \hyBook.

4. Run the installation script with a Web browser opening to http://your_server.com/hyBook/install.php. You should see some messages saying two tables, hyTopic and hyComment, are created.

5. Run the initialization script with a Web browser opening to http://your_server.com/hyBook/initialize.php. You should see some messages saying topics and comments inserted.

6. Test your installation with a Web browser opening to http://your_server.com/hyBook/index.php. You should see two sample topics with some sample comments.

7. If the installation fails, you should run the un-installation script at http://your_server.com/hyBook/uninstall.php, to remove the related tables and try to install it again.

8. If the installation is ok, you must delete these installation scripts: install.php, initialize.php and uninstall.php.

9. Go to http://your_server.com/hyBook/admin.php and use the Topic Admin Login section to manage topics.

10. Go to http://your_server.com/hyBook/admin.php and use the Comment Admin Login section to manage comments.

11. If you want to make your admin pages more secure, you change their file names.

hyBook Versions

Version 2007.12.01: First release of the PHP version.

Version 2006.09.01: Ported to PHP and MySQL.

Version 2006.07.01: Added page breaking. Added cross-topic access links. Improved validation on submission. Improved default CSS properties.

Version 2006.04.01: Added validateContent() method to block URLs and email addresses in the content. Added multiple-selection on admin pages. Fixed some bugs.

Version 2006.01.01: First release of the ASP version.

For More Information

If you have any comments or questions, please share them in the forum: http://help.herongyang.com/.



Copyright © HerongYang.com, 1995 - 2006