It was pointed out that I was unclear on the work below -- that I did not mark it explicitly as a lab or give it a due date.
I therefore will not collect it, but understand that using PHP to INSERT and UPDATE is valid material for the final exam.
Design a PHP page that collects from the user the data necessary to insert a Course record in the Course table we made
as a class demonstration. (CRN, Subject Code, Course Number, Title). Your form should have four text inputs and a submit button.
Then use that data to insert a new record in the
Course table.
Design a PHP page that collects from the user the data necessary to insert a Student record in the Student table we made
as a class demonstration. (ID, First name, Last name, Major). Then use that data to insert a new record in the
Course table.
Design a PHP page that does a SELECT query on Courses and makes a drop-down select that displays the courses' subject codes,
course numbers and titles to the user and uses the CRN as a value in a drop-down select. Next your page should do a SELECT
query on the Student table and make a second drop-down select that displays the students' first and last names and use the ID
as a value in the drop-down select. Finally the user can use the two drop down selects to insert records into the StudentTakesClasses
table.
