File "create.php"

Full path: /home2/santhos2/public_html/bharath-coe.firstmatrix.in.net/api/categories/create.php
File size: 2.23 KiB (2283 bytes)
MIME-type: text/x-php
Charset: utf-8

Download   Open   Back

<?php
// Suppress all error output to ensure clean JSON responses
error_reporting(0);
ini_set('display_errors', 0);
ob_start();

require_once '../../config/config.php';
require_once '../helper/audit_log.php';

// Clean any output buffer and set proper headers
ob_clean();
header('Content-Type: application/json');

try {
    $name = trim($_POST['category_name'] ?? '');
    $desc = trim($_POST['description'] ?? '');

    // Validation
    $errors = [];
    if ($name === '') { 
        $errors[] = 'Category name is required.'; 
    }
    if (mb_strlen($name) < 2) { 
        $errors[] = 'Category name must be at least 2 characters.'; 
    }
    if (mb_strlen($name) > 100) { 
        $errors[] = 'Category name must not exceed 100 characters.'; 
    }
    
    if ($errors) { 
        echo json_encode(["status" => "error", "message" => implode(' ', $errors)]); 
        exit; 
    }

    // Check for duplicate category name
    $check_stmt = $pdo->prepare("SELECT category_id FROM categories WHERE category_name = ?");
    $check_stmt->execute([$name]);
    if ($check_stmt->fetch()) {
        echo json_encode(["status" => "error", "message" => "Category name already exists. Please use a different name."]);
        exit;
    }

    // Insert new category
    $stmt = $pdo->prepare("INSERT INTO categories (category_name, description) VALUES (?, ?)");
    $stmt->execute([$name, $desc]);
    
    $new_id = $pdo->lastInsertId();
    
    // Write audit log
    write_audit_log($pdo, [
        'module' => 'Academic Structure',
        'action' => 'create',
        'entity_table' => 'categories',
        'entity_id' => $new_id,
        'after_data' => [
            'category_name' => $name,
            'description' => $desc
        ],
        'message' => 'Category created successfully'
    ]);
    
    echo json_encode([
        "status" => "success",
        "message" => "Category created successfully.",
        "data" => [
            "category_id" => $new_id,
            "category_name" => $name,
            "description" => $desc
        ]
    ]);
    
} catch (Throwable $e) {
    http_response_code(500);
    echo json_encode([
        "status" => "error",
        "message" => "An error occurred while creating the category. Please try again."
    ]);
}
?>

PHP File Manager