File "delete_course_setting.php"

Full path: /home2/santhos2/public_html/bharath-coe.firstmatrix.in.net/api/internal_marks/delete_course_setting.php
File size: 1.46 KiB (1490 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back

<?php
require_once __DIR__ . '/../../config/config.php';
header('Content-Type: application/json');
ob_start();
try {
    $raw = file_get_contents('php://input');
    $data = json_decode($raw, true);
    $id = isset($data['id']) ? (int)$data['id'] : 0;
    
    if(!$id){ 
        echo json_encode(['status'=>'error','message'=>'Missing ID']); 
        exit; 
    }
    
    global $pdo;
    
    // Check if setting exists
    $checkStmt = $pdo->prepare("SELECT cas.setting_id, c.course_name 
                                FROM course_assessment_settings cas 
                                JOIN courses c ON c.course_id = cas.course_id 
                                WHERE cas.setting_id = ?");
    $checkStmt->execute([$id]);
    $setting = $checkStmt->fetch(PDO::FETCH_ASSOC);
    
    if(!$setting){ 
        echo json_encode(['status'=>'error','message'=>'Setting not found']); 
        exit; 
    }
    
    // Delete the setting
    $deleteStmt = $pdo->prepare("DELETE FROM course_assessment_settings WHERE setting_id = ?");
    $deleteStmt->execute([$id]);
    
    echo json_encode([
        'status'=>'success',
        'message'=>'Course settings for ' . $setting['course_name'] . ' deleted successfully'
    ]);
    
} catch (Throwable $e) {
    error_log('delete_course_setting error: '.$e->getMessage());
    http_response_code(500);
    echo json_encode(['status'=>'error','message'=>$e->getMessage()]);
}
ob_end_flush();
?>