User's Manual
Combining Departments and Employees
Beta Draft Updating Data 5-11
21.
Successfully updating the employee causes the Employee page to be redisplayed.
Scroll to the last employee row and confirm that the new employee's salary is now
7,100:
22. To remove the new employee row, select the radio button for the new employee
row, click Delete:
On successful deletion, the deleted row does not appear in the list of employees
records redisplayed in the Employees page:
Combining Departments and Employees
1. Edit anyco.php. Modify the query in construct_employees()to include a
WHERE clause to compare the department_id with a value in a bind variable
called :did. This makes the page display employees in one department at a time.
Get the deptid session parameter value to populate the bind variable:
$query =
"SELECT employee_id,