php and mysql

You are asked to create an online web application to collect all the students' information. This application will collect the Student ID, Student Name, Student Department and one pull-down menu to collect the student's study year: (i.e. Year1, Year2, and Year3) as shown in Figure Q3(1). Student Information Student ID: Student name: Department: Year: Yeart Year2 Year3 Year4 Submit Clear Form Year Figure Q3(1): Students' Information Assume that a MySQL database and Student table have been created with the following specifications as shown in Figure 23(2) and Table Q3. mycampus.upnm.edu.my Server Name Username root Password root Database Name myDB Figure Q3(2): Server Specification Key primary Extra auto, increment Field Type Null student id int(10) no student name, varchar(100) no student dept varchar(50) no student year varchar(10) Based on this specification, you are required to write a PHP code to: a. Create a connection to myDB database and check whether the connection is successful or fail. Create a Student table to store all the student data as shown in Table b. Q3 C. Insert all the information provided as shown in Figure Q3(1) and the data will be saved into the Student table. You are required to create a form in order to insert the data to the Student table. Display all student records that are in the same department as shown in Figure Q3(3). d. + Student Name Student ID 12345 12346 12347 12348 Alan Jack Berlin Tokio Year Year 1 Year 2 Year 2 Year 3 Department CS CS CS CS Figure Q3(3): Student Record (C04:PO4 - 30 marks)