1#@!#!123s

: / home / u193541357 / domains / racysanitaryware.com / public_html / dev / admin /
Filename : add-product copy.php
back
<?php include('header.php'); ?>
<?php

// Variables for storing product details
$id = '';
$category_id = '';
$product_name = '';
$product_codeno = '';
$product_description = '';
$product_image = '';
$product_drawing = '';
$product_extra_description = '';

// Check if updating an existing product
if (isset($_GET['id'])) {
    $id = $_GET['id'];
    $sql = "SELECT * FROM products WHERE id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param('i', $id);
    $stmt->execute();
    $result = $stmt->get_result();

    if ($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        $category_id = $row['category_id'];
        $product_name = $row['product_name'];
        $product_codeno = $row['product_codeno'];
        $product_description = $row['product_description'];
        $product_image = $row['product_image'];
        $product_drawing = $row['product_drawing'];
        $product_extra_description = $row['product_extra_description'];
    }
}

// Fetch categories for dropdown
$categories = [];
$cat_sql = "SELECT id, category_name FROM categories";
$cat_result = $conn->query($cat_sql);
while ($cat_row = $cat_result->fetch_assoc()) {
    $categories[] = $cat_row;
}
?>

<div class="container-fluid">
    <div class="d-sm-flex align-items-center justify-content-between mb-4">
        <h1 class="h3 mb-0 text-gray-800"><?php echo isset($id) ? 'Update Product' : 'Add Product'; ?></h1>
    </div>

    <div class="card shadow mb-4">
        <div class="card-body">
            <form class="user" id="product-form" method="post" action="submit-product.php" enctype="multipart/form-data">
                <input type="hidden" name="id" value="<?php echo $id; ?>"> <!-- Hidden ID for update -->

                <div class="form-group row">
                    <!-- Category Dropdown -->
                    <div class="col-sm-4 mb-3">
                        <label for="category_id">Category</label>
                        <select class="form-control form-select" name="category_id" required>
                            <option value="">Select Category</option>
                            <?php foreach ($categories as $cat) : ?>
                                <option value="<?php echo $cat['id']; ?>" <?php echo $category_id == $cat['id'] ? 'selected' : ''; ?>>
                                    <?php echo $cat['category_name']; ?>
                                </option>
                            <?php endforeach; ?>
                        </select>
                    </div>

                    <div class="col-sm-4 mb-3">
                        <label for="product_name">Product Name</label>
                        <input type="text" class="form-control form-control-user" id="product_name" placeholder="Enter Product Name" name="product_name" value="<?php echo $product_name; ?>" required>
                    </div>
                    <div class="col-sm-4 mb-3">
                        <label for="product_codeno">Product Code Number</label>
                        <input type="text" class="form-control form-control-user" id="product_codeno" placeholder="Enter Product Code" name="product_codeno" value="<?php echo $product_codeno; ?>" required>
                    </div>

                    <!-- Product Description -->
                    <div class="col-sm-12 mb-3">
                        <label for="product_description">Product Description</label>
                        <textarea cols="10" rows="5" class="form-control form-control-textarea" id="product_description" name="product_description" required><?php echo $product_description; ?></textarea>
                    </div>

                    <!-- Product Image -->
                    <div class="col-sm-6 mb-3">
                        <label for="product_image">Product Image</label>
                        <input type="file" class="form-control form-control-user form-control-file" id="product_image" name="product_image" accept="image/*" onchange="previewImage(event, 'productImagePreview')">
                        <div class="position-relative mt-2 preview" id="productImagePreview">
                            <?php if (!empty($product_image)) : ?>
                                <img src="<?php echo $product_image; ?>" alt="Product Image" style="max-width: 120px; margin-top:10px;">
                            <?php else : ?>
                                <img src="" alt="" style="max-width: 120px; margin-top:10px; display: none;">
                            <?php endif; ?>
                        </div>
                    </div>

                    <!-- Product Drawing -->
                    <div class="col-sm-6 mb-3">
                        <label for="product_drawing">Product Drawing</label>
                        <input type="file" class="form-control form-control-user form-control-file" id="product_drawing" name="product_drawing" accept="image/*" onchange="previewImage(event, 'productDrawingPreview')">
                        <div class="position-relative mt-2 preview" id="productDrawingPreview">
                            <?php if (!empty($product_drawing)) : ?>
                                <img src="<?php echo $product_drawing; ?>" alt="Product Drawing" style="max-width: 120px; margin-top:10px;">
                            <?php else : ?>
                                <img src="" alt="" style="max-width: 120px; margin-top:10px; display: none;">
                            <?php endif; ?>
                        </div>
                    </div>

                    <!-- Extra Description -->
                    <div class="col-sm-12 mb-3">
                        <label for="product_extra_description">Extra Description</label>
                        <textarea cols="10" rows="5" class="form-control form-control-textarea" id="product_extra_description" name="product_extra_description"><?php echo $product_extra_description; ?></textarea>
                    </div>
                </div>

                <button type="submit" class="btn btn-primary btn-user btn-block">
                    <?php echo (!isset($id) || empty($id)) ? 'Add Product' : 'Update Product'; ?>
                </button>
            </form>
        </div>
    </div>
</div>

<!-- Script for image preview -->
<script>
    // Image Preview Functionality
    function previewImage(event, previewId) {
        const reader = new FileReader();
        reader.onload = function() {
            const previewImg = document.getElementById(previewId).querySelector('img');
            previewImg.src = reader.result;
            previewImg.style.display = 'block'; // Make the preview image visible
        };
        if (event.target.files && event.target.files[0]) {
            reader.readAsDataURL(event.target.files[0]);
        }
    }
</script>

<?php include('footer.php'); ?>