1#@!#!123s

: / home / schoolcampuserp / dpsgsitamarhi.co.in / api / app_api /
Filename : add_UploadContent.php
back
<?php
include 'connection.php';

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    // Retrieve values from POST request
     $title = $_POST["title"];
    $type = $_POST["type"];
    $class_id = $_POST["class_id"];
    $cls_sec_id = $_POST["cls_sec_id"];
     $file = $_POST["file"];
      $created_by = $_POST["created_by"];
       $note = $_POST["note"];
      $upload_date = $_POST["upload_date"];
       $publish_date = $_POST["publish_date"];
        
    
    $insertQuery = "INSERT INTO `contents` (`id`, `title`, `type`, `is_public`, `class_id`, `cls_sec_id`, `file`,
    `created_by`, `note`, `is_active`, `created_at`, `updated_at`, `date`, `publish_date`) 
    VALUES (NULL, '$title', '$type', 'No', '$class_id', '$cls_sec_id', '$file', '$created_by', '$note',
    'no', CURRENT_TIMESTAMP,NULL, '$upload_date', '$publish_date')";
    
    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);
}
?>