Question: You have been provided with a PHP page (chapter14-project1.php) along with various include files. You will need to retrieve information from two tables: Employees and

You have been provided with a PHP page (chapter14-project1.php) along with various include files.

You will need to retrieve information from two tables: Employees and EmployeeToDo.You will need to display the first and last name from every record in the Employee table within an unordered list. The data should be sorted by the LastName field.

Each employee name in the list should be a link back to the same page (chapter14-project1.php), but with the EmployeeID field appended via a query string parameter.

When a request is received with a query string, then the page will display additional information within the Employee Details

. In the Address tab group, display the rest of the employee record information. In the TO DO tab group, display the related records from the EmployeeToDo table for that EmployeeID. Sort the EmployeeToDo data by the DateBy field.

chapter14-project1.php

?>

Chapter 14

Employees

    element. */ ?>

Employee Details

Address To Do
Date Status Priority Content

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!