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

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!