Exercises (SQL and PHP)

Exercise

Create a form that looks similar to the following (values have been typed in for later demonstration)

When you click on the "Add" button you should get a screen similar to the following:

When you click on the "Query" button, you should get a screen similar to the following:

Details:

• You only need two files: sqlform.html and sqlphp.php. Your sqlphp.php does not have to be in cgi-bin and can have permission 644.
• Create a form that has text box, radio buttons, and two submit buttons as shown above (2 marks)
• The data entered in the form is inserted into the table (1 mark)
• Error checking to ensure that none of the fields are empty when doing an insertion --Display a message to the User (0.5)
• Typing * in the "Search for" box displays all the records in the table (0.5)
• Typing in the "Search for" box a value that does not appear in the table displays a message that there is no matching record in the table (0.5)
• Typing in the "Search for" box a value that does appear in the table displays all the results (0.5 for each field--FirstName, LastName, and ID)
• Results from a search are displayed in a table with headers: FirstName, LastName, and ID (0.5)
• Error checking to ensure that the "Search for" has data and/or "Field" has been selected. "Field" will not have any starting value (0.5)

Bonus:

• Add the delete function that allow users to delete specified record(s).