1#@!#!123s

: / home3 / encodto1 / tresboutique.in / tresadmin /
Filename : edit_product.php
back
<?php
include 'config.php';

// Get the product ID from the URL
if (isset($_GET['product_id'])) {
    $product_id = intval($_GET['product_id']);

    // Fetch product details
    $query = "SELECT * FROM products WHERE product_id = $product_id";
    $result = mysqli_query($conn, $query);

    if (mysqli_num_rows($result) > 0) {
        $product = mysqli_fetch_assoc($result);
    } else {
        echo '<script>alert("Product not found."); window.location.href = "products.php";</script>';
        exit;
    }
} else {
    echo '<script>alert("Invalid request."); window.location.href = "products.php";</script>';
    exit;
}

// Fetch categories
$query = "SELECT product_category_id, product_category_name FROM product_category";
$categories = mysqli_query($conn, $query);

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $product_name = mysqli_real_escape_string($conn, $_POST['product_name']);
    $product_price = mysqli_real_escape_string($conn, $_POST['product_price']);
    $product_desc = mysqli_real_escape_string($conn, $_POST['product_desc']);
    $product_size = mysqli_real_escape_string($conn, $_POST['product_size']);
    $product_occassion = mysqli_real_escape_string($conn, $_POST['product_occassion']);
    $product_category = mysqli_real_escape_string($conn, $_POST['product_category']);
    $product_sku = mysqli_real_escape_string($conn, $_POST['product_sku']);
    $product_status = mysqli_real_escape_string($conn, $_POST['product_status']);

    $updated_at = date('Y-m-d H:i:s');

    // Handle image uploads
    $imageFields = ['product_img_1', 'product_img_2', 'product_img_3', 'product_img_4', 'product_img_5', 'product_img_6'];
    $uploadedImages = [];

    foreach ($imageFields as $field) {
        if (!empty($_FILES[$field]['name'])) {
            $targetDir = "uploads/products/";
            $fileName = basename($_FILES[$field]['name']);
            $targetFilePath = $targetDir . $fileName;

            if (move_uploaded_file($_FILES[$field]['tmp_name'], $targetFilePath)) {
                $uploadedImages[$field] = $fileName;
            } else {
                $uploadedImages[$field] = $product[$field]; // Retain existing image if upload fails
            }
        } else {
            $uploadedImages[$field] = $product[$field]; // Retain existing image if not updated
        }
    }

    // Update product in database
    $query = "UPDATE products SET 
                product_name = '$product_name',
                product_price = '$product_price',
                product_desc = '$product_desc',
                product_size = '$product_size',
                product_occassion = '$product_occassion',
                product_category = '$product_category',
                product_img_1 = '{$uploadedImages['product_img_1']}',
                product_img_2 = '{$uploadedImages['product_img_2']}',
                product_img_3 = '{$uploadedImages['product_img_3']}',
                product_img_4 = '{$uploadedImages['product_img_4']}',
                product_img_5 = '{$uploadedImages['product_img_5']}',
                product_img_6 = '{$uploadedImages['product_img_6']}',
                product_sku = '$product_sku',
                product_status = '$product_status'
              WHERE product_id = $product_id";

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

<!DOCTYPE html>
<html lang="en">

<head>
    <?php require('style.php'); ?>
</head>

<body>
    <div class="page-wrapper compact-wrapper" id="pageWrapper">
        <div class="page-body-wrapper">
            <?php require('sidebar.php'); ?>

            <div class="page-body">
                <div class="container-fluid">
                    <div class="page-title">
                        <h3>Edit Product</h3>
                    </div>
                    <div class="container">
                        <form method="POST" enctype="multipart/form-data">
                            <div class="row">
                                <div class="col-md-6">
                                    <div class="mb-3">
                                        <label for="product_name" class="form-label">Product Name</label>
                                        <input type="text" name="product_name" id="product_name" class="form-control" value="<?php echo $product['product_name']; ?>" required>
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_price" class="form-label">Product Price</label>
                                        <input type="number" name="product_price" id="product_price" class="form-control" value="<?php echo $product['product_price']; ?>" required>
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_desc" class="form-label">Product Description</label>
                                        <textarea name="product_desc" id="product_desc" class="form-control" required><?php echo $product['product_desc']; ?></textarea>
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_size" class="form-label">Product Size</label>
                                        <input type="text" name="product_size" id="product_size" class="form-control" value="<?php echo $product['product_size']; ?>">
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_occassion" class="form-label">Occasion</label>
                                        <select name="product_occassion" id="product_occassion" class="form-control">
                                            <option value="Wedding" <?php if ($product['product_occassion'] === 'Wedding') echo 'selected'; ?>>Wedding</option>
                                            <option value="Sangeet" <?php if ($product['product_occassion'] === 'Sangeet') echo 'selected'; ?>>Sangeet</option>
                                            <option value="Haldi" <?php if ($product['product_occassion'] === 'Haldi') echo 'selected'; ?>>Haldi</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="col-md-6">
                                    <div class="mb-3">
                                        <label>Product Category</label>
                                        <select class="form-control" name="product_category" required>
                                            <option value="">Select Category</option>
                                            <?php while ($category = mysqli_fetch_assoc($categories)) { ?>
                                                <option value="<?php echo $category['product_category_id']; ?>" <?php if ($product['product_category'] == $category['product_category_id']) echo 'selected'; ?>>
                                                    <?php echo $category['product_category_name']; ?>
                                                </option>
                                            <?php } ?>
                                        </select>
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_sku" class="form-label">SKU</label>
                                        <input type="text" name="product_sku" id="product_sku" class="form-control" value="<?php echo $product['product_sku']; ?>">
                                    </div>
                                    <div class="mb-3">
                                        <label for="product_status" class="form-label">Status</label>
                                        <select name="product_status" id="product_status" class="form-control">
                                            <option value="Active" <?php if ($product['product_status'] === 'Active') echo 'selected'; ?>>Active</option>
                                            <option value="Inactive" <?php if ($product['product_status'] === 'Inactive') echo 'selected'; ?>>Inactive</option>
                                        </select>
                                    </div>
                                    <?php for ($i = 1; $i <= 6; $i++): ?>
                                        <div class="mb-3">
                                            <label for="product_img_<?= $i ?>" class="form-label">Product Image <?= $i ?></label>
                                            <input type="file" name="product_img_<?= $i ?>" id="product_img_<?= $i ?>" class="form-control">
                                            <?php if (!empty($product['product_img_' . $i])): ?>
                                                <img src="uploads/products/<?= $product['product_img_' . $i] ?>" alt="Product Image <?= $i ?>" class="img-thumbnail mt-2" style="width: 100px; height: auto;">
                                            <?php endif; ?>
                                        </div>
                                    <?php endfor; ?>
                                </div>
                            </div>
                            <button type="submit" class="btn btn-primary">Update Product</button>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php require('footer.php'); ?>
</body>

</html>