1#@!#!123s

: / home / schoolcampuserp / internationaldpssuri.com / api / app_api /
Filename : add_LessonPlan.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    // Retrieve values from POST request
        $topic_id = $_POST["topic_id"];
        $session_id = $_POST["session_id"];
        $created_by = $_POST["created_by"];
        $created_for = $_POST["created_for"];
        $date = $_POST["date"];
        $time_from = $_POST["time_from"];
        $time_to = $_POST["time_to"];
        $presentation = $_POST["presentation"];
        $attachment = $_POST["attachment"];
        $lacture_youtube_url = $_POST["lacture_youtube_url"];
        $lacture_video = $_POST["lacture_video"];
        $sub_topic = $_POST["sub_topic"];
        $teaching_method = $_POST["teaching_method"];
        $general_objectives = $_POST["general_objectives"];
         $previous_knowledge = $_POST["previous_knowledge"];
        $comprehensive_questions = $_POST["comprehensive_questions"];
        $status = $_POST["status"];
      
    $insertQuery = "INSERT INTO `subject_syllabus` (`id`, `topic_id`, `session_id`, `created_by`, `created_for`, 
    `date`, `time_from`, `time_to`, `presentation`, `attachment`, `lacture_youtube_url`, `lacture_video`, 
    `sub_topic`, `teaching_method`, `general_objectives`, `previous_knowledge`, `comprehensive_questions`,
    `status`, `created_at`)
    VALUES (NULL, '$topic_id', '$session_id', '$created_by', '$created_for', '$date', '$time_from',
    '$time_to', '$presentation', '$attachment', '$lacture_youtube_url', '$lacture_video', '$sub_topic', 
    '$teaching_method', '$general_objectives', '$previous_knowledge', '$comprehensive_questions', '$status', CURRENT_TIMESTAMP)";
    
    if ($con->query($insertQuery) === TRUE) {
        $response = array("status" => "1", "message" => "Data inserted successfully");
    } else {
        $response = array("status" => "0", "message" => "Error inserting data: " . $con->error);
    }

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