Create a simple php front end for a mysql database

Assignment Help Computer Engineering

Reference no: EM132181964

Web PHP front end for my small MYSQL database

Would someone be able to create a simple PHP front end for a MYSQL database? 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).

The PHP front end should be able to generate reports and do basic querying of the database.

Reference no: EM132181964

Questions Cloud

Describe the location of the kidneys using proper medical : Describe the location of the kidneys using proper medical terminology. Include how the placement of these organs can vary in individuals due to conditions

Describe two policies that are most important to you : Describe two policies that are most important to you. Why did you select these policies?

Explain the process of how a muscle contracts : Explain the process of how a muscle contracts. Be thorough in your answer

Knowing the circulation of csf around the brain : 1. Knowing the circulation of CSF around the brain, which ventricles would be enlarged given the location of the narrowing?

Create a simple php front end for a mysql database : A 'business table' consisting of: organisationID (primary key), business name, numOfLocations, numOfEmployees and address.

List one immune function carried out by that cell : Then list 2 types of leukocytes involved in the adaptive immune response and list one immune function carried out by that cell.

Discuss about the abstract expressionist visual art : State whether you agree or disagree with the perception of Abstract Expressionism as exemplifying individualism and freedom.

How is oxygen and carbon dioxide transported in the blood : How is oxygen and carbon dioxide transported in the blood? How is their loading and unloading is affected by temperature, pH, BPG, and PCO2?

Treatment option for parkinson disease : Would caffeine be considered an effective treatment option for Parkinson's Disease? Why or why not?

User Account

All Pages