:: **Zploit** v1.0 | Current Path: **/home/kreativepixelz/www/demo/jdc_studio/admin/**
:: Editing File: 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: Subcategory ID is missing."; header("Location: subcategory.php"); exit; } $subcategory_id = (int)$_GET['id']; // ✅ Fetch Subcategory $sql = "SELECT * FROM subcategories WHERE id = ?"; $stmt = mysqli_prepare($conn, $sql); if ($stmt) { mysqli_stmt_bind_param($stmt, "i", $subcategory_id); mysqli_stmt_execute($stmt); $result = mysqli_stmt_get_result($stmt); $subcategory = mysqli_fetch_assoc($result); mysqli_stmt_close($stmt); if (!$subcategory) { $_SESSION['error'] = "Subcategory not found."; header("Location: subcategory.php"); exit; } } else { $_SESSION['error'] = "Database error."; header("Location: subcategory.php"); exit; } // ✅ Fetch Categories for dropdown $categories = []; $result = mysqli_query($conn,"SELECT id,name FROM categories ORDER BY name ASC"); while($row = mysqli_fetch_assoc($result)){ $categories[] = $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 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 Category </li> </ol> </nav> </div> </div> <div class="card"> <div class="card-header"> <h6 class="mb-0"> Edit Sub Category - <?= htmlspecialchars($subcategory['name']) ?> </h6> </div> <div class="card-body"> <form action="subcategory_update.php" method="POST" enctype="multipart/form-data"> <input type="hidden" name="subcategory_id" value="<?= $subcategory['id']; ?>"> <input type="hidden" name="old_image_path" value="<?= $subcategory['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']==$subcategory['category_id'])?'selected':'' ?>> <?= htmlspecialchars($cat['name']) ?> </option> <?php } ?> </select> </div> <!-- Subcategory Name --> <div class="mb-3 col-sm-6"> <label class="form-label">Sub Category Name</label> <input type="text" class="form-control" id="subcategoryName" name="name" value="<?= htmlspecialchars($subcategory['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($subcategory['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($subcategory['image'])): ?> <small class="text-muted"> Current Image : <a href="../uploads/subcategory/<?= $subcategory['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($subcategory['url']); ?>"> </div> <!-- Content --> <div class="mb-3 col-sm-12"> <label class="form-label">Content</label> <textarea class="form-control" name="content" rows="5"> <?= htmlspecialchars($subcategory['content']); ?> </textarea> </div> <div class="col-12 mt-4"> <button type="submit" class="btn btn-success"> Update Sub Category </button> <a href="subcategory.php" class="btn btn-warning"> Back to List </a> </div> </div> </form> </div> </div> </div> </div> <!-- Slug Generator --> <script> document.getElementById('subcategoryName').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"; ?>