1#@!#!123s

: / home / schoolcampuserp / srinfinityschool.in / api / app_api /
Filename : get_attendances.php
back
<?php
include 'connection.php';

// Check if student_session_id is received via POST
if (isset($_POST['student_session_id'])) {
    $studentSessionId = $_POST['student_session_id'];

    $query = "SELECT sa.*, at.type 
              FROM student_attendences sa 
              INNER JOIN attendence_type at ON sa.attendence_type_id = at.id 
              INNER JOIN student_session ss ON sa.student_session_id = ss.id
              WHERE ss.id = '$studentSessionId'";
    $result = $con->query($query);
    $row = $result->fetch_all(MYSQLI_ASSOC);

    if (empty($row)) {
        $response = array("status" => "0", "message" => "No records found for the student_session_id", "student_attendance" => $row);
    } else {
        $response = array("status" => "1", "message" => "Data retrieved successfully", "student_attendance" => $row);
    }
} else {
    $response = array("status" => "0", "message" => "Invalid request. Please provide a student_session_id via POST.");
}

echo json_encode($response);

?>