Oracle B25-317-01 User Manual download pdf (Page 49)

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,

1 2 ... 44 45 46 47 48 49 50 51 52 53 54 ... 93 94

No comments

Oracle B25-317-01 User Manual Page 49