MAINHACK

Viewing / Editing File: subject-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']) : '';
$teacher_id = isset($_GET['teacher_id']) ? trim($_GET['teacher_id']) : '';

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

try {
    $stmt = $new->prepare("SELECT DISTINCT subject_name 
                        FROM teacher_subjects 
                        WHERE s_code = ? 
                        AND TRIM(classname) = TRIM(?) 
                        AND TRIM(teacher_id) = TRIM(?)");

$stmt->bind_param("sss", $s_code, $classname, $teacher_id);
    $stmt->execute();
    $result = $stmt->get_result();

$subjects = [];
    while ($row = $result->fetch_assoc()) {
        $subjects[] = $row['subject_name'];
    }

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

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: subject-fetch.php

Server Info

System Features

User Info