Code Examples -> A complete Guestbook using PHP and mySQL. Multiple catagories, Limit entries shown per page, admin backend to delete entries and more... phpGuests v1.6.1

	Submit Your Code
	SEO Monitor
	UpTime Monitor
	PHP Code Contest
	My Favorite Examples
	My Favorite Articles
	Update Your Profile

More Weber Sites
	PHP Code Search
	Web Development Forums
	Learn MySQL Playing Trivia
	PHPBB2 Templates
	Web Development Index
	PHP Web Logs (BLogs)
	Web Development Resources
	Web Development Content

Recommended Links
	PHPClasses
	PHP Editor
	PHP Jobs
	Vision.To Design
	Ajax Tutorials
	PHP Programming Help
	PHP/MySQL Programming
	Webmaster Resources
	Webmaster Forum
	XML meta language
	website builder

Recommended
	Submit Site
	Forex Trading Online forex trading platform


BACK		ADD A COMMENT		SEND TO A FRIEND		ADD TO MY FAVORITES		ADD CODE EXAMPLES		PRINT

PHP Code Examples

Title :	A complete Guestbook using PHP and mySQL. Multiple catagories, Limit entries shown per page, admin backend to delete entries and more... phpGuests v1.6.1
Categories :	PHP, MySQL, Databases	Ray Cuzzart
Date :	Jun 01st 2001
Grade :	2 of 5 (graded 36 times)
Viewed :	32659
File :	phpGuests.zip
Images :	No Images for this code example.

Search :	More code by Ray Cuzzart
Action :	Grade This Code Example
Tools :	My Examples List

Code

Features: NEW Version 1.6.1

Update: Posting has required fields now. There is now more blank
posting.

Also we fixed a problem with the words not wraping when the posts
are viewed. Now all posts are wrapped at 75 characters.

You can now use smileys and html-style code in your posts
NEW We have added the ability to add html-style code as well as smileys to
your posts, check
out the demo to see the new version in effect.

Multiple Catagories:
phpGuests offers you the option of having multiple catagories for your
guestbook visitors.

Admin Controls:
Admin controls gives you control over the catagories and removing post right
from your
browser.

Password Protected Admin Controls:
Admin controls are password protected using mySQL. You store your username
and password
in mySQL.

Completly Customizable:
phpGuests is completly customizable to your site. Ever aspesct using
templates.

IP Logging:
IPs are logged into the database. No IPs are show to users signing the
guestbook.

Control number of entries shown:
NEW Admin can now control the number of entries that are shown per page.

phpGuests Demo
Please visit our site at: http://cuzzart.com/phpGuests/

Admin Control Panel Demo:
To keep from others trying to delete the catagories and so on we are not
allowing anyone to
test the admin section.

Downloading the script: You can download phpGuests by using the link on this
listing or visiting our demo page at: http://cuzzart.com/phpGuests/

Questions or comments?
Send email to: ray@cwd-solutions.com

Related Code Examples

	This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases, MySQL, Complete Programs, PHP, Databases
	bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases
	Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs. Categories : Databases, PHP, MySQL, Complete Programs
	phpAds, a complete banner and ad management system with detailled tracking and stats. Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases
	Point and Click Interface ala MS Access for creating SQL statements. Categories : MySQL, Complete Programs, General SQL, PHP, Databases
	Message of the Day - Random Message (Needs MySQL!) Categories : Databases, HTML and PHP, PHP, MySQL
	email new items in db Categories : PHP, Email, Databases, MySQL, Beginner Guides
	Alternating background color for HTML table rows Categories : PHP, Databases, MySQL, HTML and PHP
	color codes for positive and negative numbers Categories : PHP, MySQL, Databases, HTML
	Authorize Me! An authentication script. Categories : MySQL, Databases, Authentication, PHP
	A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL
	Linked comboboxes with php-mysql & javascript Categories : PHP, Java Script, Databases, MySQL
	mysql_escape_string Categories : PHP, MySQL, Databases, Strings
	Automatically printing the contents of an sql table in MySQL. Categories : MySQL, PHP, HTML and PHP, Databases
	usercounter class Categories : PHP, PHP Classes, Databases, MySQL, Environment Variables

User Comments

	maxpt wrote : 838 i tried ur guestbook...u can add entry to the guestbook..but I can view the guestbook...I don`t understand why the view doesnt work...plz tell me how to configure this out...thanks...and ur guestbook is cool ..easy to install n use
	maxpt wrote : 839 when I said " I can view the guestbook"..I mean "I can`t view the guestbook" even tho I can add entry to the guestbook..sorry typing error
	D W wrote :1225 This is a great sample of using .PHP & MySQL. I particularily like the use of templates. Thank you for this learning tool.<p> I did note that the SQL writes the admin user ID and password into the database in plain text but the login scrip uses password() when querying the database. This makes it so that you can not login. <p> Your code = PASSWORD(`$admin_pass`)") <br> Has to be = LIKE `$admin_pass`")<br> <p> This code is in the phpGuestsFunc.php file.