1#@!#!123s

: / home / schoolcampuserp / erp.nationalacademykotwa.com / api / app_api /
Filename : add_Homework.php
back
<?php
// Enable error reporting for debugging
error_reporting(E_ALL);
ini_set('display_errors', 1);

// Include database connection
include 'connection.php';

// Debugging: Check if the database connection is established
if (!$con) {
    die(json_encode(["status" => "0", "message" => "Database connection failed: " . mysqli_connect_error()]));
}

if ($_SERVER["REQUEST_METHOD"] === "POST") {
    

    // Retrieve values from POST request safely (avoid undefined index errors)
    $class_id = $_POST["class_id"] ?? null;
    $section_id = $_POST["section_id"] ?? null;
    $session_id = $_POST["session_id"] ?? null;
    $homework_date = $_POST["homework_date"] ?? null;
    $publish_date = $_POST["publish_date"] ?? null;
    $submit_date = $_POST["submit_date"] ?? null;
    $subject_group_subject_id = $_POST["subject_group_subject_id"] ?? null;
    $subject_id = $_POST["subject_id"] ?? null;
    $description = $_POST["description"] ?? null;
    $create_date = $_POST["create_date"] ?? null;
    $evaluation_date = $_POST["evaluation_date"] ?? null;
    $document = $_POST["document"] ?? null;
    $staff_id = $_POST["staff_id"] ?? null;
    $created_by = $_POST["created_by"] ?? null;

    // Debugging: Check if any required field is missing
    if (!$class_id || !$section_id || !$session_id || !$homework_date || !$submit_date || !$staff_id || !$subject_id || 
    // !$description || 
    !$create_date || !$evaluation_date || 
    // !$document || 
    !$created_by) {
        die(json_encode(["status" => "0", "message" => "Missing required fields"]));
    }

    // Debugging: Show prepared SQL query before execution
    $insertQuery = "INSERT INTO `homework` 
    (`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 
    ('$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')";

    // echo "<br>SQL Query: <br>" . $insertQuery . "<br>";

    // Execute query and debug result
    if ($con->query($insertQuery) === TRUE) {
        $response = ["status" => "1", "message" => "Data inserted successfully"];
    } else {
        $response = ["status" => "0", "message" => "Error inserting data: " . $con->error];
    }

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