大家ＨＥＬＰ ＨＥＬＰ我吧
<CENTER><FONT face=Arial size=+3>[em08]CP5310 Assignment </FONT><BR><FONT face=Arial size=+2>Web Programming[em08]</FONT><BR><FONT face=Arial size=+2></FONT></CENTER><PRE><BR><BR><BR></PRE><H4>Overview</H4>This programming assignment is to let you to have hands-on experience to build commerical web sites using various technologies and protocols. This assignment is worth 20 marks.
<P>You are required to build a web site based on 3-tier architecture for a hypothetical company selling products to customers. The business model is B2C (business to customer) providing shop-front to customers in the form of company homepage of portal. The followings are the tools required for building the web site:<BR></P>
<UL>
<LI>Database: MySQL
<LI>Server-side programming: PHP
<LI>Client-side programming: JavaScript, HTML<BR></LI></UL>
<P>The following functions have to be included in the web site:<BR></P>
<OL>
<LI>Customer registration and log-on in order to place order in the company.
<UL>
<LI>generate unique customer ID for each new customer
<LI>check if customer already exists
<LI>store new registered customer info into database: customer ID, registration date and necessary personal details<BR>
<LI>only registered customer with correct username/password can place order<BR></LI></UL>
<LI>Allow existing customer to change personal details.<BR>
<LI>Display the customer last-visit time and last-order summary info using cookie technology.
<LI>Browsing of product catalogue: product code, product description, unit price, ... .
<LI>Place order in a shopping cart.
<UL>
<LI>during product browsing from one web page to another, the order details for each product selected by customers have to be stored temporarily--try the usage of session variables<BR>
<LI>an order is created once the customer confirmed to purchase the selected products<BR></LI></UL>
<UL>
<LI>an order can have multiple products
<LI>generate unique order ID for each new order <BR></LI></UL>
<LI>Reject customer order if the quantity in stock is not enough. Display error messages to customer.<BR>
<LI>Display invoice and store order information in database when order is accepted.
<UL>
<LI>the invoice is a reference for the transaction between customer and company
<LI>order info:order ID, order time, customer ID, product codes (multiple products allowed), quantity, price, shipping address, contact person, contact phone number </LI></UL>
<LI>Perform necessary data validation for user input.
<LI>Company staff log-on to list received orders. Orders can be searched by order ID, or by specifying a date interval to give a summary list of orders. Further click on order ID will give order details.<BR></LI></OL>
<H4>Marking Criteria</H4>
<OL>
<LI><B>[1 marks]</B> creation of database with appropriate tables, attributes and constraints<BR>
<LI><B>[1 marks]</B> HTML forms for customer registration and log-on
<LI><B>[2 marks]</B> client-side scripting and data validation for customer registration, log-on and personal details update<BR>
<LI><B>[2 marks]</B> server-side scripting and processing for customer registration, log-on and personal details update<BR>
<LI><B>[2 marks]</B> use cookies to display customer last-visit time and last-order summary info<BR>
<LI><B>[1 marks]</B> HTML and procesing for product browsing<BR>
<LI><B>[1 marks]</B> data validation and processing for customer to place order in shopping cart<BR>
<LI><B>[2 marks]</B> implementation of shopping cart <BR>
<LI><B>[3 marks]</B> server-side scripting and database processing when order is received
<LI><B>[1 marks]</B> produce invoice <BR>
<LI>[2 marks] list order by order ID and by date<BR>
<LI>[2 marks] display order details when order ID is clicked </LI></OL>
<H4>What to Hand In</H4>The deliverables are:
<UL>
<LI>script file for creation of database and tables
<LI>all php and html files </LI></UL>Note that demonstration may be required. Arrangement with lecturers/tutors will be announced.<BR>
页:
[1]