[Solved]Php Form Parts Suppliers 1oo Pts Assignment Developing Php Pdo Code Page Pages Accomplish Q37024976

PHP Form Parts/Suppliers (1oo pts) For this assignment, you will be developing PHP/PDO code for a page or pages that accomplish the requirements found below You will be using your own personal database (the one that has your zid as a name). Before you start, create the tables from the SQL DML slides (S, SP, P) and make sure they contain the data in the rows found in the slides. None of the columns should be allowed to be NULL I. There must be a way to show all of the suppliers. (lopt 2. There must be a way to show all of the parts. (topts) 3. There must be a form that allows a user to select a part and see everyone who supplies that part and how many they have (2opts) 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. (2opts) 5. There must be a form that allows a user to add a new part to the database. (2opts) 6. There must be a form that allows a user to add a new supplier to the database. (2opts) Important Notes . You will have a fair amount of leeway on the design of the page. The functionality is the important part, but it should be intuitive enough for the TA’s to figure out how to accomplish the requirements, and the HTML used should be well-formed. . You are required to use prepared statements for the queries that will contain data submitted by the user. . Note: Don’t forget that PHP code only runs ONTHE SERVER when the page is requested. Additionally, the files containing your code must have an extension of .php or the code will not run. What to turn in? Submit, through Blackboard, the following: The PHP file(s). If you have more than one, name them in a way that makes it clear what the purpose of each file is . A link to that same PHP file, hosted on our webserver. Place it in your public-html directory and provide the appropriate link in the comments of the Blackboard submission page Relations to Use in SQL Examples SQL General Syntax General syntax of SQL retrieval is SELECT IDISTINCT I ALLII [list-of-attributes] STATUS-İCITY s# S1 Smith 20 S2 Jones 10 S3Blake S4 S5 Adams 30 FROM list-of-tables London Paris Paris [WHERE condition] [GROUP BY column-list HAVING condition] [ORDER BY column-list]; 30 20 London Athens 07 – Data Retrieval in SQL SP Relations to Use in SQL Examples S1 P1 300 Relations to Use in SQL Examples Sil P4 PNAMECOLOR WEIGHT PL-İNut P3 Screw P5 CamBlue 1 P5100 100 12 Bolt en Blue S3 P2200 P6 Cog Red 19 S4 P4300 S4P5 400 Show transcribed image text PHP Form Parts/Suppliers (1oo pts) For this assignment, you will be developing PHP/PDO code for a page or pages that accomplish the requirements found below You will be using your own personal database (the one that has your zid as a name). Before you start, create the tables from the SQL DML slides (S, SP, P) and make sure they contain the data in the rows found in the slides. None of the columns should be allowed to be NULL I. There must be a way to show all of the suppliers. (lopt 2. There must be a way to show all of the parts. (topts) 3. There must be a form that allows a user to select a part and see everyone who supplies that part and how many they have (2opts) 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. (2opts) 5. There must be a form that allows a user to add a new part to the database. (2opts) 6. There must be a form that allows a user to add a new supplier to the database. (2opts) Important Notes . You will have a fair amount of leeway on the design of the page. The functionality is the important part, but it should be intuitive enough for the TA’s to figure out how to accomplish the requirements, and the HTML used should be well-formed. . You are required to use prepared statements for the queries that will contain data submitted by the user. . Note: Don’t forget that PHP code only runs ONTHE SERVER when the page is requested. Additionally, the files containing your code must have an extension of .php or the code will not run. What to turn in? Submit, through Blackboard, the following: The PHP file(s). If you have more than one, name them in a way that makes it clear what the purpose of each file is . A link to that same PHP file, hosted on our webserver. Place it in your public-html directory and provide the appropriate link in the comments of the Blackboard submission page
Relations to Use in SQL Examples SQL General Syntax General syntax of SQL retrieval is SELECT IDISTINCT I ALLII [list-of-attributes] STATUS-İCITY s# S1 Smith 20 S2 Jones 10 S3Blake S4 S5 Adams 30 FROM list-of-tables London Paris Paris [WHERE condition] [GROUP BY column-list HAVING condition] [ORDER BY column-list]; 30 20 London Athens 07 – Data Retrieval in SQL SP Relations to Use in SQL Examples S1 P1 300 Relations to Use in SQL Examples Sil P4 PNAMECOLOR WEIGHT PL-İNut P3 Screw P5 CamBlue 1 P5100 100 12 Bolt en Blue S3 P2200 P6 Cog Red 19 S4 P4300 S4P5 400

Expert Answer

---

Answer to PHP Form Parts/Suppliers (1oo pts) For this assignment, you will be developing PHP/PDO code for a page or pages that acc… . . .