setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Handle subject update/insert
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
header('Content-Type: application/json');
$action = $_POST['action'];
$student_id = $_POST['student_id'] ?? '';
$term = $_POST['term'] ?? '';
$subject = $_POST['subject'] ?? '';
$score = $_POST['score'] ?? '';
$user = 'System'; // No login; default recorded_by
if ($action === 'insert_midterm_subject') {
$table = 'MIDTERM_LOWER';
} elseif ($action === 'insert_eot_subject') {
$table = 'EOT_LOWER';
} else {
echo json_encode(["status" => "error", "message" => "Invalid action"]);
exit;
}
try {
$check = $pdo->prepare("SELECT * FROM $table WHERE STUDENT_ID = ? AND TERM = ?");
$check->execute([$student_id, $term]);
if ($check->rowCount() > 0) {
$update = $pdo->prepare("UPDATE $table SET $subject = ? WHERE STUDENT_ID = ? AND TERM = ?");
$update->execute([$score, $student_id, $term]);
echo json_encode(["status" => "success", "message" => "$subject updated in $table"]);
} else {
$insert = $pdo->prepare("INSERT INTO $table (STUDENT_ID, TERM, $subject, RECORDED_BY) VALUES (?, ?, ?, ?)");
$insert->execute([$student_id, $term, $score, $user]);
echo json_encode(["status" => "success", "message" => "$subject inserted in $table"]);
}
} catch (Exception $e) {
echo json_encode(["status" => "error", "message" => $e->getMessage()]);
}
exit;
}
// Load students by class
if (isset($_GET['get_students']) && $_GET['get_students'] == 1 && isset($_GET['class'])) {
$stmt = $pdo->prepare("SELECT STUDENT_ID, STUDENT_NAME FROM STUDENTS WHERE CLASS = ? ORDER BY STUDENT_NAME ASC");
$stmt->execute([$_GET['class']]);
echo json_encode($stmt->fetchAll(PDO::FETCH_ASSOC));
exit;
}
// Load distinct classes
$classes = $pdo->query("SELECT DISTINCT CLASS FROM STUDENTS ORDER BY CLASS ASC")->fetchAll(PDO::FETCH_COLUMN);
?>
Teacher Panel
LUZIRA CoU PS - Results Entry
End of Term Subject Entry