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

	Join us on FaceBook
	Submit Your Code
	Poker Tournaments
	Poker Guide for Developers
	SEO Monitor
	UpTime Monitor
	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 Resources
	Web Development Content
	Internet Security Software

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
	פרייסז - הכח לקנות עובר לידיים שלך
	Texas Holdem Poker Evangelists


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 :	40507
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

	bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases
	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
	Specify your connection settings and create a link to a MySQL database. Categories : PHP, PHP Classes, Databases, MySQL, Beginner Guides
	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
	Paginator - a class that can help you to split MySQL database query result sets to pages. Categories : MySQL, Databases, HTML, PHP
	Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0 Categories : PHP, Sessions, Databases, MySQL
	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
	Simple conversion functions to change MySQL dates to arrays, arrays to MySQL dates. Categories : PHP, Arrays, Date Time, Databases, MySQL
	Full membership authentication system. Categories : Authentication, MySQL, PHP, Databases
	Example voting script. Lets people enter suggestions and vote for existing ones. Categories : MySQL, PHP, Cookies, Complete Programs, Databases
	mediaCat-GTK v2.0.0 - an mp3/cd/dvd cataloging utility written in php-gtk which interfaces with mysql and ms access (or db supported by PHP's Unified ODBC Functions) Categories : PHP, MySQL, MS Access, Utilities, Databases
	Complex paging with no resultset limit Categories : PHP, MySQL, Databases, Output Control, HTML and PHP
	php-gtk mysql querying tool Categories : PHP-GTK, MySQL, PHP, Databases
	MySQL Connection/Query Class Categories : Databases, MySQL, PHP, PHP Classes

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.