$future[$n] = "
| Employee | Checking E-mail | Checking Voicemail | Leaving | Returning~; for($i = 0; $i < @future; $i++) { print qq~$future[$i]~; } print qq~ |
|---|
##
if($session_cgi->param("delete")) {
$firstName = $session_cgi->param("firstName");
$lastName = $session_cgi->param("lastName");
$startdate = $session_cgi->param("start_date");
$enddate = $session_cgi->param("end_date");
$db = dbLoad($db);
$select_statement = "SELECT id FROM Employees
WHERE lastName = '$lastName' and firstName =
'$firstName'";
$select_it = $db->prepare($select_statement);
$rc = $select_it->execute() or die "Could not
run query '$select_statement'\n";
$select_it->bind_columns(undef, \$user_id);
$select_it->fetchrow_arrayref();
$statement = "DELETE FROM Out_Of_Office WHERE
id = '$user_id' and start_date = '$start_date' and
end_date = '$end_date'";
$statement = $db->prepare($statement);
$rv = $statement->execute() or die "Couldn't
execute query '$query' \n";
$db->disconnect();