Assignment 4 Solution

Due: as per class plan










Important Notes:




This is a group assignment. Groups may consist of at most two people. Under no circumstances will groups of 3 or more be permitted.



I will be checking for borrowed or copied assignments. All work is to be done from scratch, you may not use any templates or other assistances.



An in-class demo is required for full marks.



This assessment is out of 30 marks total.






Tasks:




In this assignment, you will use PHP to build an application that allows a user to insert new records into a relational database.




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.



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 pa-rameter query.




JavaScript - Form Validation



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



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









1

PROG1800







PHP - Form Validation



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



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



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)



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.



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.




In-class Demo (2 marks)



Your group will be providing in-class demos on the due date. Marks will be given for general knowledge of the submitted solution.










Extra Note:




I have provided sample code that establishes a connection to the database, retrieves some of the data from the VENDORS table and displays it in a dynamically generated HTML table.




Wireframes:




I have provided some wireframes and user flow to help you understand better.




You may or may not use the wireframes as long as you satisfy above requirements.




Submissions:




To submit this assignment, place all of your work into a single folder. Zip (or RAR) this folder, and submit the zipped file to eConestoga. No cover sheet is required for this assign-ment. A good way to make sure everything is correct, is to unzip the file you are submitting on a different location on your computer and making sure everything works. I have to be able to see your results.













2

PROG1800







User flow:

































































































Some wireframes to help you decide on various forms you need:



































































SUBMIT


































3

PROG1800































































































































SUBMIT















































































4

PROG1800
















































































































































































































5