1#@!#!123s

: / home3 / encodto1 / siliguritoys.com / slgadmintoys /
Filename : edit_product.php
back
<?php
include 'config.php';

if (!isset($_GET['id'])) {
    echo "<script>alert('No product selected!'); window.location.href='product_list.php';</script>";
    exit;
}

$id = mysqli_real_escape_string($conn, $_GET['id']);

// Fetch product details
$query = "SELECT * FROM slgtoys_products WHERE id = '$id'";
$result = mysqli_query($conn, $query);
$product = mysqli_fetch_assoc($result);

if (!$product) {
    echo "<script>alert('Product not found!'); window.location.href='product_list.php';</script>";
    exit;
}

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $name = mysqli_real_escape_string($conn, $_POST['name']);
    $age_category = mysqli_real_escape_string($conn, $_POST['age_category']);
    $size = mysqli_real_escape_string($conn, $_POST['size']);
    $weight = mysqli_real_escape_string($conn, $_POST['weight']);
    $material = mysqli_real_escape_string($conn, $_POST['material']);
    $category_id = mysqli_real_escape_string($conn, $_POST['category_id']);
    $price = mysqli_real_escape_string($conn, $_POST['price']);
    $colors = isset($_POST['colors']) ? implode(',', $_POST['colors']) : '';
    $stock_quantity = mysqli_real_escape_string($conn, $_POST['stock_quantity']);
    $description = mysqli_real_escape_string($conn, $_POST['description']);

    $uploadDir = "uploads/";
    $imagePaths = [
        $product['image_1'],
        $product['image_2'],
        $product['image_3'],
        $product['image_4'],
        $product['image_5']
    ];

    for ($i = 0; $i < 5; $i++) {
        $inputName = "image_" . ($i + 1);
        if (isset($_FILES[$inputName]) && $_FILES[$inputName]['error'] == 0) {
            $fileName = time() . "_" . basename($_FILES[$inputName]['name']);
            $targetFilePath = $uploadDir . $fileName;
            if (move_uploaded_file($_FILES[$inputName]['tmp_name'], $targetFilePath)) {
                $imagePaths[$i] = $targetFilePath;
            }
        }
    }

    // Update query
    $sql = "UPDATE slgtoys_products SET 
                name = '$name', 
                age_category = '$age_category', 
                size = '$size', 
                weight = '$weight', 
                material = '$material', 
                category_id = '$category_id', 
                price = '$price', 
                color = '$colors', 
                stock_quantity = '$stock_quantity', 
                description = '$description', 
                image_1 = '{$imagePaths[0]}', 
                image_2 = '{$imagePaths[1]}', 
                image_3 = '{$imagePaths[2]}', 
                image_4 = '{$imagePaths[3]}', 
                image_5 = '{$imagePaths[4]}' 
            WHERE id = '$id'";

    if (mysqli_query($conn, $sql)) {
        echo "<script>alert('Product updated successfully!'); window.location.href='product_list.php';</script>";
    } else {
        echo "Error updating product: " . mysqli_error($conn);
    }
}
?>

<!DOCTYPE html>
<html lang="en" data-theme="light">

<head>
    <?php include 'style.php'; ?>
</head>

<body>
    <?php include 'sidebar.php'; ?>
    <main class="dashboard-main">
        <?php include 'header.php'; ?>
        <div class="dashboard-main-body">
            <h6 class="fw-semibold mb-0">Edit Product</h6>
            <form action="" method="POST" enctype="multipart/form-data">
                <div class="row gy-3">
                    <div class="col-12">
                        <label class="form-label">Name</label>
                        <input type="text" name="name" class="form-control" value="<?= $product['name'] ?>" required>
                    </div>

                    <div class="col-12">
                        <label class="form-label">Select Age</label>
                        <select class="form-select" name="age_category" required>
                            <option value="8-9" <?= $product['age_category'] == '8-9' ? 'selected' : '' ?>>8 - 9</option>
                            <option value="10-11" <?= $product['age_category'] == '10-11' ? 'selected' : '' ?>>10 - 11</option>
                            <option value="12-13" <?= $product['age_category'] == '12-13' ? 'selected' : '' ?>>12 - 13</option>
                        </select>
                    </div>
                    <div class="col-12">
                        <label class="form-label">Product Size</label>
                        <input type="text" name="size" class="form-control" value="<?= $product['size'] ?>" required>
                    </div>
                    <div class="col-12">
                        <label class="form-label">Weight</label>
                        <input type="text" name="weight" class="form-control" value="<?= $product['weight'] ?>" required>
                    </div>
                    <div class="col-12">
                        <label class="form-label">Material</label>
                        <input type="text" name="material" class="form-control" value="<?= $product['material'] ?>" required>
                    </div>
                    <div class="col-12">
                        <label class="form-label">Select Category</label>
                        <select class="form-select" name="category_id" required>
                            <?php
                            $query = "SELECT category_id, category_name FROM product_category WHERE category_status = 'Active'";
                            $result = mysqli_query($conn, $query);
                            while ($row = mysqli_fetch_assoc($result)) {
                                $selected = $product['category_id'] == $row['category_id'] ? 'selected' : '';
                                echo "<option value='{$row['category_id']}' $selected>{$row['category_name']}</option>";
                            }
                            ?>
                        </select>
                    </div>

                    <div class="col-12">
                        <label class="form-label">Select Images (Leave empty to keep existing images)</label>
                        <?php for ($i = 1; $i <= 5; $i++) { ?>
                            <input class="form-control mb-3" type="file" name="image_<?php echo $i; ?>">
                            <?php if (!empty($product["image_$i"])) { ?>
                                <img src="<?= $product["image_$i"] ?>" alt="Product Image" width="50">
                            <?php } ?>
                        <?php } ?>
                    </div>

                    <div class="col-12">
                        <label class="form-label">Stock Quantity</label>
                        <input type="number" name="stock_quantity" class="form-control" value="<?= $product['stock_quantity'] ?>" required>
                    </div>
                    <div class="col-12">
                        <label class="form-label">Price</label>
                        <input type="text" name="price" class="form-control" value="<?= $product['price'] ?>" required>
                    </div>
                    <div class="col-12">
                        <label class="form-label">Description</label>
                        <textarea name="description" class="form-control" rows="4" required><?= $product['description'] ?></textarea>
                    </div>
                    <div class="col-12">
                        <button type="submit" class="btn btn-primary w-100">Update Product</button>
                    </div>
                </div>
            </form>
        </div>
        <?php include 'Footer.php'; ?>
    </main>
</body>

</html>

<?php mysqli_close($conn); ?>