Dreamweaver Article

Creating an event registration application in PHP – Part 2: Building the back end

Dreamweaver has all the power you need to establish an online registration system in PHP, including the administrative back end. The article Creating an event registration application in PHP describes how to set up the front end, including presentation catalog and attendee registration. This article details the creation of the administrative side of the system: listing registrants, adding new ones, and updating or deleting existing attendees. In addition, you'll learn how to make it all secure with protected log-in pages. This application consists of six pages:

• Login.php – The log in page verifies the username and password of anyone attempting to access the administrative site. Once authenticated, the user is taken to the reg.php page.
• Reg.php – The initial registration page displays a table of registered attendees with links to update or delete each record. An additional link is provided to reg_insert.php.
• Reg_insert.php – This page allows the administrator to add a new registrant to the database.
• Reg_update.php – Here, the administrator can modify any existing record.
• Reg_delete.php – A page to confirm the removal of a record.
• Logout.php – This page contains code to log out the current user and return them to the log in page.

Requirements

In order to make the most of this article, you need the following software and files:

Dreamweaver CS3

• Try
• Buy

Sample files:

• event_reg_admin.zip (ZIP, 40K)

Prerequisite knowledge

You'll need to know how to set up a dynamic site in Dreamweaver and also have PHP and MySQL set up on your development system. You'll also need to understand how to restore a SQL file to a MySQL database.

Page 1 of 9

Next Page

About the author