1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / jeffautomobileinc.com / admin /
Filename : edit-category.php
back
<?php
session_start();
error_reporting(0);
include('../../config/jaconfig.php');
include('include/checklogin.php');
check_login();
$title = "Edit Category";
$currentTime = date('Y-m-d H:i:s');

if (isset($_POST['submit'])) {
    $title = mysqli_real_escape_string($con, $_POST['category']);
    $id = intval($_GET['id']);
    $msg = "";
    $type = "";

    // Check if a new image is uploaded
    if (!empty($_FILES['image']['name'])) {
        $image = $_FILES['image']['name'];
        $imageExtension = pathinfo($image, PATHINFO_EXTENSION);
        $newImageName = uniqid("cat_", true) . "." . $imageExtension;

        // Define the upload directory
        $uploadDir = "categories/";
        if (!is_dir($uploadDir)) {
            mkdir($uploadDir, 0777, true);
        }
        $uploadPath = $uploadDir . $newImageName;

        // Move the uploaded file to the destination
        if (move_uploaded_file($_FILES['image']['tmp_name'], $uploadPath)) {
            // Update category with image
            $sql = mysqli_query($con, "UPDATE categories SET cat_title='$title', image='$newImageName', updationDate='$currentTime' WHERE cat_id='$id'");
            if ($sql) {
                $type = "success";
                $msg = "Category and Image Updated Successfully!";
            } else {
                $type = "warning";
                $msg = "Failed to update category. Please try again.";
            }
        } else {
            $type = "warning";
            $msg = "Failed to upload image. Please try again.";
        }
    } else {
        // Update only the category title
        $sql = mysqli_query($con, "UPDATE categories SET cat_title='$title', updationDate='$currentTime' WHERE cat_id='$id'");
        if ($sql) {
            $type = "success";
            $msg = "Category Updated Successfully!";
        } else {
            $type = "warning";
            $msg = "Failed to update category. Please try again.";
        }
    }
}
?>

<?php include('include/header.php'); ?>
<?php include('include/sidebar.php'); ?>

<div class="container-fluid py-4">
    <div class="row">
        <div class="col-12">
            <div class="card mb-4">
                <div class="card-header pb-0">
                    <h6>Edit Category</h6>
                </div>
                <div class="card-body">
                    <div class="table-responsive p-0">
                    <?php if(isset($msg)){ ?>
                    <div class="alert alert-<?php echo $type?>">
                          <h6 class="alert-heading fw-bold mb-1"><?php echo $type?></h6>
                          <p class="mb-0"><?php echo $msg?></p>
                        </div>
                        <?php }?>
                        
                        <?php
                        $id = intval($_GET['id']);
                        $query = mysqli_query($con, "SELECT * FROM categories WHERE cat_id='$id'");
                        while ($data = mysqli_fetch_array($query)) {
                        ?>

                        <div class="form-group text-box">
                            <h4><?php echo htmlentities($data['cat_title']); ?>'s Details</h4>
                            <p><b>Category Creation Date:</b> <?php echo htmlentities($data['creationDate']); ?></p>
                            <?php if ($data['updationDate']) { ?>
                            <p><b>Category's Last Update:</b> <?php echo htmlentities($data['updationDate']); ?></p>
                            <?php } ?>
                            <hr />
                            <form role="form" method="post" action="" enctype="multipart/form-data">

                                <div class="form-group">
                                    <label for="category">Category Name</label>
                                    <input type="text" name="category" class="form-control" value="<?php echo htmlentities($data['cat_title']); ?>" required>
                                </div>

                                <div class="form-group mb-3">
                                    <label for="image">Category Image</label>
                                    <?php if (!empty($data['image'])) { ?>
                                        <img src="categories/<?php echo htmlentities($data['image']); ?>" alt="Category Image" style="width: 150px; height: 150px; display: block; margin-bottom: 10px;">
                                    <?php } ?>
                                    <input type="file" name="image" class="form-control" accept="image/*">
                                    <small class="text-muted">Leave blank if you don't want to change the image.</small>
                                </div>

                                <button type="submit" name="submit" class="btn btn-o btn-primary">
                                    Update
                                </button>
                            </form>
                        </div>

                        <?php } ?>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

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