PHP代写 | Awkl 2020-03-11 web application

本次PHP代写是完成简单的手机销售网站
Due Date: 25 March 2020
Database:
• The MySQL database is setup using the following MySQL commands in the MySQL
Command Line Client:
DROP DATABASE IF EXISTS SEHS4517;
CREATE DATABASE SEHS4517;
USE SEHS4517;
CREATE TABLE reservation (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
store INT NOT NULL,
model INT NOT NULL,
fname VARCHAR(20) NOT NULL,
lname VARCHAR(20) NOT NULL,
email VARCHAR(100) NOT NULL,
mobile VARCHAR(8) NOT NULL,
pickup DATE NOT NULL
) ENGINE=INNODB;
DESCRIBE reservation;
+ + + + + + +
| Field | Type | Null | Key | Default | Extra |
+ + + + + + +
| id | int(11) | NO | PRI | NULL | auto_increment |
| rtimestamp | int(11) | NO | | NULL | |
| store | int(11) | NO | | NULL | |
| model | int(11) | NO | | NULL | |
| fname | varchar(20) | NO | | NULL | |
| lname | varchar(20) | NO | | NULL | |
| email | varchar(100) | NO | | NULL | |
| mobile | varchar(8) | NO | | NULL | |
| pickup | date | NO | | NULL | |
+ + + + + + +
9 rows in set (0.02 sec)
• The user inputs in reserve.php contain the following fields:
Field Name Description and Requirement
store A list which allows the customer to select the store for picking-up the
product:
1: IFC Mall
2: Festival Walk
3. Hysan Place
4: APM
model A list which allows the customer to select a particular model:
1: 16GB
2: 32GB
3: 64GB
4: 128GB
fname The first name of customer. Number of characters in this field must be
larger than 1 and less than 20. Name can only include A-Z, a-z and space
characters.
lname The last name of customer. Number of characters in this field must be
larger than 1 and less than 20. Name can only include A-Z, a-z and space
characters.
email The email address of customer. This field must be a valid email address.
rtimestamp INT NOT NULL,
awkl 2020-03-11 Page 3
mobile The phone number of customer. Number of characters in this field must
be equal to 8. This field can only include 0-9 characters.
pickup The date on which the customer will pick up the phone at the store.
• In validateForm.php, it must check that the user has input ALL the fields and ALL the
fields are valid according to the above table. If any of the fields is missing or invalid, the
user will be re-directed to reserve.php again to correct the form.
• The admin.php page is the administrative page for the smartphone company.
• The admin.php page shows a login form for the user to login, the login name of this page
should be admin. Password should be pass.
• After the login, the administrative page should provide the following functions:
o Show Check the list of reservation sorted by id.
o (Extra marks) Sort the list by reserve time pickup date, first name, or last name of the
customers. That is, three different ways to show the list in sorted format.
o Search records by mobile number of the customers
Marking Criteria:
• Functionalities
• User interface design
• Code Readability – indentation, comments
• Documentation
o Screen captures, explanations code segments for input validation