GBIS751 Assignment 3

Assignment 3 is a two part assignment. In part 1, you will clean up your product listing page using real products, tables and CSS. In part 2, you will actually store customer information in the database. In this assignment you will need to update your product table and create a customer table. The database update page is http://www.dom751.com/phpadmin. Remember that the data base user nortmil2_s751 and the data base password dom751.

Assignment 3 - Part 1

Your goal in this assignment is to produce a much better looking product listing using what you have learned about tables and CSS. You will clone work that you have already done. This allows you to take advantage of previous work while also leaving the previous work "as is" for grading in Assignment 2.

• Clean up your product database. Fix it so that it has five "real" products in it. That means five products with good names and descriptions and reasonable prices.
• Clone your product page
  • If your original product page was called prodinfo.php, save it as prodinfo2.php
  • Add a new link on your index.html page to point to prodinfo2.php
• Add "fancy" formatting using one or more tables and CSS.
• Go back and experiment with different border sizes and "play" with CSS to see what you can do.

Assignment 3 - Part 2

Your goal in this assignment is to enhance your customer processing from Assignment 2 to actually insert customer information into your database.

• Clone your customer form (getinfo.html) and your processing logic (form.php).
  • Save your customer form as getinfo2.php. Note that the php suffix is used instead of html. This is because we may want to add some php code to this page in the future.
  • Save your processing logic as form2.php
  • Add a link on your index page to point to getinfo2.php
• Clean up getinfo2.php using tables and CSS
• Define your customer database table. (Create snn_customer where nn is your student number). Student numbers are listed here
• Enhance form2.php to store the information you collected on getinfo2.php. See assignment3hint.php in your directory on the dom751.com site. You must insert more than one field. You need to account for all the fields on your getinfo form.
• Notice that you have not produced a real application because
  • You did not validate the data
  • You did not mark invalid data on the getinfo form and give the user a chance to correct it. Make sure you read the form tutorials in week 3 to understand what you would need to do in a real application.
• Examine your customer table (snn_customer) to see that you stored data correctly. You probably have duplicate information due to testing and debugging. Feel free to delete duplicate customers using phpadmin.