Homework 10: PDO—PHP Data Objects

Watch these videos:

• Install SQLite PDO (Windows only) (YouTube Links to an external site.)
• PHP Data Objects (YouTube Links to an external site.)
  • the code from the video: pdo.php Links to an external site.
• A wrap up from Tuesday's class, and an explanation of the changes I made to quizzer (video Links to an external site.)
  • new code on GitHub Links to an external site.

Make a copy of pdo.php and call it admin.php—this will be the quiz administration page for Quizzer. Update the code so that it handles adding new question-answer pairs to the database (if any are passed in via POST) and displaying the question-answer pairs from the QuizItems table we talked about in class. It doesn't need to handle removing or editing quiz questions, only adding new ones.

Make another copy called analytics.php that does the following on on every load:

• displays an HTML table of all of the questions and answers from QuizItems
• displays an HTML table where each row is a submission with one column for each question response, highlighted red if it was incorrect or green otherwise, and a final column containing the score

Update questions.php so that it creates the $quiz object based on the question-answer pairs from the QuizItems table.

Update grade.php so that when a submission is made via POST, that submission is added to the Submissions / QuizItemResponses tables.

Remember, to get credit for the homework, you don't have to have solutions that are 100% complete and working; I want to see that you made an effort to get them working so you can ask informed questions in class and so that when we go over and extend the homework in class, you have some working context for what we're doing.

Commit your two PHP files in a folder homework/hw10/ in your CSC302 git repo and push to GitHub. Submit a link to your the hw10 folder on GitHub to this Canvas assignment.