辅导 SEHS4517、SQL编程语言讲解
SEHS4517 Individual Assignment 2324s2 Page 1
SEHS4517 Web Application Development and Management
Individual Assignment
Due: 8 March 2024 (Friday) 6:00pm
Objectives
• To let students demonstrate their web application development skills.
• To show the students' ability to process a web form using php and database.
Task
You need to develop a web application for an online “Study Room Booking System”.
The system allows users to reserve study room in either HHB or WK campus.
Deliverables
Upon completion of the assignment, you need to submit the following files via
Blackboard before the deadline. Your name should appear as comment in every file.
• db.php
This file contains the database connection parameters for MySQLi or PDO. It should
include host name, database name, username and password.
• reserve.php
This file implements the front-end room booking form. When the user clicks the
submit button, the form data is sent to validateForm.php using POST method.
• validateForm.php
This file checks whether the form inputs are correct, and stores the correct data into
the database. For any incorrect input, it redirects the user to reserve.php for
correction.
• admin.php
This file implements the administrative page, which allows the administrative staff to
check the room booking record.
Apart from PHP, you may also use HTML, JavaScript, CSS, etc. whenever appropriate.
SEHS4517 Individual Assignment 2324s2 Page 2
Functional Requirements
1. When the web application starts, the page reserve.php shows the title “Study Room
Booking System” and a booking form with the following items:
Field Purpose
Name A textbox to enter full name
Student ID A textbox to enter student ID number
Email A textbox to enter email address
Campus Radio buttons for user to select the campus, either
HHB or WK.
Date A calendar for user to select a day for booking
Time slot A drop-down list for user to select a time slot:
• 09:00 – 12:00 (value: 1)
• 12:00 – 15:00 (value: 2)
• 15:00 – 18:00 (value: 3)
• 18:00 – 21:00 (value: 4)
Reset A button to clear the form data
Submit A button to submit the form data to server
2. When the form is submitted, form data is sent to validateForm.php using the POST
method. use relative address (i.e. "validateForm.php") instead of absolute address
(i.e. "http:/localhost/xamp/webIA/validateForm.php").
3. The form data is checked at the back end. All items are required (i.e. cannot be blank)
and have to the following requirements:
Data Requirement
Name Covert to proper letter case
Student ID Must have the format 12345678S
Email Must have a valid email address format
Campus Either HHB or WK
Date The day selected must be later than the current day
Time slot The time slot selected must be available, i.e. no other
user has booked the same time slot on the same day.
SEHS4517 Individual Assignment 2324s2 Page 3
4. For any error, e.g. name is blank, time slot is not available, etc., the browser should
be redirected back to reserve.php with proper error message displayed.
5. If all data are correct, proper confirmation message should be displayed. Store the
data into the database.
6. Staff need to login the admin page (admin.php) before checking the booking records.
Use the username “admin” and password “abc1234”.
7. Upon successful login, staff can choose to
• view all records, ordered by record ID; or
• search specific records using student ID number, ordered by date.
8. In db.php, you should have 4 variables to store the connection parameters for
MySQL database: host name, database name, username and password. You can
use your own settings in development, which will be changed later during marking.
9. When connect to the database in validateForm.php and admin.php, you need to
include the file db.php so that the same set of connection parameters are used.
10. Create the database and table in your own system. The database name is
“SEHS4517IA” and the table name is “booking”.
11. The table “booking” should have the following fields:
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| id | int | NO | PRI | NULL | auto_increment |
| fname | varchar(50) | NO | | NULL | |
| sid | varchar(9) | NO | | NULL | |
| email | varchar(100) | NO | | NULL | |
| campus | varchar(3) | NO | | NULL | |
| date | date | NO | | NULL | |
| slot | int | NO | | NULL | |
+------------+--------------+------+-----+---------+----------------+
12. Make sure that the database name, table name, and the table fields are correct. You
don’t need to submit the database. Lecturer will create one for marking.
13. You can freely design the layout of the web pages, as long as the information is
displayed clearly.
SEHS4517 Individual Assignment 2324s2 Page 4
Grading
Criteria Marks
Functional requirements
(Satisfying all the requirements mentioned above) 70%
User interface
(e.g. clear layout and messages) 10%
Error handling
(e.g. error messages, incorrect inputs remain in the form for correction) 10%
Code readability
(e.g. proper indentation, comment, etc.) 10%
Make sure that you have tested your web application and corrected all the coding errors
before submission. The web application should not terminate accidentally due to runtime
error.
Late submission will have mark deduction of 20% per day late, including Sunday and
public holiday. Late more than 4 days will not be accepted.
- End of Assignment -