1#@!#!123s

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

// Set the content type to JSON
header('Content-Type: application/json');

if($_SERVER["REQUEST_METHOD"]=== "DELETE"){
    $id= $_GET["id"];
    
     if (isset($_GET['id'])) {
        $id = $_GET['id'];
    
    // Query to delete the homework 
    if(filter_var($id, FILTER_VALIDATE_INT) !== false){
        $query= "DELETE FROM homework WHERE id= ?";
        $stmt= $con->prepare($query);
        
         if ($stmt === false) { // Check if prepare() failed
                $response = array('status' => 'error', 'message' => 'Error preparing statement: ' . $con->error);
                http_response_code(500);
                echo json_encode($response);
                exit; // Stop execution
            }
        
        $stmt->bind_param("i", $id);
        
            if ($stmt->errno) { // Check for errors after bind_param()
                $response = array('status' => 'error', 'message' => 'Error binding parameter: ' . $stmt->error);
                http_response_code(500);
                echo json_encode($response);
                exit;
            }
        
        // Execute the query
        
          if ($stmt->execute()) {
                // Check if any rows were affected
                if ($stmt->affected_rows > 0) {
                    // Deletion successful
                    $response = array('status' => 'success', 'message' => 'Homework deleted successfully');
                    http_response_code(200); // OK
                } else {
                    // Homework not found
                    $response = array('status' => 'error', 'message' => 'Homework not found');
                    http_response_code(404); // Not Found
                }
            } else {
                // Error executing the query
                $response = array('status' => 'error', 'message' => 'Error deleting homework: ' . $stmt->error);
                http_response_code(500); // Internal Server Error
            }

            // Close the statement
            $stmt->close();
    
        
    }else {
            // Invalid id
            $response =array('status' => 'error', 'message' => 'Invalid homework ID');
            http_response_code(400); // Bad Request
        }
        
     }else{
          // id parameter is missing
        $response = array('status' => 'error', 'message' => 'Homework ID is required');
        http_response_code(400); // Bad Request
     }
}else {
    // Invalid request method
    $response = array('status' => 'error', 'message' => 'Invalid request method');
    http_response_code(405); // Method Not Allowed
}

$con->close();

// Send the JSON response
echo json_encode($response);


?>