Verification
Enter your password to continue
$error
"; ?>
prepare("SELECT STUDENT_ID, STUDENT_NAME FROM STUDENTS WHERE CLASS = ? ORDER BY STUDENT_NAME ASC");
$stmt->execute([$_POST['class']]);
$students = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo json_encode($students);
exit;
}
if ($action === 'add_midterm_lower') {
$stmt = $pdo->prepare("INSERT INTO MIDTERM_LOWER (
STUDENT_ID, STUDENT_NAME, CLASS, TERM, MTC, ENG, LIT1, LIT2, RE, RECORDED_BY
) VALUES (
?, (SELECT STUDENT_NAME FROM STUDENTS WHERE STUDENT_ID = ?), ?, ?, ?, ?, ?, ?, ?, ?
)");
$done = $stmt->execute([
$_POST['student_id'], $_POST['student_id'], $_POST['class'], $_POST['term'],
$_POST['mtc'] ?: null, $_POST['eng'] ?: null, $_POST['lit1'] ?: null,
$_POST['lit2'] ?: null, $_POST['re'] ?: null, $username
]);
exit($done ? "✅ Midterm (Lower) result added." : "❌ Failed to add result.");
} elseif ($action === 'view_midterm_lower') {
$stmt = $pdo->prepare("SELECT * FROM MIDTERM_LOWER WHERE CLASS = ? ORDER BY STUDENT_NAME");
$stmt->execute([$_POST['result_class']]);
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo generateTable($results);
exit;
} elseif ($action === 'add_eot_lower') {
$stmt = $pdo->prepare("INSERT INTO EOT_LOWER (
STUDENT_ID, STUDENT_NAME, CLASS, TERM, MTC, ENG, LIT1, LIT2, RE, RECORDED_BY
) VALUES (
?, (SELECT STUDENT_NAME FROM STUDENTS WHERE STUDENT_ID = ?), ?, ?, ?, ?, ?, ?, ?, ?
)");
$done = $stmt->execute([
$_POST['student_id'], $_POST['student_id'], $_POST['class'], $_POST['term'],
$_POST['mtc'] ?: null, $_POST['eng'] ?: null, $_POST['lit1'] ?: null,
$_POST['lit2'] ?: null, $_POST['re'] ?: null, $username
]);
exit($done ? "✅ EOT (Lower) result added." : "❌ Failed to add result.");
} elseif ($action === 'view_eot_lower') {
$stmt = $pdo->prepare("SELECT * FROM EOT_LOWER WHERE CLASS = ? ORDER BY STUDENT_NAME ASC");
$stmt->execute([$_POST['result_class']]);
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo generateTable($results);
exit;
}
}
function generateTable($results) {
if (empty($results)) return "No results found.
";
$html = "