Web programming – server side

Assignment Help PHP Web Programming

Reference no: EM1388524

Develop a web site that provides customer access to the Northwind database. The customer should be able to login/register at the site and select any number of products to order, and any quantity of each. When done selecting products, the final order should be displayed for the user to review. The user must click a button to confirm the order. The order is entered into the database only after the confirm button is clicked.

Payment for the order is not handled by the website.

Required Features

1. When the user registers on the website, she must enter a first name, a last name, a phone number and a company name. The site assigns a 5-character customerID to the user, and enters the customer information into the Customer table. For simplicity, only the following fields of the Customer table need to be updated: CustomerID, CompanyName, ContactName and Phone.

2. After registering, a user can login to the site at any later time by entering the customerID number. Password protection is not required.

3. The user must be able to select products to order from a list of product names and prices, and must be able to specify the number of units to order for each product.

4. When requested by the user (or automatically when the user adds a product to the order), the site will display the current order: product name, unit price and extended price for each product, plus the total price for the order.

5. When the user clicks a Confirm/CheckOut button, the order is entered into the database by updating the Order table and the OrderDetail table. For simplicity, the only fields that need to be updated are: CustomerID and OrderDate in the Order table (the server will supply the OrderID); and OrderID, ProductID, UnitPrice and Quantity in the OrderDetail table.

6. After the order has been placed, display the Order table and the Order_Detail table in Gridviews. This would not normally be done - a customer normally is not shown the orders of other customers. It is included as a requirement here to help the grader verify that your program has inserted the proper information into the database. Display only the fields that we are using in these tables, and enable Sorting and Paging for each Gridview.

Optional Features

A. Provide password protection

B. Provide a way to review existing orders. That is, allow the user to log in to a new session and find orders for her that are already in the database. For each order, display the order number, the order date and the name and quantity for each product.

C. Provide a way to Cancel an order. That is, allow the user to log in to a new session, specify an order number, and request that it be cancelled; the server will remove the order from the database (one row from the Order table and one row for each product in the order from the OrderDetail table).

Reference no: EM1388524

Questions Cloud

Determine the volume change of the cell : Think about an artificial animal cell which contains 0.3 mmol/L NaCl (MW: 58.5 g/mol) and 0.01 mmol/L glucose (MW: 180 g/mol) in the cytoplasm.

Base pair substitution mutation change : 2-different mutations are identified in a haploid strain of yeast. The first prevents the synthesis of adenine by a nonsense mutation of the ade one gene.

What is the radius of the track : An ice cube of volume 10.6 cm3 is at first at a temperature of -9.3°C. How much heat is necessary to convert this ice cube into steam.

Create if-then statement with single alternative decision : Create the If-Then statement (or a flowchart with a single alternative decision structure) which assigns 20 to variable y and allots 40 to variable z if variable x is greater that 100.

Web programming – server side : Develop a web site that provides customer access to the Northwind database and Provide a way to review existing orders. That is, allow the user to log in to a new session and find orders for her that are already in the database.

What is the mass of the block : If the coefficient of friction between the block and the floor is 0.40, what is the mass of the block.

Definition of descriptive statistics-inferential statistics : Give a brief definition and an example of the following: a. Descriptive Statistics b. Inferential Statistics

Would you expect them all to be deflected by equal amount : Ina mass spectrometer, ions are directed into a magnetic field, where they curve around in the field and strike a detector. If several singly ionized atoms travel at the equal speed through the magnetic field, would you expect them all to be defle..

Discuss molarity of the solution : Discuss how much of a 10X buffer would I add to a reaction whose total volume will be 20?L?

User Account

All Pages