Answered step by step
Verified Expert Solution
Question
1 Approved Answer
[1 Mark] [2 Marks) a. Create the database pandemic' with MySQL. b. Create the following virus table in your pandemic database. Field Name Data Type
[1 Mark] [2 Marks) a. Create the database pandemic' with MySQL. b. Create the following virus table in your pandemic database. Field Name Data Type Length / Field Size VirusID VARCHAR 10 Virus Name VARCHAR bo DOA DATE Severity VARCHAR 20 Cases Reported INT [2 Marks) c. Enter following records into the virus table. VirusID VirusName DOA Severity V101 Alpha Variant 14-04-2021 High V102 Beta Variant 15-09-2021 Critical V103 Omicron 10-12-2021 Mild Cases 5000 12000 1000 d. Write necessary PHP script to establish a connection with the pandemic database and search the record with VirusID from the virus table with the help of a search form and display it on your webpage in a table format as shown below. [5 Marks] Search Pandemic Virus Details: Enter VirusID to Search: V101 Search db connection ok Result is Ready VirusID Virus Name DOA Severity Cases V101 Alpha Variant 2021-04-14 High 5000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started