MAINHACK

Viewing / Editing File: api_exeat.php

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

include("../functions.php");

$myschoolcode = $_SESSION['myschoolcode'] ?? '';
$schoolID  = $_SESSION['student_id0023894'] ?? '';

// ---- READ INPUTS (GET or POST) ----
$myschoolcode = $_GET['myschoolcode'] ?? $_POST['school_code'] ?? '';
$schoolID     = $_GET['student_id0023894'] ?? $_POST['student_id'] ?? '';

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

// ---- PREPARED STATEMENT FOR SECURITY ----
$sql = "SELECT id, student_id, school_code, exit_code, datetime_out, datetime_in, reasons, return_status, datereturn
        FROM student_exit
        WHERE school_code = ? AND student_id = ?
        ORDER BY id DESC";

$stmt = mysqli_prepare($new, $sql);
mysqli_stmt_bind_param($stmt, "ss", $myschoolcode, $schoolID);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);

// ---- FORMAT OUTPUT ----
$attendanceList = [];

while ($row = mysqli_fetch_assoc($result)) {

// Calculate days between out & in
    $days = null;
    if (!empty($row['datetime_out']) && !empty($row['datetime_in'])) {
        $start = new DateTime($row['datetime_out']);
        $end   = new DateTime($row['datetime_in']);
        $days  = $start->diff($end)->days;
    }

$attendanceList[] = [
        "id"            => $row["id"],
        "student_id"    => $row["student_id"],
        "school_code"   => $row["school_code"],
        "exit_code"     => $row["exit_code"],
        "datetime_out"  => $row["datetime_out"],
        "datetime_in"   => $row["datetime_in"],
        "days_away"     => $days,
        "reason"        => $row["reasons"],
        "return_status" => $row["return_status"],
        "date_return"   => $row["datereturn"]
    ];
}

// ---- SEND RESPONSE ----
echo json_encode([
    "status" => "success",
    "records_count" => count($attendanceList),
    "data" => $attendanceList
], JSON_PRETTY_PRINT);

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: api_exeat.php

Server Info

System Features

User Info