setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Handle form submission
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['marks'])) {
$class = $_POST['class'];
$term = $_POST['term'];
$year = $_POST['year'];
$marks = $_POST['marks'];
$count = 0;
$stmt = $pdo->prepare("INSERT INTO midterm_results
(STUDENT_ID, CLASS, TERM, YEAR, SCI, ENG, MTC, SST)
VALUES (:id, :class, :term, :year, :sci, :eng, :mtc, :sst)
ON DUPLICATE KEY UPDATE
SCI = :sci, ENG = :eng, MTC = :mtc, SST = :sst");
foreach ($marks as $id => $subjectMarks) {
if (is_array($subjectMarks)) {
$sci = $subjectMarks['SCI'] ?? null;
$eng = $subjectMarks['ENG'] ?? null;
$mtc = $subjectMarks['MTC'] ?? null;
$sst = $subjectMarks['SST'] ?? null;
$stmt->execute([
':id' => $id,
':class' => $class,
':term' => $term,
':year' => $year,
':sci' => $sci,
':eng' => $eng,
':mtc' => $mtc,
':sst' => $sst,
]);
$count++;
}
}
echo "✅ $count records saved successfully.
";
}
// Show form
if (isset($_GET['class'])) {
$class = $_GET['class'];
$term = $_GET['term'] ?? '';
$year = $_GET['year'] ?? '';
$stmt = $pdo->prepare("SELECT STUDENT_ID, STUDENT_NAME FROM STUDENTS WHERE CLASS = :class ORDER BY STUDENT_NAME");
$stmt->execute([':class' => $class]);
$students = $stmt->fetchAll(PDO::FETCH_ASSOC);
if (count($students) > 0): ?>
Enter Midterm Marks for Class
No students found for class: " . htmlspecialchars($class) . "";
endif;
} else {
// If class is not selected
?>
Select Class to Enter Midterm Marks