1#@!#!123s

D7net

: / home / schoolcampuserp / sxdps.in / api / app_api /

Filename : get_TopicName.php

back

<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST)){
    
    
    $lesson_id = $_POST['lesson_id'];
    
   $query = "SELECT topic.id, topic.name,topic.session_id
FROM topic
JOIN lesson ON lesson.id = topic.lesson_id
WHERE lesson_id = $lesson_id";

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

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



?>