Welcome to the Home Goods Store!

What information would you like to view? Select an item Products Manufacturers Departments

Product List

Name	Color	Price	On Hand Quantity	Product Page
Bath Towel	Black	5.75	75	http://MyStore.com/bathtowel.php
Wash Cloth	White	0.99	225	http://MyStore.com/washcloth.php
Shower Curtain	White	11.99	73	http://MyStore.com/showercurtain.php
Pantry Organizer	Clear	3.99	52	http://MyStore.com/pantryorganizer.php
Storage Jar	Clear	5.99	18	http://MyStore.com/storagejar.php
Firm Pillow	White	12.99	24	http://MyStore.com/pillow.php
Comforter	White	34.99	12	http://MyStore.com/comforter.php
Rollaway Bed	Black	249.99	3	http://MyStore.com/rollaway.php

Total results: 8

Development Stages

1. Identify the one-to-one, one-to-many and many-to-many relationships in the original table.
2. Normalize Original Table by splitting into three related tables: Product, Manufacturer, Department.
3. Create a mySQL database and add tables and data.
4. Create php code blocks, starting with comments that describe the goal of each block.
5. Create a form that allows user to choose a table to display results.
6. Create switch statement check for user selection POST array varibales.
7. Use debug statement to verify selected value is in POST variables
8. Create displayData function. Use switch statment to determine which table format will be displayed.
9. Use debug statement to verify table format is correct and SQL Query stament is functioning.
10. Create while loop to iterate through query results and display as table rows.
11. Verify that the displayed data matches my sample data in the database.