/home/techb158/workloadmatch.com/Manager/Inc
Edit: /home/techb158/workloadmatch.com/Manager/Inc/Update_Group - Copy.php (3489B)
prepare($querys);
$stmt->bind_param("s", $user_n);
$stmt->execute();
$results = $stmt->get_result();
$rows = $results->fetch_assoc();
if (!$rows) {
header('Location: addgroup.php?error=Manager profile not found!');
exit();
}
$Admin_ID = $rows['Admin_ID'];
$Master_ID = $rows['Master_ID'];
$Manager_ID = $rows['Manager_ID'];
$datetime = date("Y/m/d") . ' ' . date('H:i:s');
// Check if Group_ID exists
$prep_stmt = "SELECT Group_ID FROM manager_group_name WHERE Manager_ID = ? AND Group_ID = ? LIMIT 1";
$stmt = $mysqli->prepare($prep_stmt);
if ($stmt) {
$stmt->bind_param('ss', $Manager_ID, $Group_ID);
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows == 1) {
// Update the existing group information using a prepared statement
$update_stmt = "UPDATE manager_group_name
SET Weekend_Class = ?, Group_Name = ?, Group_Year = ?, Time_Slot = ?, Time_From = ?, Time_To = ?
WHERE Manager_ID = ? AND Group_ID = ?";
$stmt = $mysqli->prepare($update_stmt);
if ($stmt) {
$stmt->bind_param("ssssssss", $weekendClass, $Group_Name, $Group_Year, $time_slot_combined, $Time_From, $Time_To, $Manager_ID, $Group_ID);
if ($stmt->execute()) {
header('Location: addgroup.php?error=Group update successfully. Thanks!');
exit();
} else {
header('Location: addgroup.php?error=Group update failure!');
exit();
}
} else {
header('Location: addgroup.php?error=Database update error!');
exit();
}
} else {
header('Location: addgroup.php?error=Group not found!');
exit();
}
} else {
header('Location: addgroup.php?error=Database query error!');
exit();
}
} else {
header('Location: addgroup.php?error=All information is required!');
exit();
}
}
?>