📁 File Manager
Editing:
/home/wedigitalindia/www/jaybalajiassociates.com/admin/edit_top_Categories.php
<?php include("connection.php"); include("header.php"); ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL); // Slug generator function generateSlug($string) { $slug = preg_replace('/[^A-Za-z0-9-]+/', '-', strtolower($string)); return trim($slug, '-'); } // Get ID $id = isset($_GET['id']) ? (int)$_GET['id'] : 0; if ($id <= 0) { echo "<div class='alert alert-danger m-3'>Invalid category.</div>"; include("footer.php"); exit; } // Fetch category $q = mysqli_query($con, "SELECT * FROM top_categories WHERE id=$id LIMIT 1"); $row = mysqli_fetch_assoc($q); if (!$row) { echo "<div class='alert alert-danger m-3'>Category not found.</div>"; include("footer.php"); exit; } $error_message = ''; $valid = 1; // Update logic if (isset($_POST['submit'])) { $name = trim($_POST['name'] ?? ''); $slug_input = trim($_POST['slug'] ?? ''); $description = $_POST['description'] ?? ''; if ($name === '') { $valid = 0; $error_message .= "Category name is required.<br>"; } if ($valid == 1) { // ---- Slug ---- $slugBase = $slug_input !== '' ? $slug_input : $name; $slug = generateSlug($slugBase); $slug = mysqli_real_escape_string($con, $slug); // Ensure slug unique (exclude current) $checkSlug = mysqli_query($con, "SELECT COUNT(*) AS total FROM top_categories WHERE slug='$slug' AND id != $id" ); $rowSlug = mysqli_fetch_assoc($checkSlug); if ($rowSlug['total'] > 0) { $slug .= '-' . time(); } $name = mysqli_real_escape_string($con, $name); $description = mysqli_real_escape_string($con, $description); // ---- Image Upload (optional replace) ---- $uploadDir = "./assets/images/top_categories/"; if (!is_dir($uploadDir)) { mkdir($uploadDir, 0777, true); } $imageSql = ""; if (isset($_FILES['image']) && $_FILES['image']['error'] === UPLOAD_ERR_OK) { // Remove old image if ($row['image'] && file_exists($uploadDir . $row['image'])) { unlink($uploadDir . $row['image']); } $ext = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION); $imageName = time() . '_' . uniqid('cat_') . '.' . $ext; move_uploaded_file($_FILES['image']['tmp_name'], $uploadDir . $imageName); $imageSql = ", image='" . mysqli_real_escape_string($con, $imageName) . "'"; } $descSql = $description !== '' ? ", description='$description'" : ", description=NULL"; // ---- Update ---- $sql = "UPDATE top_categories SET name='$name', slug='$slug' $imageSql $descSql WHERE id=$id"; if (mysqli_query($con, $sql)) { header("Location: view_top_Categories.php"); exit(); } else { $error_message .= "Database Error: " . mysqli_error($con); } } } ?> <div class="main-content"> <div class="page-content"> <div class="container-fluid"> <div class="row"> <div class="col-12"> <div class="page-title-box"> <h4 class="mb-sm-0 font-size-18">Edit Top Category</h4> </div> </div> </div> <?php if ($error_message != ''): ?> <div class="alert alert-danger"><?php echo $error_message; ?></div> <?php endif; ?> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-body"> <form method="POST" enctype="multipart/form-data"> <div class="row mb-3"> <div class="col-lg-4"> <label class="form-label">Category Name</label> <input type="text" name="name" id="name" class="form-control" value="<?php echo htmlspecialchars($row['name']); ?>" onkeyup="generateSlug()" required> </div> <div class="col-lg-4"> <label class="form-label">Slug</label> <input type="text" name="slug" id="slug" class="form-control" value="<?php echo htmlspecialchars($row['slug']); ?>"> </div> <div class="col-lg-4"> <label class="form-label">Category Image</label> <input type="file" name="image" id="image" class="form-control" accept="image/*"> <?php if ($row['image']): ?> <img src="./assets/images/top_categories/<?php echo htmlspecialchars($row['image']); ?>" class="img-thumbnail mt-2" style="max-height:120px;"> <?php endif; ?> <img id="preview" class="img-thumbnail mt-2" style="max-height:120px; display:none;"> </div> </div> <div class="mb-3"> <label class="form-label">Description</label> <textarea name="description" id="description" class="form-control" rows="6"><?php echo htmlspecialchars($row['description'] ?? ''); ?></textarea> </div> <div class="text-center mt-4"> <button type="submit" name="submit" class="btn btn-primary"> Update </button> <a href="view_top_categories.php" class="btn btn-danger"> Back to List </a> </div> </form> </div> </div> </div> </div> </div> </div> <?php include("footer.php"); ?> </div> <!-- CKEditor --> <script src="./ck editor/ckeditor.js"></script> <script> CKEDITOR.replace('description'); // CKEDITOR.replace('short_desc'); // Auto slug function generateSlug() { let text = document.getElementById("name").value.toLowerCase(); text = text.replace(/[^a-z0-9\s-]/g, '') .replace(/\s+/g, '-') .replace(/-+/g, '-') .replace(/^-+|-+$/g, ''); document.getElementById("slug").value = text; } // Image preview document.getElementById("image").addEventListener("change", function(e) { const file = e.target.files[0]; if (!file) return; const reader = new FileReader(); reader.onload = () => { document.getElementById("preview").src = reader.result; document.getElementById("preview").style.display = "block"; }; reader.readAsDataURL(file); }); </script>
Save
Cancel