1#@!#!123s

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

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    // Retrieve other 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"];
    $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"];

    // Handle file upload
    $attachment = "";
    if (!empty($_FILES["attachment"]["name"])) {
        $target_dir = "uploads/syllabus_attachment/";
        $target_file = $target_dir . basename($_FILES["attachment"]["name"]);
        $uploadOk = 1;
        $fileType = strtolower(pathinfo($target_file, PATHINFO_EXTENSION));

        // Check file size
        if ($_FILES["attachment"]["size"] > 5000000) { // Adjust the file size limit as needed
            $response = array("status" => "0", "message" => "File is too large.");
            $uploadOk = 0;
        }

        // Allow certain file formats
        if (!in_array($fileType, array("pdf", "doc", "docx", "jpg", "jpeg", "png", "gif"))) {
            $response = array("status" => "0", "message" => "Only PDF, DOC, DOCX, JPG, JPEG, PNG, and GIF files are allowed.");
            $uploadOk = 0;
        }

        // Check if $uploadOk is set to 0 by an error
        if ($uploadOk == 0) {
            $response = array("status" => "0", "message" => "File was not uploaded.");
        } else {
            if (move_uploaded_file($_FILES["attachment"]["tmp_name"], $target_file)) {
                $attachment = basename($_FILES["attachment"]["name"]);
            } else {
                $response = array("status" => "0", "message" => "Error uploading file.");
            }
        }
    }

    // Insert data into the database
    $insertQuery = "INSERT INTO `subject_syllabus` (`id`, `topic_id`, `session_id`, `created_by`, `created_for`, 
    `date`, `time_from`, `time_to`, `presentation`, `attachment`, `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', '$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);
}
?>