代写SEHS4517、SQL编程语言代做

日期：2024-03-06 09:38

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 -