2. Name : br>3. Salary: br>4. Birth Date: 5. Wilayat: 6. -- Select -- 7. Bahla .. 8. Gender: MaleAdding data for a new PersonName: Jamal ObaidSalary: 550Birth Date: 12/20/2002Wilayat...

br> 3. Salary:br> 4. Birth Date:


5. Wilayat:
6.
-- Select --
7.
Bahla..


8. Gender:Male Adding data for a new Person Name: Jamal Obaid Salary: 550 Birth Date: 12/20/2002 Wilayat Bahla Gender: O Male O Female 10.
Female 11.

Save Data Note the following: • Do NOT write the validation part. Assume that data was input correctly. • Assume that the database connection id is $conn Write PHP code to do the following (use the box below to type your answer) 1. Sanitize ONLY the input value of the Name field. 2. Write the query that will ADD this new data to the persons table which is described above? (note that the prld is an auto-increment field for the person Id) 3. Write the statement that will execute this query 4. Redirect the user to this page newPersonForm.php after the adding process. Type your answer in the box shown below, no file upload is "/>
Extracted text: Given the following MySQL table: persons (The Primary key in the first column and it is an automatic number) Table name: wilayats (for Wilayat data) wsq Table name: persons column names are highlighted prid prName prSalary prDoB prGender prWilyatsq wName Person ID Gender Wilayat id Salary Birth date 630 2011-08-03 Muneer Khalid 980 2009-01-25 870 2019-03-14 Name Wilayat ID Wilayat Name Nasser Aziz Nizwa Izki Bahla 200 M 3 300 M 2 Rawan Sami 500 F 3 2. Given also the following HTML form page and its source code that is used to add data to MYSQL database Web Browser Output 1.

2. Name :br> 3. Salary:br> 4. Birth Date:


5. Wilayat:
6.
-- Select --
7.
Bahla..


8. Gender:Male Adding data for a new Person Name: Jamal Obaid Salary: 550 Birth Date: 12/20/2002 Wilayat Bahla Gender: O Male O Female 10.
Female 11.

Save Data Note the following: • Do NOT write the validation part. Assume that data was input correctly. • Assume that the database connection id is $conn Write PHP code to do the following (use the box below to type your answer) 1. Sanitize ONLY the input value of the Name field. 2. Write the query that will ADD this new data to the persons table which is described above? (note that the prld is an auto-increment field for the person Id) 3. Write the statement that will execute this query 4. Redirect the user to this page newPersonForm.php after the adding process. Type your answer in the box shown below, no file upload is