SWAMPy

✎ CARVE FLESH

EDITING: create.php

<?php
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=UTF-8");
header("Access-Control-Allow-Methods: POST, OPTIONS");
header("Access-Control-Max-Age: 3600");
header("Access-Control-Allow-Headers: Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With");

// Handle preflight requests
if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') {
    http_response_code(200);
    exit();
}

include_once __DIR__ . '/../config/db.php';
include_once __DIR__ . '/../models/Category.php';

try {
    $database = new Database();
    $db = $database->getConnection();
    
    if (!$db) {
        http_response_code(500);
        echo json_encode([
            "success" => false,
            "message" => "Database connection failed."
        ]);
        exit;
    }
    
    $category = new Category($db);
    $data = json_decode(file_get_contents("php://input"));
    
    // Validate required fields
    if (!isset($data->name) || empty($data->name)) {
        http_response_code(400);
        echo json_encode([
            "success" => false,
            "message" => "Category name is required."
        ]);
        exit;
    }
    
    // Set category properties
    $category->name = trim($data->name);
    
    // Auto-generate slug from name
    $base_slug = strtolower(
        preg_replace('/[^A-Za-z0-9]+/', '-', $category->name)
    );
    $base_slug = trim($base_slug, '-');
    
    // Ensure base slug is not empty
    if (empty($base_slug)) {
        $base_slug = 'category-' . time();
    }
    
    // Check if slug already exists and make it unique
    $category->slug = $base_slug;
    $check_query = "SELECT COUNT(*) as count FROM categories WHERE slug = ?";
    $check_stmt = $db->prepare($check_query);
    $check_stmt->bindParam(1, $category->slug);
    $check_stmt->execute();
    $result = $check_stmt->fetch(PDO::FETCH_ASSOC);
    
    if ($result['count'] > 0) {
        // Slug exists, append timestamp to make unique
        $category->slug = $base_slug . '-' . time();
    }
    
    // Set optional fields
    $category->image = isset($data->image) && !empty($data->image) ? trim($data->image) : null;
    $category->sort_order = isset($data->sort_order) ? intval($data->sort_order) : 0;
    
    // Attempt to create category
    if ($category->create()) {
        // Get the last inserted ID
        $last_id = $db->lastInsertId();
        
        http_response_code(201);
        echo json_encode([
            "success" => true,
            "message" => "Category created successfully.",
            "id" => $last_id,
            "slug" => $category->slug,
            "image" => $category->image
        ]);
    } else {
        http_response_code(503);
        echo json_encode([
            "success" => false,
            "message" => "Unable to create category. Database error."
        ]);
    }
    
} catch (PDOException $e) {
    http_response_code(500);
    echo json_encode([
        "success" => false,
        "message" => "Database error occurred."
    ]);
} catch (Exception $e) {
    http_response_code(500);
    echo json_encode([
        "success" => false,
        "message" => "Error: " . $e->getMessage()
    ]);
}
?>

CANCEL

Name	Type	Size	Modified	Actions
↩ ..	DIR	—	—
📄 create.php	PHP	3.2 KB	2026-06-22 10:36	EDIT
📄 delete.php	PHP	852 B	2026-06-18 14:10	EDIT
📄 error_log	?	3.4 KB	2026-10-08 05:26	EDIT
📄 index.php	PHP	741 B	2026-06-18 15:25	EDIT
📄 update.php	PHP	2.8 KB	2026-06-22 10:36	EDIT
📄 upload_image.php	PHP	4.6 KB	2026-06-22 10:35	EDIT