/home/techb158/workloadmatch.com/Manager/Inc
Edit: /home/techb158/workloadmatch.com/Manager/Inc/Update_Course_Time.php (1947B)
real_escape_string($_POST['Time_From']);
$Time_To = $mysqli->real_escape_string($_POST['Time_To']);
$Register_Time = date("Y/m/d H:i:s");
// Prepare an UPDATE statement
$query = "UPDATE time_slot_programs SET Time_Slot = ?, Time_From = ?, Time_To = ?, Register_Time = ? WHERE time_slot_programs_ID = ?";
if ($stmt = $mysqli->prepare($query)) {
$stmt->bind_param('ssssi', $Time_Slot, $Time_From, $Time_To, $Register_Time, $Time_Slot_ID);
if ($stmt->execute()) {
set_flash_msg('Time slot updated successfully', 'success');
header('Location: addcoursetime.php');
exit();
} else {
//die("Execution error: " . $stmt->error);
set_flash_msg('Failed to update time slot' . $stmt->error, 'warning');
header('Location: addcoursetime.php');
exit();
}
$stmt->close();
} else {
set_flash_msg('Database error: ' . $mysqli->error, 'warning');
header('Location: addcoursetime.php');
exit();
}
} else {
set_flash_msg('Missing required fields', 'warning');
header('Location: addcoursetime.php');
exit();
}
}
?>