All parts

This is an individual project with 2 phases, and this is the 2nd phase. Phase #2 will require you to develop the following functions (total 100 points). (5 pts) All phase #1 features and functions should be included in phase a2. (5 pts) Create one new table Products X00OX under the database CPS3740 2017S where 00Xis your Kean Email ID. Your table names must follow the above format (case sensitive). Table Products XXXX should have the following fields in correct data types. id: auto increment integer, primary key name: varchar 255), NOT NULL description: varchar(255) NOT NULL sell price float, NOTNULL cost: float, NOT NULL quantity: int, NOT NULL user id: int, NOT NULL foreign key to the id field in CPS3740.Users table. vendor id: int, NOT NULL, a foreign key to the V ld field in CPS3740.Vendors table. Table CPS3740. Vendors has fields (V ld, Name, Zipcode, State). 3. Add a search function on the project 2 home page with a "Search Products button after the keyword textbox (shown in Figure 1)which will call a new CGI program to do the following search functions after users click on the "Search Products" button, your program willuse the keywords to do pattern match on both name and description columns in your Product table. 3.1 (5 pts) If the keyword is all product records should be displayed. fthe keyword isempty, an error message "no keyword entered" should be displayed and the program should not access database. 3.2 (5 pts) If no record found, please display "No record found with the search keywords: f records found, please display all matched records in HTML TABLE tag format. 3.3 (5 pts) Search function should use GET method inthe HTML FORM The search URL should like: eve kean ed CPS3740 search product.php?keywords the input kewords htt Your IP: 57.83.156.42 Welcome to Austin uang's CPS3740 project 2. You are NOT from Kean Unversity. Welcome user: XYZ BBB Role: staff Keyword Search products Address: 33 James St., NJ, 07331 Login ID: Panda Password: Submit Figure 1. New search product function This is an individual project with 2 phases, and this is the 2nd phase. Phase #2 will require you to develop the following functions (total 100 points). (5 pts) All phase #1 features and functions should be included in phase a2. (5 pts) Create one new table Products X00OX under the database CPS3740 2017S where 00Xis your Kean Email ID. Your table names must follow the above format (case sensitive). Table Products XXXX should have the following fields in correct data types. id: auto increment integer, primary key name: varchar 255), NOT NULL description: varchar(255) NOT NULL sell price float, NOTNULL cost: float, NOT NULL quantity: int, NOT NULL user id: int, NOT NULL foreign key to the id field in CPS3740.Users table. vendor id: int, NOT NULL, a foreign key to the V ld field in CPS3740.Vendors table. Table CPS3740. Vendors has fields (V ld, Name, Zipcode, State). 3. Add a search function on the project 2 home page with a "Search Products button after the keyword textbox (shown in Figure 1)which will call a new CGI program to do the following search functions after users click on the "Search Products" button, your program willuse the keywords to do pattern match on both name and description columns in your Product table. 3.1 (5 pts) If the keyword is all product records should be displayed. fthe keyword isempty, an error message "no keyword entered" should be displayed and the program should not access database. 3.2 (5 pts) If no record found, please display "No record found with the search keywords: f records found, please display all matched records in HTML TABLE tag format. 3.3 (5 pts) Search function should use GET method inthe HTML FORM The search URL should like: eve kean ed CPS3740 search product.php?keywords the input kewords htt Your IP: 57.83.156.42 Welcome to Austin uang's CPS3740 project 2. You are NOT from Kean Unversity. Welcome user: XYZ BBB Role: staff Keyword Search products Address: 33 James St., NJ, 07331 Login ID: Panda Password: Submit Figure 1. New search product function