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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!