/home/techb158/workloadmatch.com/workloadmatch.com/Manager/Inc
Edit: /home/techb158/workloadmatch.com/workloadmatch.com/Manager/Inc/Update_Course_Time.php (1755B)
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()) {
header('Location: addcoursetime.php?error=Time slot updated successfully');
exit();
} else {
//die("Execution error: " . $stmt->error);
header('Location: addcoursetime.php?error=Failed to update time slot' . $stmt->error);
exit();
}
$stmt->close();
} else {
header('Location: addcoursetime.php?error=Database error: ' . $mysqli->error);
exit();
}
} else {
header('Location: addcoursetime.php?error=Missing required fields');
exit();
}
}
?>