Description
Project 1: CRM Admin (PHP and MySQL)
Overview
Demonstrate your ability to retrieve information from a database and display it using PHP and SQL. The results when finished will look similar to that shown in Figure 2 .
Instructions
-
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 <div>. 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.
Test
-
Test the page. Verify the links works as expected and that the data is correctly sorted.
Page 1 of 3
Figure 2 Completed Project 1
Submitting
Put your assignment in a folder named assign3_yourname (e.g., assign3_johnsmith). Put all resources used by your assignment into this folder and compress them into a zip file.
Page 2 of 3
Upload the assign3_yourname.zip file to the Assignment 3 submission folder under dropbox on elearning.
Page 3 of 3
