The goal for my PHP assignment is to create an order page for a business that sells one product. For this part, I need to create a simple database to store the orders. I may design my database as I wish, but it should be rather simple, and make sense for the application (that may mean only one table). Populate the database with some data at least 5 entries for each table as appropriate. I also need to create a summary page that will display all of the orders neatly in a table, and display the data three times in three, separate, labeled tables, ordering by last order placed first, first order placed first, and highest quantity ordered by customer first.

This is what I have already for my PHP code from the first part:

PLEASE ENTER A VALID PHONE NUMBER ('xxx-xxx-xxxx' and make sure to use dashes)"; $error++; } if($error == 0){ echo "

Thanks for providing your phone number!

"; echo "

You provided: $tele

"; } } ?>

First Name:

Last Name:

Street Address:

City:

State: Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware District Of Columbia Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming

Zip Code:

Phone Number:

Quantity: 1 2 3 4 5 6 7 8 9 10 11 12

Delivery Type: Customer Pick-Up > Free Overnight Shipping -> $49.99 Three-Day Shipping -> $19.99 Five to Seven Business Days Shipping -> $1.99