prepare($sql1);
$stmt1->bind_param("diii", $Session_Hours, $Program_ID, $Group_ID, $Course_ID);
$stmt1->execute();
$affected1 = $stmt1->affected_rows;
$stmt1->close();
// Update course_group_schedule_main
$sql2 = "UPDATE course_group_schedule_main
SET Course_Hours = ?
WHERE Program_ID = ? AND Group_ID = ? AND Course_ID = ?";
$stmt2 = $mysqli->prepare($sql2);
$stmt2->bind_param("diii", $Session_Hours, $Program_ID, $Group_ID, $Course_ID);
$stmt2->execute();
$affected2 = $stmt2->affected_rows;
$stmt2->close();
/* // Optionally, update the master Courses table as well:
$sql3 = "UPDATE Courses SET Course_Time = ? WHERE Program_ID = ? AND Course_ID = ?";
$stmt3 = $mysqli->prepare($sql3);
$stmt3->bind_param("dii", $Session_Hours, $Program_ID, $Course_ID);
$stmt3->execute();
$affected3 = $stmt3->affected_rows;
$stmt3->close(); */
// Success message
if ($affected1 > 0 || $affected2 > 0 ) {
$_SESSION['flash_msg'] = '✅ Course hours updated successfully in all relevant tables!';
$_SESSION['flash_type'] = 'success';
} else {
$_SESSION['flash_msg'] = 'No records were updated. Please check your selection.';
$_SESSION['flash_type'] = 'warning';
}
header('Location: updatecoursesessionhours.php');
exit;
}
?>