Question: (1) Design an HTML form, hw6q1.php, for entering a product record (please refer to the Products table in the Northwind database). The form must contain

 (1) Design an HTML form, hw6q1.php, for entering a product record

(1) Design an HTML form, hw6q1.php, for entering a product record (please refer to the Products table in the Northwind database). The form must contain input types that support the entries of productlD (integer), product name(string), supplierlD(integer), category ID (an integer between [1- 8]), unit price (decimal), units in stock (positive integer), discontinued (1 or 0). Radio input types must be used for the discontinued entry. Drop-down lists must be used for the supplierlD entry and categoryID entry to restrict the value range of supplierlD to 1-29 and that of categorylD to 1-8. (20 pts) (Due in class on Thursday, October 26, 2017) (2) Input validation: Write the PHP code that validates user entries. All form attributes are required except productlD. Do not use the "required" attribute in HTML. Use the PHP code to accomplish the task. Quantity per unit, unit price, units of stock must be greater than or equal to 0. If errors are found after the user submits the form, stay on the same PHP page and display an error message for each missing/incorrect user entry under the corresponding input element. Correct user entries should be kept on the PHP page while an error message is displayed for each incorrect entry within proximity. If no errors are found, direct the HTTP request to the PHP code developed for (3). (20 pts) (Due in class on Thursday, October 26, 2017)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!