PHP web front end for MYSQL database The PHP front end should be able to generat

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 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

Explanation / Answer

Firstly make config.php

Now, after login, we will present user with welcome.php page which is allow quering database. i will show simple example so that it will be easy for you to add of your own and customize.

welcome.php

Suppose we want to fetch employee details and display it in table format.

Make changes as per your requirement.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.