/home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Manager/Inc
Edit: /home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Manager/Inc/AddCourseTime.php (1709B)
real_escape_string($_POST['Time_Slot']);
$query = "SELECT * FROM Time_Slot Where Time_Slot_ID ='". $Time_Slot_ID ."'";
$result = $mysqli->query($query);
$Managers = $result->fetch_assoc();
$Time_Slot_Name = $Managers['Time_Slot'];
$Time_From = $mysqli->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 INSERT statement
$query = "INSERT INTO Time_Slot_Programs (Time_Slot_ID, Time_Slot, Time_From, Time_To, Register_Time) VALUES (?, ?, ?, ?, ?)";
if ($stmt = $mysqli->prepare($query)) {
$stmt->bind_param('sssss', $Time_Slot_ID, $Time_Slot_Name, $Time_From, $Time_To, $Register_Time);
if ($stmt->execute()) {
header('Location: addcoursetime.php?error=Time slot added successfully');
exit();
} else {
header('Location: addcoursetime.php?error=Failed to add time slot');
exit();
}
$stmt->close();
} else {
header('Location: addcoursetime.php?error=Database error: ' . $mysqli->error);
exit();
}
} else {
header('Location: addcoursetime.php?error=Missing required fields');
exit();
}
}
?>