/home/techb158/workloadmatch.com/Manager/Inc
Edit: /home/techb158/workloadmatch.com/Manager/Inc/Update_Holiday.php (2357B)
real_escape_string($_POST['Event_Title']);
$Calendar_Year = $_POST['Calendar_Year'];
$Event_Description = isset($_POST['Event_Description']) ? $mysqli->real_escape_string($_POST['Event_Description']) : '';
$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");
// Debugging: Check if values are correct before the query
if (empty($Event_ID) || empty($Event_Title) || empty($Calendar_Year) || empty($Time_From) || empty($Time_To)) {
set_flash_msg('Invalid or missing data', 'warning');
header('Location: addholiday.php');
exit();
}
// Prepare update statement
$query = "UPDATE Events
SET Event_Title = ?, Event_Description = ?, Calendar_Year = ?, Event_Start = ?, Event_End = ?, Register_Time = ?
WHERE Event_ID = ?";
if ($stmt = $mysqli->prepare($query)) {
$stmt->bind_param('ssssssi', $Event_Title, $Event_Description, $Calendar_Year, $Time_From, $Time_To, $Register_Time, $Event_ID);
if ($stmt->execute() && $stmt->affected_rows > 0) {
set_flash_msg('Event updated successfully', 'success');
header('Location: addholiday.php');
exit();
} else {
set_flash_msg('No changes made or update failed', 'warning');
header('Location: addholiday.php');
exit();
}
$stmt->close();
} else {
set_flash_msg('Database error: ' . $mysqli->error, 'warning');
header('Location: addholiday.php');
exit();
}
} else {
set_flash_msg('Missing required fields', 'warning');
header('Location: addholiday.php');
exit();
}
}