1#@!#!123s

: / home / schoolcampuserp / dpsgsitamarhi.co.in / api / app_api /

Filename : section_class.php

back

<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST)){
    
    
    $class_name = $_POST['class_name'];
    
   $query = "SELECT class_sections.id, 
       sections.section
FROM class_sections
INNER JOIN sections ON sections.id = class_sections.section_id
INNER JOIN classes ON classes.id = class_sections.class_id
WHERE classes.class = '$class_name'
ORDER BY class_sections.id";

$result = $con->query($query);
$rows = $result->fetch_all(MYSQLI_ASSOC);

if (empty($rows)) {
    $response = array("status" => "0", "message" => "No records found for the class ID");
} else {
    $response = array("status" => "1", "message" => "Data retrieved successfully", "sections_class" => $rows);
}
}else{
     $response = array("status" => "0", "message" => "Invalid request. Please provide a class_id via POST.");
}
echo json_encode($response);



?>