In this assignment, you will use PHP to build an application that allows a user to insert new records into a relational database. (ALL PARTS OF TABLES (file) ARE HERE)

1. HTML Static Content - Web Form

On the landing page, create web forms that collect information from the user.

The first web form should collect the information required to insert a new Part into the PARTS table. After the data has been successfully validated, submit it to parts.php. (3 marks)

The second web form should collect the information required to insert a new Vendor into the VENDORS table. After the data has been successfully validated, submit it to vendors.php. (3 marks)

The final web form will be used to construct a parameter query. After the data has been successfully validated, submit it to parameter.php. (1 mark)

Refer to assignment5.mdb for more details about the table schemas.

2. HTML Static Content - Instructions (1 mark)

Be sure to explain to the user what your web application is supposed to do. Include details on how to use the application. Explicitly describe the construction of the parameter query.

3. JavaScript - Form Validation

All user inputs must be validated so that they match the data types of the corresponding field from the database. Do not allow null fields if the data is required. (4 marks)

If any errors exist, display a compound message that includes all of the error messages. Do not use a JavaScript popup box for this purpose. (2 marks)

4. PHP - Form Validation

All user inputs must be validated so that they match the data types of the corresponding field from the database. Do not allow null fields if the data is required. (4 marks)

If any errors exist, display a compound message that includes all of the error messages. (2 marks)

5. PHP - Data Persistence From parts.php and vendors.php:

After the data has been successfully validated, display a message that summarizes the data that the user provided. (2 marks)

Insert the data into the corresponding table. (2 marks)

6. PHP - Parameter Query (2 marks) From parameter.php:

Create a parameter query incorporating the information that the user submitted. You are completely free to make the query as complicated as you like. Execute the query and display the results.

7. Programming Style and Standards (2 marks) It is a good idea to practice conforming to a set of programming standards. Refer to the posted summary of the Programming Standards used by the CP/CPA programs.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

ASSIGNMENT5.MDB file (SCREENSHORTS OF PARTS AND VENDORS)

PARTS

PartID, VendorNo, Description, OnHand, OnOrder, Cost, ListPrice

\

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

VENDORS

THE TEACHER ONLY PROVIDED US PARTS & VENDOR TABLE

Parti. Vendor- Description 3820 Dive kayak 3820 Underwater Diver Vehicle 3511 Regulator System 5641 Second Stage Regulator 3511 Regulator System 3511 Second Stage Regulator 3511 Regulator System 3511 Alternate Inflation Regulator 3511 Second Stage Regulator 3511 First Stage Regulator 6588 Second Stage Regulator 6588 Depth/Pressure Gauge Console 3511 Electronic Console 3511 Depth/Pressure Gauge 3511 Personal Dive Sonar 3511 Compass Console Mount 3511 Compass (meter only) 3511 Depth/Pressure Gauge 3511 Electronic Console w/ options 2014 Direct Sighting Compass 2014 Dive Computer 2014 Navigation Compass 2014 Wrist Band Thermometer (F 2014 Depth/Pressure Gauge (Digital) 2014 Depth/Pressure Gauge (Analog) 2014 Wrist Band Thermometer (C) 6588 Dive Computer 3511 Stabilizing Vest 3511 Front Clip Stabilizing Vest 16 1356.75 3999.95 2 1680 165 216 117.5 88 124.1 70 119.35 35 73.53 154.8 85.8 99.9 64.6 95.79 24 73.32 12 120.9 48.3 72.85 10.15 24.96 120 76.22 189 4 365 75 341 166 100 43 135 140 10 430 260 270 170 10 146 12 390 105 235 29 52 226 211 168 183 420 12 12.582 34.95 179 20 9.17719.95 18 149 119 19 15 2 76.97 7.92 53.64 39.27 6.48 253.5 146.2 128.8 10 12 16 12 26 10 67 430