Question: Web program server side Php language Question 1 (25 pts) : We need to create a web site for an online health center Create the



Web program server side Php language
Question 1 (25 pts) : We need to create a web site for an online health center Create the database that includes the following tables: Doctor: Phone# (int) Name (Varchar) Specialty (Varchar) Address (Varchar) Speciality SPID (int) Description (Varchar) Fill few records in the table Specialty Splb Description 1 Allergy & immunology 2 Cardiology 3 Cardiothoracic surgery 4 Dermatology 5 Family Medicine Question 2 (10 pts): Create an index page allows user to select his option Add a doctor Display All Doctors Question 3 (40 pts) : AS user selects Add a Doctor, a new page AddDoctor.php lets user to add a new doctor to the database Add a Doctor Phone : Name: Address: Specialty: Cardiology Submit 3/4 Reset As the page is loaded Combo box loads all the data from specialty database table Three text boxes allow user to enter doctor's phone number, address, and his/her name Once user submits the form, a new page save.php should save a new record into doctor table A message should display whether the record is added or not. . Question 3 (25 pts): AS user selects Display AllDoctors, a new page display.php will display all doctors list from the database Phone# 1654321 1987654 3123456 11111111 61123456 61987654 Name Dr. Samir Dr. Jamil Dr. Al Chami Dr. Majzoub Dr. Haddad Dr.Haidar Specialty Family Medicine Family Medicine Pediatric Dermatology Cardiology Cardiology Address Saida Saida Kesrwan Bekaa Jbeil Beirut
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
