1#@!#!123s

: / home / schoolcampuserp / bmsnrajganj.in / erp / api / app_api /
Filename : get_class_teacher.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $staff_id = $_POST["staff_id"];
    $session_id = $_POST['session_id'];
    
    
    // First query to fetch class teacher details
    $query = "SELECT class_teacher.*, classes.class, sections.section 
              FROM class_teacher 
              JOIN classes ON class_teacher.class_id = classes.id 
              JOIN sections ON class_teacher.section_id = sections.id 
              WHERE staff_id ='$staff_id' AND session_id ='$session_id'";
    
    $result = $con->query($query);
    $row = $result->fetch_all(MYSQLI_ASSOC);
    
    // Second query to fetch session_id from sch_settings table
    $sessionQuery = "SELECT session_id FROM sch_settings LIMIT 1";
    $sessionResult = $con->query($sessionQuery);
    $sessionRow = $sessionResult->fetch_assoc();
    $session_id = $sessionRow['session_id'];
    
    if (empty($row)) {
        $response = array(
            "status" => "0", 
            "message" => "Its empty", 
            "data" => $row,
            "session_id" => $session_id
        );
    } else {
        $response = array(
            "status" => "1", 
            "message" => "Its Available", 
            "data" => $row,
            "session_id" => $session_id
        );
    }

} else {
    $response = array(
        "status" => "0", 
        "message" => "Invalid request method. Please use POST."
    );
}

echo json_encode($response);
?>