Tasks:
In this assignment, you will use PHP to build an application that allows a user to insert new records into a relational database.
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.
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.
The final web form will be used to construct a parameter query. After the data has been successfully validated, submit it to parameter.php.
Refer to assignment5.mdb for more details about the table schemas.
2.HTML Static Content
Instructions - 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.
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.
4.PHP - Form Validation
All user inputs must be validated again so that they match the data types of the corresponding field from the database. Do not allow null fields if the data is required.
If any errors exist, display a compound message that includes all of the error messages.
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.
Insert the data into the corresponding table.
6. PHP - Parameter Query 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.