1#@!#!123s

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

<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($_GET['id']) ? 'Update Category' : 'Add Category'; ?></h1>
    </div>

    <div class="card shadow mb-4">
        <div class="card-body">
            <div class="p-2">
                <div class="row">
                    <div class="col-lg-12 col-md-12 col-12">
                        <?php

                        $id = '';
                        $category_name = '';
                        $category_description = '';
                        $category_image = 'img/logo.png'; // Default image
                        $banner_image = 'img/logo.png';   // Default banner image

                        // If editing, populate form fields
                        if (isset($_GET['id'])) {
                            $id = $_GET['id'];
                            $sql = "SELECT * FROM categories 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_name = $row['category_name'];
                                $category_description = $row['category_description'];
                                $category_image = $row['category_image'] ? $row['category_image'] : 'img/placeholder.png';
                                $banner_image = $row['banner_image'] ? $row['banner_image'] : 'img/placeholder.png';
                            }

                            $stmt->close();
                        }
                        ?>

                        <form class="user" id="category-form" method="post" action="submit_category.php" enctype="multipart/form-data">
                            <input type="hidden" name="id" value="<?php echo $id; ?>"> <!-- Hidden ID for update -->
                            <div class="form-group row">
                                <div class="col-sm-12 mb-3">
                                    <label for="categoryName">Category Name</label>
                                    <input type="text" class="form-control form-control-user" id="categoryName" placeholder="Enter Category Name" name="category_name" value="<?php echo $category_name; ?>" required>
                                </div>
                                <div class="col-sm-12 mb-3">
                                    <label for="categoryDescription">Category Description</label>
                                    <textarea class="form-control" id="categoryDescription" placeholder="Enter Category Description" name="category_description" rows="4"><?php echo $category_description; ?></textarea>
                                </div>
                                <div class="col-sm-12 mb-3">
                                    <label for="categoryImage">Category Image (One Image Only)</label>
                                    <input type="file" class="form-control form-control-user form-control-file" id="categoryImage" name="category_image" accept="image/*" onchange="previewImage(event, 'categoryPreview')">
                                    <div class="position-relative mt-2 preview" id="categoryPreview">
                                        <img src="<?php echo $category_image; ?>" alt="" id="previewImg1" style="max-width: 100px; margin-top:10px;">
                                    </div>
                                </div>
                                <div class="col-sm-12 mb-3">
                                    <label for="bannerImage">Banner Image (One Image Only)</label>
                                    <input type="file" class="form-control form-control-user form-control-file" id="bannerImage" name="banner_image" accept="image/*" onchange="previewImage(event, 'bannerPreview')">
                                    <div class="position-relative mt-2 preview" id="bannerPreview">
                                        <img src="<?php echo $banner_image; ?>" alt="" id="previewImg2" style="max-width: 100px; margin-top:10px;">
                                    </div>
                                </div>
                            </div>
                            <button type="submit" class="btn btn-primary btn-user btn-block">
                                <?php echo isset($_GET['id']) ? 'Update Category' : 'Add Category'; ?>
                            </button>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<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;
        };
        reader.readAsDataURL(event.target.files[0]);
    }
</script>

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