Build a MySQL database for this store that contains tables for customers, orders, order items, and products, and colors. Create 5-10 entries for the products and a suitable number of colors. For those products that include colors, link the appropriate product entry to the color table.
Create a web page in PHP that receives the HTTP request from the Week 2 assignment and displays the customer's name near the top of the page. Display the products of the store-a simple list will do-and allow the customer to select an item and set a quantity. If the item is color sensitive, display the colors and allow the user to select one. Allow the user to go back and select additional items until the customer presses a "Continue" button.