Create a HTML form with a PHP handler. On the main page, include a form with eld
ID: 3794936 • Letter: C
Question
Create a HTML form with a PHP handler. On the main page, include a form with elds to record the information. The fields can only accept the data in the format indicated in the parenthesis (see below).
Inspector’s name (string)
Date of inspection (date)
Hive number (integers from 1 to 10)
Queen (Y or N)
Eggs (Y or N)
Larva (Small or Large)
Capped Brood (Y or N)
Hive mood (Aggressive, Calm, Lethargic)
Capped Queen Cells (Swarm, Supercedure, None)
Empty Queen Cells (accept any integers)
Infestations (hive beetles, wax moth, varroa mites)
Problems (this is a comment field)
Needs (Oxalic Acid Tmnt, Queen Excluder, Honey Super, Brood Box)
Clicking the Submit button should save the data in the database created by your program. Include a link or a button for opening a document that displays inspection information in some nice organized manner. You can decide how you want to display that, as long as it looks legible and organized.
IMPORTANT: Please understand that your SQL database needs to be created by your program, and all the tables with fields are created by your program as well. User will enter the data that will populate the database. In the past a student set up the MySQLdatabase on his computer and wrote a program that was entering data into that database. It worked until he submitted the program files. This program did not work when I ran it. When I grade your code, I will not have your database on my computer (everyone's will be slightly different), so it has to be created and populated at runtime, on any computer that runs your program. You can only assume that computer has PHP/SQL server already running. Part of the chapter shows you how to create/manipulate databases on your SQL server, so that you can learn how to make SQL queries. This is not what you will do in this assignment. The chapter also shows you how to create DB, tables, etc. in your code. This IS what you will be doing in your code. Please be clear on what your program is supposed to do.