Write a PHP code with MySql implementation. 

 

1. Create a Form that will:
   1. Accept the input for the five tables below.
   2. Delete the record for the five tables below
   3. Update record for five tables below

 

 

2. Create a PHP code that will

1. Create a database named “OrderSystem”.
2. Create the five tables below.
3. Insert Record using the forms created in No. 1 and then store/save the record in the database.
4. Delete a Record (based on the selected record to be deleted)
5. Update a Record (Note: Primary Key fields can’t be updated)

Note: Forms in HTML file and Create Database, Create Table, Insert Record in PHP File. You need to validate all input from the Form before saving it in your database.

 

 

 

 

 

 

Rep RepNum Last Name FirstName Street 20 Kaiser Valerie City 624 Randall Grove FL State Zip Commission Rate 35 Hull Richard 65 Perez Juan 532 Jackson Sheldon FL 1626 Taylor Fillmore FL 33336 33321 $20,542.50 0.05 33553 $39,216.00 0.07 $23,487.00 0.05 Customer CustomerNum CustomerName Street City State Zip 148 Al's Appliance 2837 Greenway Fillmore FL 33336 Balance $6,550.00 Credit Limit RepNum $7,500.00 20 and Sport 282 Brookings Direct 3827 Devon Grove FL 33321 $431.50 $10,000.00 35 356 Ferguson's 382 Wildwood Northfield FL 33146 $5,785.00 $7,500.00 65 408 The Everything Shop 1828 Raven Crystal FL 33503 $5,285.25 462 Bargains Galore 3829 Central 524 Kline's 608 Johnson's Grove 838 Ridgeland Fillmore 372 Oxford Sheldon FL 33321 $5,000.00 35 $3,412.00 $10,000.00 65 FL FL 33336 $12,762.00 $15,000.00 20 33553 $2,106.00 $10,000.00 65 Department Store 687 Lee's Sport 282 Evergreen Altonville FL 32543 $2,851.00 $5,000.00 35 and Appliance 725 Deerfield's 282 Columbia Sheldon FL 33553 $248.00 $7,500.00 35 Four Seasons 842 All Season 28 Lakeview Grove FL 33321 $8,221.00 $7,500.00 20