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.