MAINHACK

Viewing / Editing File: api_timetable.php

<?php
header("Content-Type: application/json");
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: GET");

include("../functions.php"); // gives $new connection

// Accept parameters from GET or SESSION
$index_no = $_GET['index_no'] 
    ?? $_SESSION['student_id0023894'] 
    ?? $_SESSION['index_no78897498'] 
    ?? '';

$school_code = $_GET['school_code'] 
    ?? $_SESSION['myschoolcode'] 
    ?? '';

if (!$index_no || !$school_code) {
    echo json_encode([
        "status" => "error",
        "message" => "Missing required parameters (index_no, school_code)"
    ]);
    exit();
}

/*
|--------------------------------------------------------------------------
| 1. FIND STUDENT CLASS ID
|--------------------------------------------------------------------------
*/
$qClass = mysqli_query($new,
    "SELECT class_id 
     FROM enrol_details 
     WHERE s_code = '$school_code' 
       AND schoolID = '$index_no' 
     LIMIT 1");

if (!$qClass || mysqli_num_rows($qClass) == 0) {
    echo json_encode(["status" => "error", "message" => "Class not found for student"]);
    exit();
}

$class_row = mysqli_fetch_assoc($qClass);
$class_id = $class_row['class_id'];

/*
|--------------------------------------------------------------------------
| 2. GET PROGRAM ID FOR CLASS
|--------------------------------------------------------------------------
*/
$qProg = mysqli_query($new,
    "SELECT program_id 
     FROM class 
     WHERE s_code = '$school_code' 
       AND cid = '$class_id'
     LIMIT 1");

$prog_row = mysqli_fetch_assoc($qProg);
$program_id = $prog_row['program_id'] ?? null;

/*
|--------------------------------------------------------------------------
| 3. GET PROGRAM NAME
|--------------------------------------------------------------------------
*/
$program_name = "";

if ($program_id) {
    $qProgName = mysqli_query($new,
        "SELECT program_name 
         FROM programme 
         WHERE s_code = '$school_code' 
           AND progid = '$program_id' LIMIT 1");

$pname = mysqli_fetch_assoc($qProgName);
    $program_name = $pname['program_name'] ?? "";
}

// If no program name found, fallback to enrol_details
if (empty($program_name)) {
    $qFallback = mysqli_query($new,
        "SELECT programe 
         FROM enrol_details 
         WHERE s_code = '$school_code' 
           AND schoolID = '$index_no' LIMIT 1");

$fallback = mysqli_fetch_assoc($qFallback);
    $program_name = $fallback['programe'] ?? "";
}

if (empty($program_name)) {
    echo json_encode(["status" => "error", "message" => "Program not found"]);
    exit();
}

/*
|--------------------------------------------------------------------------
| 4. GET TIMETABLE RECORDS
|--------------------------------------------------------------------------
*/
$qTime = mysqli_query($new, 
    "SELECT DISTINCT semester, s_code, programName, academic_year 
     FROM timetable1 
     WHERE s_code = '$school_code' 
       AND programName = '$program_name'
     ORDER BY academic_year DESC, semester ASC");

if (!$qTime) {
    echo json_encode(["status" => "error", "message" => mysqli_error($new)]);
    exit();
}

if (mysqli_num_rows($qTime) == 0) {
    echo json_encode(["status" => "success", "data" => []]);
    exit();
}

/*
|--------------------------------------------------------------------------
| 5. FORMAT OUTPUT FOR MOBILE APP
|--------------------------------------------------------------------------
*/
$output = [];
$cnt = 1;

while ($row = mysqli_fetch_assoc($qTime)) {
    $output[] = [
        "no" => $cnt++,
        "school_code" => $row['s_code'],
        "programme" => $row['programName'],
        "semester" => $row['semester'],
        "academic_year" => $row['academic_year'],
        "view_link" => "print-timetable?s_code=" . urlencode($row['s_code']) . "&semester=" . urlencode($row['semester'])
    ];
}

/*
|--------------------------------------------------------------------------
| 6. SEND JSON RESPONSE
|--------------------------------------------------------------------------
*/
echo json_encode([
    "status" => "success",
    "student" => $index_no,
    "program" => $program_name,
    "data" => $output
], JSON_PRETTY_PRINT);
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: api_timetable.php

Server Info

System Features

User Info