File Manager

Editing:product_add.php

<?php
require_once __DIR__ . '/admin_header.php';

$error = '';
$success = '';
$categories = [];

// Fetch categories for dropdown
try {
    $stmt_cats = $pdo->query("SELECT id, name FROM categories ORDER BY name ASC");
    $categories = $stmt_cats->fetchAll();
} catch (Exception $e) {
    $error = 'Failed to load categories: ' . $e->getMessage();
}

// Fetch active colors and sizes for checkboxes
$colors = [];
$sizes = [];
try {
    $colors = $pdo->query("SELECT * FROM colors ORDER BY name ASC")->fetchAll();
    $sizes = $pdo->query("SELECT * FROM sizes ORDER BY id ASC")->fetchAll();
} catch (Exception $e) {
    $error = 'Failed to load custom attributes: ' . $e->getMessage();
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $name = isset($_POST['name']) ? trim($_POST['name']) : '';
    $description = isset($_POST['description']) ? trim($_POST['description']) : '';
    $price = isset($_POST['price']) ? floatval($_POST['price']) : 0.00;
    $category_id = isset($_POST['category_id']) ? intval($_POST['category_id']) : 0;
    $stock = isset($_POST['stock']) ? intval($_POST['stock']) : 0;
    $is_featured = isset($_POST['is_featured']) ? 1 : 0;
    $selected_colors = isset($_POST['colors']) ? $_POST['colors'] : [];
    $selected_sizes = isset($_POST['sizes']) ? $_POST['sizes'] : [];

if (empty($name) || empty($description) || $price <= 0 || $category_id <= 0) {
        $error = 'Please fill out all required fields: Name, Description, Category, and a valid Price.';
    } else {
        try {
            $image_filename = '';

// Handle Image Upload (Required for new product)
            if (isset($_FILES['image']) && $_FILES['image']['error'] === UPLOAD_ERR_OK) {
                $file_tmp = $_FILES['image']['tmp_name'];
                $file_name = $_FILES['image']['name'];
                $file_size = $_FILES['image']['size'];
                $file_ext = strtolower(pathinfo($file_name, PATHINFO_EXTENSION));
                
                $allowed_exts = ['png', 'jpg', 'jpeg', 'webp'];
                
                if (!in_array($file_ext, $allowed_exts)) {
                    $error = 'Invalid image type. Only PNG, JPG, JPEG, and WEBP formats are accepted.';
                } elseif ($file_size > 5 * 1024 * 1024) {
                    $error = 'Image file size is too large. Keep uploads under 5 megabytes.';
                } else {
                    // Create unique target filename
                    $image_filename = 'prod_' . time() . '_' . uniqid() . '.' . $file_ext;
                    $upload_dir = __DIR__ . '/../assets/images/';
                    
                    if (!is_dir($upload_dir)) {
                        mkdir($upload_dir, 0755, true);
                    }

if (!move_uploaded_file($file_tmp, $upload_dir . $image_filename)) {
                        $error = 'Failed to save product image to local storage.';
                        $image_filename = '';
                    }
                }
            } else {
                $error = 'A product showcase image upload is required.';
            }

if (empty($error)) {
                $pdo->beginTransaction();

// Insert product into database
                $stmt_insert = $pdo->prepare("INSERT INTO products (name, description, price, category_id, image, stock, is_featured) VALUES (?, ?, ?, ?, ?, ?, ?)");
                $stmt_insert->execute([$name, $description, $price, $category_id, $image_filename, $stock, $is_featured]);
                $product_id = $pdo->lastInsertId();

// Save selected colors
                if (!empty($selected_colors)) {
                    $stmt_prod_color = $pdo->prepare("INSERT INTO product_colors (product_id, color_id) VALUES (?, ?)");
                    foreach ($selected_colors as $cid) {
                        $stmt_prod_color->execute([$product_id, intval($cid)]);
                    }
                }

// Save selected sizes
                if (!empty($selected_sizes)) {
                    $stmt_prod_size = $pdo->prepare("INSERT INTO product_sizes (product_id, size_id) VALUES (?, ?)");
                    foreach ($selected_sizes as $sid) {
                        $stmt_prod_size->execute([$product_id, intval($sid)]);
                    }
                }

$pdo->commit();
                
                $success = 'Product introduced successfully! Redirecting back...';
                echo "<script>setTimeout(() => { window.location.href = 'products.php'; }, 1500);</script>";
            }
        } catch (Exception $e) {
            if ($pdo->inTransaction()) {
                $pdo->rollBack();
            }
            $error = 'Database transaction failed: ' . $e->getMessage();
        }
    }
}
?>

<div class="row mb-4">
    <div class="col-12">
        <nav aria-label="breadcrumb">
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                <li class="breadcrumb-item"><a href="products.php">Products</a></li>
                <li class="breadcrumb-item active" aria-current="page">Add Product</li>
            </ol>
        </nav>
        <h2 class="text-white">Introduce Couture Product</h2>
        <p class="text-muted small">Design and list a new masterpiece for the catalog collection.</p>
    </div>
</div>

<?php if (!empty($success)): ?>
                <div class="alert alert-success border-success bg-dark text-success rounded-3 py-2 px-3 small mb-4" role="alert">
                    <i class="fa-solid fa-circle-check me-2"></i> <?php echo htmlspecialchars($success); ?>
                </div>
            <?php endif; ?>

<form action="product_add.php" method="POST" enctype="multipart/form-data">
                <div class="row g-4">
                    
                    <div class="col-md-8">
                        <label for="name" class="form-label text-muted small text-uppercase fw-bold">Product Name *</label>
                        <input type="text" class="form-control" id="name" name="name" required placeholder="e.g. Classic Trench Coat">
                    </div>

<div class="col-md-4">
                        <label for="category_id" class="form-label text-muted small text-uppercase fw-bold">Category Classification *</label>
                        <select class="form-select" id="category_id" name="category_id" required>
                            <option value="" disabled selected>Select Category</option>
                            <?php foreach ($categories as $cat): ?>
                                <option value="<?php echo $cat['id']; ?>"><?php echo htmlspecialchars($cat['name']); ?></option>
                            <?php endforeach; ?>
                        </select>
                    </div>

<div class="col-md-4">
                        <label for="price" class="form-label text-muted small text-uppercase fw-bold">Boutique Price (LKR) *</label>
                        <div class="input-group">
                            <span class="input-group-text bg-dark border-secondary text-warning fw-bold">LKR</span>
                            <input type="number" class="form-control" id="price" name="price" step="0.01" min="0" required placeholder="4250.00">
                        </div>
                    </div>

<div class="col-md-4">
                        <label for="stock" class="form-label text-muted small text-uppercase fw-bold">Inventory Stock Level</label>
                        <input type="number" class="form-control" id="stock" name="stock" min="0" value="10" required placeholder="10">
                    </div>

<div class="col-md-4 d-flex align-items-center">
                        <div class="form-check form-switch mt-3 mt-md-4">
                            <input class="form-check-input bg-dark border-secondary" type="checkbox" id="is_featured" name="is_featured" value="1">
                            <label class="form-check-input-label text-white ms-2" for="is_featured" style="cursor: pointer;">
                                <i class="fa-solid fa-star text-warning me-1"></i> Spotlight on Homepage
                            </label>
                        </div>
                    </div>

<div class="col-12">
                        <label for="description" class="form-label text-muted small text-uppercase fw-bold">Description Details *</label>
                        <textarea class="form-control" id="description" name="description" rows="5" required placeholder="Describe the fabrics, silhouette details, sizing guides, couture qualities, and unique characteristics of this masterpiece..."></textarea>
                    </div>

<div class="col-md-6">
                        <label class="form-label text-muted small text-uppercase fw-bold d-block mb-3">Available Couture Colors</label>
                        <div class="d-flex flex-wrap gap-3 p-3 rounded bg-dark border border-secondary" style="min-height: 100px;">
                            <?php if (empty($colors)): ?>
                                <span class="text-white small">No colors defined. Add them in <a href="colors.php" class="text-warning">Colors Settings</a>.</span>
                            <?php else: ?>
                                <?php foreach ($colors as $c): ?>
                                    <div class="form-check d-flex align-items-center gap-2">
                                        <input class="form-check-input bg-dark border-secondary" type="checkbox" name="colors[]" value="<?php echo $c['id']; ?>" id="color-<?php echo $c['id']; ?>" checked>
                                        <label class="form-check-label text-white d-flex align-items-center gap-2" for="color-<?php echo $c['id']; ?>" style="cursor: pointer;">
                                            <span class="rounded-circle d-inline-block" style="width: 18px; height: 18px; background-color: <?php echo $c['hex']; ?>; border: 1px solid <?php echo $c['border']; ?>;"></span>
                                            <span class="small"><?php echo htmlspecialchars($c['name']); ?></span>
                                        </label>
                                    </div>
                                <?php endforeach; ?>
                            <?php endif; ?>
                        </div>
                    </div>

<div class="col-md-6">
                        <label class="form-label text-muted small text-uppercase fw-bold d-block mb-3">Available Couture Sizes</label>
                        <div class="d-flex flex-wrap gap-3 p-3 rounded bg-dark border border-secondary" style="min-height: 100px;">
                            <?php if (empty($sizes)): ?>
                                <span class="text-white small">No sizes defined. Add them in <a href="sizes.php" class="text-warning">Sizes Settings</a>.</span>
                            <?php else: ?>
                                <?php foreach ($sizes as $s): ?>
                                    <div class="form-check d-flex align-items-center gap-2">
                                        <input class="form-check-input bg-dark border-secondary" type="checkbox" name="sizes[]" value="<?php echo $s['id']; ?>" id="size-<?php echo $s['id']; ?>" checked>
                                        <label class="form-check-label text-white fw-bold small" for="size-<?php echo $s['id']; ?>" style="cursor: pointer;">
                                            <?php echo htmlspecialchars($s['name']); ?>
                                        </label>
                                    </div>
                                <?php endforeach; ?>
                            <?php endif; ?>
                        </div>
                    </div>

<div class="col-12">
                        <label for="image" class="form-label text-muted small text-uppercase fw-bold">Product Showcase Image *</label>
                        <input type="file" class="form-control" id="image" name="image" accept="image/*" required onchange="previewFile()">
                        <div class="form-text text-muted" style="font-size: 0.7rem;">Select a stunning portrait capture. PNG, JPG, JPEG, WEBP. Max 5MB.</div>
                        
                        
                        <div id="preview-container" class="mt-3 d-none">
                            <span class="d-block text-muted small mb-2 text-uppercase fw-bold" style="font-size: 0.65rem;">Image Asset Preview:</span>
                            <img id="image-preview" src="#" alt="Preview" class="rounded" style="max-width: 150px; height: 180px; object-fit: cover; border: 1px solid var(--border-gray);">
                        </div>
                    </div>

<div class="col-12 mt-5 border-top border-dark pt-4 d-flex gap-3 justify-content-end">
                        <a href="products.php" class="btn btn-outline-secondary rounded-pill px-4 py-2 text-uppercase tracking-wider fw-bold" style="font-size: 0.75rem; border-color: var(--border-gray);">
                            Cancel
                        </a>
                        <button type="submit" class="btn-luxury px-4 py-2">
                            Save Product Masterpiece <i class="fa-solid fa-cloud-arrow-up ms-2"></i>
                        </button>
                    </div>
                </div>
            </form>
        </div>
    </div>
</div>

reader.addEventListener("load", function () {
        preview.src = reader.result;
        container.classList.remove('d-none');
    }, false);

if (file) {
        reader.readAsDataURL(file);
    }
}
</script>

<?php
require_once __DIR__ . '/admin_footer.php';
?>

Cancel

🤩 File Manager - Mr.X

Editing:product_add.php