1#@!#!123s

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

// Check if class_id, session_id, and section_id are received via POST
if (isset($_POST['class_id']) && isset($_POST['session_id']) && isset($_POST['section_id'])) {
    $classId = $_POST['class_id'];
    $sessionId = $_POST['session_id'];
    $sectionId = $_POST['section_id'];

    // Prepare the query to fetch homework data
    $query = "SELECT * FROM homework
    WHERE class_id = '$classId' AND session_id = '$sessionId' AND section_id = '$sectionId'";
    $result = $con->query($query);

    if ($result) {
        if ($result->num_rows > 0) {
            $homeworkData = array();

            while ($homework = $result->fetch_assoc()) {
                $subject_group_subject_id = $homework['subject_group_subject_id'];

                // Fetch subject name from subjects table using subject_id
                $subjectQuery = "SELECT subject_group_subjects.id, subjects.name 
                FROM subject_group_subjects
                JOIN subjects ON subject_group_subjects.subject_id = subjects.id
                WHERE subject_group_subjects.id = '$subject_group_subject_id'";
                $subjectResult = $con->query($subjectQuery);

                if ($subjectResult) {
                    $subjectData = $subjectResult->fetch_assoc();

                    // Add the subject name to the homework data
                    $homework['subject_name'] = $subjectData['name'];

                    $homeworkData[] = $homework;
                } else {
                    // Handle SQL error if needed
                    $response = array("status" => "0", "message" => "Error fetching subject data: " . $con->error);
                    echo json_encode($response);
                    exit;
                }
            }

            $response = array("status" => "1", "message" => "Data retrieved successfully", "homework" => $homeworkData);
        } else {
            $response = array("status" => "0", "message" => "No records found for the provided details", "homework" => []);
        }
    } else {
        // Handle SQL error if needed
        $response = array("status" => "0", "message" => "Error executing query: " . $con->error);
    }
} else {
    $response = array("status" => "0", "message" => "Invalid request. Please provide class_id, session_id, and section_id via POST.");
}

echo json_encode($response);
?>