Lower Class Results

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Handle Form Submissions if ($_SERVER['REQUEST_METHOD'] === 'POST') { $action = $_POST['action'] ?? ''; if ($action === 'load_students_by_class') { $stmt = $pdo->prepare("SELECT STUDENT_ID, STUDENT_NAME FROM STUDENTS WHERE CLASS = ? ORDER BY STUDENT_NAME"); $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"); $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 = ""; foreach (array_keys($results[0]) as $col) { $html .= ""; } $html .= ""; foreach ($results as $row) { $html .= ""; foreach ($row as $val) { $html .= ""; } $html .= ""; } $html .= "

" . htmlspecialchars($col) . "
" . htmlspecialchars($val) . "

"; return $html; } ?> Lower Class Results

Midterm Result Entry (Lower)

View Midterm Results

EOT Result Entry (Lower)

View EOT Results