1#@!#!123s

: / home / schoolcampuserp / royalhighschool.co.in / erp / api / app_api1 /

Filename : get_LessonName.php

back

<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST)){
    
    
    $subject_group_subject_id = $_POST['subject_group_subject_id'];
       $subject_group_class_sections_id = $_POST['subject_group_class_sections_id'];
    
   $query = "SELECT id, name
FROM lesson
WHERE subject_group_subject_id = $subject_group_subject_id
AND subject_group_class_sections_id = $subject_group_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 Data");
} else {
    $response = array("status" => "1", "message" => "Data retrieved successfully", "lesson_name" => $rows);
}
}else{
     $response = array("status" => "0", "message" => "Invalid request. Please provide a key via POST.");
}
echo json_encode($response);



?>