1#@!#!123s

: / home / schoolcampuserp / stemmanuelpublicschool.in / api / app_api /
Filename : add_Homework.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    // Retrieve values from POST request
    $class_id = $_POST["class_id"];
    $section_id = $_POST["section_id"];
    $session_id = $_POST["session_id"];
      $homework_date = $_POST["homework_date"];
       $publish_date = $_POST["publish_date"];
        $submit_date = $_POST["submit_date"];
         $subject_group_subject_id = $_POST["subject_group_subject_id"];
         $subject_id=$_POST["subject_id"];
          $description = $_POST["description"];
           $create_date = $_POST["create_date"];
            $evaluation_date = $_POST["evaluation_date"];
             $document = $_POST["document"];
             $staff_id = $_POST["staff_id"];
              $created_by = $_POST["created_by"];
  
    
    $insertQuery = "INSERT INTO `homework` (`id`, `class_id`, `section_id`, `session_id`,
    `homework_date`, `publish_date`, `submit_date`, `staff_id`, `subject_group_subject_id`,
    `subject_id`, `description`, `create_date`, `evaluation_date`, `document`, `created_by`, `evaluated_by`)
    VALUES (NULL, '$class_id', '$section_id', '$session_id', '$homework_date', '$publish_date', '$submit_date', 
    '$staff_id', '$subject_group_subject_id', '$subject_id', 
    '$description','$create_date', '$evaluation_date', '$document', '$created_by', '0')";
    
    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);
}
?>