Given the following MySQL table: doctors (The Primary key in the first column and it is an automatic number)

Table name: doctors (for Doctors) column names are highlighted

dId

Doctor ID dName

Name dSalary

Salary dJoinDate

Joining date dGender

Gender

dWilyatSq

Wilayat Id

200

Saif Ali

950 2011-08-03 M

3

300

Muneer Khalid

980

2009-01-25 M

2

500

Rawan Sami

870

2019-03-14 F

2

Table name: wilayats(for Wilayat data)

wSq

Wilayat ID wName

Wilayat Name

1 Nizwa

2 Izki

3 Bahla

2. Given also the following HTML form page and its source code that is used to add data to MySQL database

Web Browser Output

Adding data for new Doctors

Name:

Salary:

Joining Date:

Wilayat

Gender: Male Female

Name:

Salary:

Joining Date:

Wilayat:

-- Select --

Bahla..

Gender:

value="M">Male

Female

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)

Sanitize ONLY the input value of the Name field.

Write the query that will ADD this new data to the doctors table which is described above? (note that the dId is an auto-increment field)

Write the statement that will execute this query

Redirect the user to this page newDoctorForm.php after the adding process.

Type your answer in the box shown below, no file upload is required