PHP代写 | ITP4513 Internet & Multimedia Applications Development


ITP4513 (Internet & Multimedia Applications Development)
3. Design for Customer (Interface Design: 15 marks; Function: 35 marks)
Done By
a. Register account into system
Managed to create a new customer account into the system with all necessary information
Required information during registration as below:
1. Customerǯs Email
2. Customerǯs First Name
3. Customerǯs Last Name
4. Phone Number
5. Password
* customerEmail should be created as Primary Key
b. Update customerǯs profile
Managed to view and update customerǯs information
C•omerǯ• information including:
1. First Name
2. Last Name
3. Phone Number
4. Password
*customerEmail cannot be changed after the creation
c. Make the order
Managed to make order into the system with all necessary information
View goods information
– List of goods shown on site for customer to choose (show the goods when status is
The goods should include 2 stock statuses:
ͳǤ DzAvailabledz: Show only the available goods.
ʹǤ DzUnavailabledzǣ The goods have been discontinued or not available.
Required information for creating an order
1. Consignment Store ID & Shop ID:
– The ID of the pick-up shop that is selected by customer.
– Each order can only belong to one store
2. Goods Name & Quantity:
– Being able to order more than one good in the same order.
– Order quantity cannot be greater than the stock quantity in Goods table.
3. Deduct the quantity of goods after customer make an order.
*orderID should be generate automatically by the system as Primary Key
ITP4513 (Internet & Multimedia Applications Development) – Group Project Requirements
d. View order records
Managed to view the orders with necessary information
Required information for viewing the orders
1. Order ID
2. Shop Name
3. Shopǯs address
4. Order Date
5. Goods ID
6. Goods Name
7. Selling Price
8. Quantity
9. Status
10. Total Price
, etc.
The orders should include 3 statuses:
1. DzDeliver›dzǣ The parts are delivering to shop
2. DzAwaitingdzǣ Goods are ready for pick up
3. DzCompleteddzǣ The goods have been picked up from customer
e. Delete Account
Delete the user account including all the usersǯ order records from database
Required functions:
– Create a Dzdeleedz button to delete the user account including the usersǯ order records and
comments from the database.
ITP4513 (Internet & Multimedia Applications Development) – Group Project Requirements
4. Design for Tenant (Interface Design: 15 marks; Function: 35 marks)
Done By
a. Login to system
Managed to login into the system with all necessary information.
Required information during login
1. Tenant ID
2. Password
b. Add, view and edit goodsǯ information
Managed to create a page contain the list of goods
Required part information:
1. Goods Number
2. Goods Name
3. Stock Quantity
4. Stock Price
, etc.
* goodsNumber should be generate automatically by the system as Primary Key.
Required functions:
– Create a Dzedidz button to make change of stock quantity and stock price
– Tenant can add in new goods /remove the goods (change
the stock status from DzAvailabledz to DzUnavailabledzȌ
c. Generate report
Managed to view the order with necessary information.
Required information for report page
1. Order ID
2. Order Date
3. Customer ID
4. Customer Name
5. Shop address
6. goods Number
7. goods Name
8. Quantity
9. Order status
10. Selling price of each goods
11. Total Price
, etc.
Required Function:
– The report needs to be ordered by date in descending order.
d. Delete user order
Assume there is a wrong input in the Goods table of the field DzremainingStockdz from the tenantǤ And
the tenant does not have enough goods to sell to the customer. So that the order needs to be
Required functions:
– Delete the selected order record from database
ITP4513 (Internet & Multimedia Applications Development) – Group Project Requirements
5. Form your project group
Each student needs to form a project group, the maximum number of students in each group is 2.
Strongly recommend you to form a group to complete this project as you can benefit from sharing
skills/codes amongst your members, and you can learn to plan, coordinate, and integrate work done
by each member.
Study carefully the given ERD and table structures before you start the implementation.
6. Additional requirements of your project
a. Your web site should only use PHP as the server-side programming language (i.e. not ASP, ASP.NET,
JSP, servlet etc.), however, you may use JavaScript and CSS for specific purposes. The database server
used must be mySQL (version 5.0 or above).
b. In your PHP code, you must ensure to use the following parameter values for the following mySQL
database functions :
$conn = mysqli_connect($hostname, $username, $password, $database);
set to the values below in a PHP script which is shared by the web pages :
$hostname = “”;
$database = “projectDB”;
$username = “root”;
$password = “”;
7. Items to submit (Phase 1) (30% of total project marks)
Submit all UI design using CSS and HTML. Submission deadline will be announced by the
8. Items to submit (Phase 2) (70% of total project marks)
a. A CD-ROM or DVD-ROM which stores a softcopy of all files for the whole web site. All files must be
stored in non-compressed format (no .zip or .rar files please!)
b. provide a SQL script file CreateProjectDB.sql to let the lecturer to re-create the database and test
c. for the SQL script file CreateProjectDB.sql, it must contain CREATE TABLE commands to setup the
database tables in projectDB database. Include necessary INSERT statements to add additional
sample records you want to provide. The following is a sample SQL script :
drop database IF EXISTS projectDB;
create database projectDB character set utf8;
use projectDB;
drop table IF EXISTS Users;
Create table Users (
userName Varchar(30) NOT NULL,
userPswd Varchar(10),
Primary Key (userName)) ENGINE = InnoDB;
INSERT INTO Users (userName, userPswd) VALUES
(‘admin1’, ‘secret1’),
(‘admin2’, ‘secret2’);
d. a demonstration of your completed web site should be recorded by


本网站支持淘宝 支付宝 微信支付  paypal等等交易。如果不放心可以用淘宝交易!

E-mail: [email protected]  微信:itcsdx