PHPw/Forms-Parts/Suppliers(100pts)
Introduction
For this assignment, you will be developing PHP/PDO code for a page or set of pages that fulfill(s) the requirements found below.
Using your personal database on the MariaDB server (the one that has your zid as its name), create the tables from the SQL SELECT slides (S, SP, P) and make sure they contain the data in the rows shown in the slides (before adding the extra rows later). None of the columns should be allowed to be NULL. Data types are not explicitly specified in the tables from the slides, so feel free to choose any that would work to store the data of the types shown.
Requirements
1) There must be a way to show all of the suppliers. (10pts)
2) There must be a way to show all of the parts. (10pts)
3) There must be a form that allows a user to select a part and see everyone who supplies that part, along with how many of that part they have available. The information on the part chosen should be shown as well. (20pts)
4)
There must be a form that allows a user to select a supplier and get a list of all of the parts they supply and how many of each they have. Information on the supplier chosen should also be displayed. (20pts)
5) There must be a form that allows a user to add a new part to the database. (20pts)
6) There must be a form that allows a user to add a new supplier to the database. (20pts)
ImportantNotes
• You will have a fair amount of leeway on the design of the page. The functionality is the most important part, but it should be obvious how your pages work while the TA’s are grading. The portions that fulfill the requirements should stand out.
• You are required to use prepared statements for any queries that will contain data that the user submits.
• Note: Do not forget that PHP code only runs ONTHESERVER when the page is requested. Additionally, the files containing your code must have an extension of .php or the code will not be run.
