MAINHACK

Viewing / Editing File: api_myclassmate.php

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

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

// Get session values safely
$school_code = $_GET['school_code'] ?? ($_SESSION['myschoolcode'] ?? '');
$thisismyclassname = $_GET['thisismyclassname'] ?? ($_SESSION['my_value'] ?? '');

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

$sql = "SELECT 
            c.cid AS class_id,
            c.class_name,
            e.index_no,
            h.house_name
        FROM enrol_details e
        JOIN class c ON e.class_id = c.cid
        JOIN house h ON e.house_id = h.hid
        WHERE 
            e.s_code = ?
            AND (c.class_name = ? OR e.classname = ?)";

$stmt = mysqli_prepare($new, $sql);
mysqli_stmt_bind_param($stmt, "sss", $school_code, $thisismyclassname, $thisismyclassname);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);

if (!$result) {
    echo json_encode([
        "status" => "error",
        "message" => "Database query failed: " . mysqli_error($new)
    ]);
    exit();
}

$classes = [];

while ($row = mysqli_fetch_assoc($result)) {
    $class_id = $row['class_id'];

if (!isset($classes[$class_id])) {
        $classes[$class_id] = [
            "class_id" => $row['class_id'],
            "class_name" => $row['class_name'],
            "students" => []
        ];
    }

$classes[$class_id]["students"][] = [
        "index_no" => $row['index_no'],
        "house_name" => $row['house_name']
    ];
}

$response = [
    "status" => "success",
    "school_code" => $school_code,
    "requested_by" => $_SESSION['my_value'] ?? null,
    "data" => array_values($classes)
];

echo json_encode($response, JSON_PRETTY_PRINT);
?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: api_myclassmate.php

Server Info

System Features

User Info