setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Handle subject score insert/update
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 = "teacher"; // Hardcoded if no session is used
$table = ($action === 'insert_midterm_subject') ? "MIDTERM_LOWER" : (($action === 'insert_eot_subject') ? "EOT_LOWER" : null);
if (!$table) {
echo json_encode(["status" => "error", "message" => "Invalid action"]);
exit;
}
try {
$stmt = $conn->prepare("SELECT * FROM $table WHERE STUDENT_ID = :student_id AND TERM = :term");
$stmt->execute([':student_id' => $student_id, ':term' => $term]);
if ($stmt->rowCount() > 0) {
$update = $conn->prepare("UPDATE $table SET $subject = :score WHERE STUDENT_ID = :student_id AND TERM = :term");
$update->execute([':score' => $score, ':student_id' => $student_id, ':term' => $term]);
echo json_encode(["status" => "success", "message" => "$subject updated successfully"]);
} else {
$insert = $conn->prepare("INSERT INTO $table (STUDENT_ID, TERM, $subject, RECORDED_BY) VALUES (:student_id, :term, :score, :user)");
$insert->execute([':student_id' => $student_id, ':term' => $term, ':score' => $score, ':user' => $user]);
echo json_encode(["status" => "success", "message" => "$subject inserted successfully"]);
}
} catch (Exception $e) {
echo json_encode(["status" => "error", "message" => "DB Error: " . $e->getMessage()]);
}
exit;
}
// Get students based on class
if (isset($_GET['get_students']) && $_GET['get_students'] == 1 && isset($_GET['class'])) {
$stmt = $conn->prepare("SELECT STUDENT_ID, STUDENT_NAME FROM STUDENTS WHERE CLASS = :class ORDER BY STUDENT_NAME ASC");
$stmt->execute([':class' => $_GET['class']]);
echo json_encode($stmt->fetchAll(PDO::FETCH_ASSOC));
exit;
}
// Only P1, P2, P3
$classes = ['P1', 'P2', 'P3'];
?>
Results Entry – P1 to P3
Results Entry (P1, P2, P3)
End of Term Subject Entry