write php and html code

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%

Please write php and html code just

Thank you ? 

create a history page
based on a history table in a database. To be
specific, you are asked to create a table called
History in any DB you want. The table will have
the following information: PatientID (int 10),
PatentName (VarChar 150), DoctorID (int 10),
DoctorName(VarChar 150), BackgroundCheck
(varchar 1000), Diagnosis (varchar 1000),
Treatment (varchar 1000).
After Creating the DB and the Table described
above, Fill the table with dummy data, then
create a PHP that contains two things:
1. A dropdown list with all doctor IDs from the
DB
2. A table listing all history contents
Functionality:
Basically, what you have to do is to make the
table dynamically changing with the change of
the doctorID dropdown list. You may use AJAX if
you want.
Transcribed Image Text:create a history page based on a history table in a database. To be specific, you are asked to create a table called History in any DB you want. The table will have the following information: PatientID (int 10), PatentName (VarChar 150), DoctorID (int 10), DoctorName(VarChar 150), BackgroundCheck (varchar 1000), Diagnosis (varchar 1000), Treatment (varchar 1000). After Creating the DB and the Table described above, Fill the table with dummy data, then create a PHP that contains two things: 1. A dropdown list with all doctor IDs from the DB 2. A table listing all history contents Functionality: Basically, what you have to do is to make the table dynamically changing with the change of the doctorID dropdown list. You may use AJAX if you want.
Expert Solution
Step 1 The details given in the above given question is mention as below

Given :-

in the above question, a statement is mention in the above given question

 

Need to write a php code as specified in the above given question

The required solution is mention in step (2) below as,

 

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Features of HTML
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education