User's Manual

Combining Departments and Employees
Beta Draft Updating Data 5-13
function construct_insert_emp()
{
$deptid = $_SESSION['deptid'];
$conn = db_connect();
$query = "SELECT job_id, job_title FROM jobs ORDER BY job_title ASC";
$jobs = db_do_query($conn, $query, OCI_FETCHSTATEMENT_BY_COLUMN);
$query = "SELECT sysdate FROM dual";
$date = db_do_query($conn, $query, OCI_FETCHSTATEMENT_BY_COLUMN);
$emp = array(
'DEPARTMENT_ID' => $deptid,
'HIRE_DATE' => $date['SYSDATE'][0],
'ALLJOBIDS' => $jobs['JOB_ID'],
'ALLJOBTITLES' => $jobs['JOB_TITLE']
);
ui_print_header('Insert New Employee');
ui_print_insert_employee($emp, $_SERVER['SCRIPT_NAME']);
ui_print_footer(date('Y-m-d H:i:s'));
}
8. Edit anyco.php. Modify the final else statement in the HTML form handler. The
handler becomes:
// Start form handler code
if (isset($_POST['insertemp'])) {
construct_insert_emp();
}
elseif (isset($_POST['saveinsertemp'])) {
insert_new_emp();
}
elseif (isset($_POST['modifyemp'])) {
construct_modify_emp();
}
elseif (isset($_POST['savemodifiedemp'])) {
modify_emp();
}
elseif (isset($_POST['deleteemp'])) {
delete_emp();
}
elseif ( isset($_POST['showemp'])
|| isset($_POST['prevemp'])
|| isset($_POST['showemp'])) {
construct_employees();
}
elseif ( isset($_POST['nextdept'])
|| isset($_POST['prevdept'])
|| isset($_POST['firstdept'])
|| isset($_POST['showdept'])) {
construct_departments();
}
else {
construct_departments();
}
9. Edit anyco_ui.php. In ui_print_department() change the HTML form to
enable it to call the employee form:
...
<form method="post" action="$posturl">
<input type="submit" value="First" name="firstdept">
<input type="submit" value="< Previous" name="prevdept">