Mansfield University CIS3306 Project

Design of a Web-based Database-driven Room Reservation System

John Phillips

bocaweb@hotmail.com

March 22, 2003

Summary

An on-line room reservation system was created to replace the current paper-based reservation system used in the Computer Information Science department at Mansfield University. A MySQL database was used to store data about the rooms, users, and reservations. An application was written using the PHP programming language to create a user friendly web-based calendar interface to the database. The application uses SQL (Structured Query Language) to interact with the database and then sends HTML (Hypertext Markup Language) back to the user's browser. A CSS (Cascading Style Sheet) is used extensively to control the formatting of the output.

Project Deliverables

report - View the project report.

project demo - View the reservation system in action. Type jphillip and mu to login and make a reservation. Note that either Internet Explorer version 6 or above or the latest version of the Mozilla web browser is required.

Diagrams and Code

er.gif - The E-R Model - the Entity Relationship diagram of the database.

sql.txt - Data definitions - the SQL statements used to create the database tables.

main.php - the main code for the reservation application.

common.php - contains the functions used by the main application.

login.php - code to allow the user to login.

reservation.css - this cascading style sheet controls much of the look and feel.