Question
PHP web front end for MYSQL database The PHP front end should be able to generate reports and do basic querying of the database, as
PHP web front end for MYSQL database
The PHP front end should be able to generate reports and do basic querying of the database, as well as having a login page. The database consists of five tables which are the following: An 'employee detail table' consisting of: employee ID (primary key), first name, surname, email and organisationID (foreign key). A 'business table' consisting of: organisationID (primary key), business name, numOfLocations, numOfEmployees and address. An 'incident table'consisting of: IncidentID (Primary key), date employeeID (foreign key), organisationID (foreign key) and description (varchar). A 'quiz table'consisting of: quizID (primary key), employeeID (foreign key), title, correct_Ans, wrong_Ans, average. And the log table which would list the cases stored in the incident table as either pending or resolved (tinyint). (I have already created the database, no need to create this thanks)
Thank you in advance, have a nice day
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