:: **Zploit** v1.0 | Current Path: **/home/kreativepixelz/www/demo/jdc/new/admin/**
:: Editing File: sub_subcategory_edit.php
<?php require_once 'db.php'; require_once 'session.php'; include "header.php"; // ✅ Check ID if (!isset($_GET['id']) || empty($_GET['id'])) { $_SESSION['error'] = "Error: Sub Sub Category ID is missing."; header("Location: sub_subcategory_list.php"); exit; } $subsub_id = (int)$_GET['id']; // ✅ Fetch Sub Sub Category $sql = "SELECT * FROM sub_subcategories WHERE id = ?"; $stmt = mysqli_prepare($conn, $sql); if ($stmt) { mysqli_stmt_bind_param($stmt, "i", $subsub_id); mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); $subsub = mysqli_fetch_assoc($result); mysqli_stmt_close($stmt); if (!$subsub) { $_SESSION['error'] = "Sub Sub Category not found."; header("Location: sub_subcategory_list.php"); exit; } } else { $_SESSION['error'] = "Database error."; header("Location: sub_subcategory_list.php"); exit; } // ✅ Fetch Categories $categories = []; $result = mysqli_query($conn,"SELECT id,name FROM categories ORDER BY name ASC"); while($row = mysqli_fetch_assoc($result)){ $categories[] = $row; } // ✅ Fetch Subcategories $subcategories = []; $result2 = mysqli_query($conn,"SELECT id,name FROM subcategories ORDER BY name ASC"); while($row = mysqli_fetch_assoc($result2)){ $subcategories[] = $row; } ?> <div class="page-content-wrapper"> <div class="page-content"> <!-- Breadcrumb --> <div class="page-breadcrumb d-none d-sm-flex align-items-center mb-3"> <div class="breadcrumb-title pe-3">Sub Sub Category</div> <div class="ps-3"> <nav aria-label="breadcrumb"> <ol class="breadcrumb mb-0 p-0 align-items-center"> <li class="breadcrumb-item"> <a href="dashboard.php"> <ion-icon name="home-outline"></ion-icon> </a> </li> <li class="breadcrumb-item active"> Edit Sub Sub Category </li> </ol> </nav> </div> </div> <div class="card"> <div class="card-header"> <h6 class="mb-0"> Edit Sub Sub Category - <?= htmlspecialchars($subsub['name']) ?> </h6> </div> <div class="card-body"> <form action="sub_subcategory_update.php" method="POST" enctype="multipart/form-data"> <input type="hidden" name="sub_subcategory_id" value="<?= $subsub['id']; ?>"> <input type="hidden" name="old_image_path" value="<?= $subsub['image']; ?>"> <div class="row"> <!-- Category --> <div class="mb-3 col-sm-6"> <label class="form-label">Select Category</label> <select name="category_id" class="form-control" required> <option value="">Select Category</option> <?php foreach($categories as $cat){ ?> <option value="<?= $cat['id'] ?>" <?= ($cat['id']==$subsub['category_id'])?'selected':'' ?>> <?= htmlspecialchars($cat['name']) ?> </option> <?php } ?> </select> </div> <!-- Subcategory --> <div class="mb-3 col-sm-6"> <label class="form-label">Select Sub Category</label> <select name="subcategory_id" class="form-control" required> <option value="">Select Sub Category</option> <?php foreach($subcategories as $sub){ ?> <option value="<?= $sub['id'] ?>" <?= ($sub['id']==$subsub['subcategory_id'])?'selected':'' ?>> <?= htmlspecialchars($sub['name']) ?> </option> <?php } ?> </select> </div> <!-- Name --> <div class="mb-3 col-sm-6"> <label class="form-label">Sub Sub Category Name</label> <input type="text" class="form-control" id="subSubName" name="name" value="<?= htmlspecialchars($subsub['name']); ?>" required> </div> <!-- Subheading --> <div class="mb-3 col-sm-6"> <label class="form-label">Subheading</label> <input type="text" class="form-control" name="subheading" value="<?= htmlspecialchars($subsub['subheading']); ?>"> </div> <!-- Image --> <div class="mb-3 col-sm-4"> <label class="form-label">Image Upload</label> <input type="file" class="form-control" name="image" accept="image/*"> <?php if (!empty($subsub['image'])): ?> <small class="text-muted"> Current Image : <a href="../uploads/sub_subcategory/<?= $subsub['image'] ?>" target="_blank"> View </a> </small> <?php endif; ?> </div> <!-- URL --> <div class="mb-3 col-sm-4"> <label class="form-label">URL Slug</label> <input type="text" class="form-control" id="urlSlug" name="url" value="<?= htmlspecialchars($subsub['url']); ?>"> </div> <!-- Sort Order --> <div class="mb-3 col-sm-4"> <label class="form-label">Sort Order</label> <input type="number" class="form-control" name="sort_order" value="<?= $subsub['sort_order']; ?>"> </div> <!-- Content --> <div class="mb-3 col-sm-12"> <label class="form-label">Content</label> <textarea class="form-control" name="content" rows="5"> <?= htmlspecialchars($subsub['content']); ?> </textarea> </div> <div class="col-12 mt-4"> <button type="submit" class="btn btn-success"> Update Sub Sub Category </button> <a href="sub_subcategory.php" class="btn btn-warning"> Back to List </a> </div> </div> </form> </div> </div> </div> </div> <!-- Slug Generator --> <script> document.getElementById('subSubName').addEventListener('input',function(){ let name=this.value.trim(); let slug=name.toLowerCase() .replace(/[\s_]+/g,'-') .replace(/[^a-z0-9\-]/g,'') .replace(/-+/g,'-') .replace(/^-+|-+$/g,''); document.getElementById('urlSlug').value=slug; }); </script> <?php include "footer.php"; ?>