1. PurposeIn this assignment you will extend the website you developed in assignment 1. You will createserver-side PHP scripts to process and store the quiz data sent from the form on quiz.html. Itwill involve the creation of simple MySQL tables to store and update information retrieved fromyour website.In addition, you will create a webpage that allows a quiz supervisor to view, update and deletequiz attempts.There will also be an opportunity to enhance your website beyond the above basic requirements.2. Basic Requirements (80%)[IMPORTANT] Use only mysqli commands in this assignment.1.1 Use PHP to reuse common elements in your websitePHP provides us with techniques to modularise and reuse our web application code. You need torefactor your web pages so that common static HTML elements such a menu, header and footer arewritten in common text files which are then included into your webpages.[IMPORTANT] Name the include file(s) with an .inc extension and but don’t forget to renameyour main pages with a .php extension.1.2 Create a Quiz Attempts TableCreate a table attempts in your MySQL database. The information in each attempt record shouldinclude the following fields with appropriate data types:COS60007 Creating Web Applications and Databases – Assignment 2 Page 2 of 4• attempt id (auto-generated primary key)• date and time of the attempt (generated by PHP)• first name• last name• student number• the number of the attempt (1 -3)• score for the attemptWhen a user submits a quiz attempt to the website, if an attempts table does not already exist inyour database it should be programmatically created by your code.
