D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
newpcjewellers.in
/
newadminpc
/
Filename :
edit_category.php
back
Copy
<?php session_start(); include 'config.php'; if (!isset($_SESSION['admin_name'])) { echo '<script>window.location.href = "login.php";</script>'; exit; } // Initialize $item with default values $item = [ 'category_name' => '', 'image' => '', 'status' => '1' // Default to active ]; $editMode = false; // Check if an ID is provided for editing if (isset($_GET['id'])) { $id = intval($_GET['id']); $query = "SELECT * FROM `product_category` WHERE `id`=$id"; $result = mysqli_query($conn, $query); if ($result && mysqli_num_rows($result) > 0) { $item = mysqli_fetch_assoc($result); $editMode = true; } } if ($_SERVER['REQUEST_METHOD'] === 'POST') { $categoryName = mysqli_real_escape_string($conn, $_POST['category_name']); $status = intval($_POST['status']); // Get status from POST data $image = $_FILES['image']['name']; $imageTempName = $_FILES['image']['tmp_name']; $imagePath = "uploads/" . basename($image); if ($editMode) { // Update existing category $query = "UPDATE `product_category` SET `category_name`='$categoryName', `status`='$status'"; if (!empty($image)) { // Update image if new image is uploaded move_uploaded_file($imageTempName, $imagePath); $query .= ", `image`='$image'"; } $query .= " WHERE `id`=$id"; mysqli_query($conn, $query); echo '<script>alert("Category updated successfully."); window.location.href = "index.php";</script>'; } else { // Insert new category $query = "INSERT INTO `product_category` (`category_name`, `image`, `status`) VALUES ('$categoryName', '$image', '$status')"; mysqli_query($conn, $query); move_uploaded_file($imageTempName, $imagePath); echo '<script>alert("Category created successfully."); window.location.href = "index.php";</script>'; } exit; } ?> <!DOCTYPE html> <html lang="en"> <head> <?php require('style.php'); ?> </head> <body> <!-- loader starts--> <div class="loader-wrapper"> <div class="loader"> <div class="box"></div> <div class="box"></div> <div class="box"></div> <div class="box"></div> <div class="box"></div> </div> </div> <!-- loader ends--> <!-- tap on top starts--> <div class="tap-top"><i data-feather="chevrons-up"></i></div> <!-- tap on tap ends--> <!-- page-wrapper Start--> <div class="page-wrapper default-wrapper" id="pageWrapper"> <!-- Page Header Start--> <div class="page-header"> <div class="header-wrapper row m-0"> <div class="header-logo-wrapper col-auto p-0"> <div class="logo-wrapper"><a href="index.php"><img class="img-fluid for-light" src="assets/images/ashwikalogo.png" alt=""><img class="img-fluid for-dark" src="assets/images/ashwikalogo.png" alt=""></a></div> </div> <div class="left-header col-xxl-5 col-xl-6 col-md-4 col-auto box-col-6 horizontal-wrapper p-0"> <div class="left-menu-header"> <ul class="header-left"> <li> <div class="form-group w-100"> <div class="Typeahead Typeahead--twitterUsers"> <div class="u-posRelative d-flex"> <input class="demo-input py-0 Typeahead-input form-control-plaintext w-100" type="text" placeholder="Search anything..." name="q" title=""> </div> </div> </div> </li> </ul> </div> </div> <div class="nav-right col-xxl-7 col-xl-6 col-auto box-col-6 pull-right right-header p-0 ms-auto"> <ul class="nav-menus"> <li class="serchinput"> <div class="serchbox"> <svg> <use href="https://ashadminwika.pixelstrap.net/crocsassets/svg/icon-sprite.svg#fill-search"></use> </svg> </div> <div class="form-group search-form"> <input type="text" placeholder="Search here..."> </div> </li> <li> <div class="mode"> <i class="fa-solid fa-circle-half-stroke"></i> </div> </li> <li class="profile-nav onhover-dropdown p-0"> <div class="d-flex align-items-center profile-media"><img class="b-r-10 img-40" src="assets/images/dashboard/profile.png" alt=""> <div class="flex-grow-1"><span>New PC Jewellers</span> <p class="mb-0">Jewellery Shop</p> </div> </div> </li> </ul> </div> </div> </div> <!-- Page Header Ends --> <!-- Page Body Start--> <div class="page-body-wrapper default-menu default-menu"> <!-- Page Sidebar Start--> <?php require('sidebar.php') ?> <!-- Page Sidebar Ends--> <div class="page-body"> <div class="container-fluid"> <div class="page-title"> <div class="row"> <div class="col-sm-6 ps-0"> <h3><?php echo $editMode ? 'Edit Category' : 'Create Category'; ?></h3> </div> </div> </div> </div> <!-- Container-fluid starts--> <form action="" method="POST" enctype="multipart/form-data"> <div class="container-fluid"> <div class="row"> <div class="col-sm-12"> <div class="card"> <div class="card-body"> <div class="form theme-form"> <div class="row"> <div class="col"> <div class="mb-3"> <label>Category Name</label> <input class="form-control" type="text" name="category_name" placeholder="Category Name *" value="<?php echo htmlspecialchars($item['category_name'], ENT_QUOTES, 'UTF-8'); ?>"> </div> </div> </div> <div class="row"> <div class="col"> <div class="mb-3"> <label>Upload Category Image</label> <input type="file" name="image" placeholder="Upload Image" class="form-control" accept=".jpg, .jpeg, .png, .svg"> <?php if ($editMode && !empty($item['image'])): ?> <div class="mt-2"> <img src="uploads/<?php echo htmlspecialchars($item['image'], ENT_QUOTES, 'UTF-8'); ?>" alt="Category Image" style="max-width: 200px;"> </div> <?php endif; ?> </div> </div> </div> <div class="row"> <div class="col"> <div class="mb-3"> <label>Status</label> <select class="form-control" name="status"> <option value="1" <?php echo $item['status'] == '1' ? 'selected' : ''; ?>>Active</option> <option value="0" <?php echo $item['status'] == '0' ? 'selected' : ''; ?>>Inactive</option> </select> </div> </div> </div> <div class="row"> <div class="col"> <button type="submit" class="btn btn-success"><?php echo $editMode ? 'Update Category' : 'Create Category'; ?></button> <button type="reset" class="btn btn-outline-secondary" data-bs-dismiss="modal">Cancel</button> </div> </div> </div> </div> </div> </div> </div> </div> </form> <!-- Container-fluid Ends--> </div> <!-- footer start--> <?php require('footer.php') ?> </div> </div> </body> </html>