MAINHACK

Viewing / Editing File: student-fetch.php

<?php
include("functions.php");

header('Content-Type: application/json');

$s_code = isset($_GET['s_code']) ? trim($_GET['s_code']) : '';
$classname = isset($_GET['classname']) ? trim($_GET['classname']) : '';

if ($s_code === '' || $classname === '') {
    echo json_encode([]);
    exit;
}

try {
   $stmt = $new->prepare("SELECT index_no, student_name, student_form 
                       FROM enrol_details 
                       WHERE s_code = ? AND classname = ? AND raw_score IS NULL
                       ORDER BY student_name ASC");
    $stmt->bind_param("ss", $s_code, $classname);
    $stmt->execute();
    $result = $stmt->get_result();

$students = [];
    while ($row = $result->fetch_assoc()) {
        $students[] = [
            "schoolID" => $row['index_no'],
            "student_name" => $row['student_name'],
            "form" => $row['student_form']
        ];
    }

echo json_encode($students, JSON_UNESCAPED_UNICODE);
} catch (Exception $e) {
    echo json_encode([]); // return empty array on error
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: student-fetch.php

Server Info

System Features

User Info