:: **Zploit** v1.0 | Current Path: **/home/kreativepixelz/www/demo/jdc/new/admin/**
:: Editing File: sub_subcategory_update.php
<?php // sub_subcategory_update.php require_once 'db.php'; require_once 'session.php'; // Upload folder $upload_dir = '../uploads/sub_subcategory/'; if ($_SERVER['REQUEST_METHOD'] === 'POST') { // 1️⃣ Sanitize Inputs $sub_subcategory_id = (int)($_POST['sub_subcategory_id'] ?? 0); $category_id = (int)($_POST['category_id'] ?? 0); $subcategory_id = (int)($_POST['subcategory_id'] ?? 0); $name = trim($_POST['name'] ?? ''); $subheading = trim($_POST['subheading'] ?? ''); $content = trim($_POST['content'] ?? ''); $url = trim($_POST['url'] ?? ''); $sort_order = (int)($_POST['sort_order'] ?? 0); $old_image_path = $_POST['old_image_path'] ?? ''; if ($sub_subcategory_id <= 0 || $category_id <= 0 || $subcategory_id <= 0 || $name === '') { $_SESSION['error'] = "Invalid request: Category, Subcategory or Name missing."; header("Location: sub_subcategory.php"); exit; } // 2️⃣ Auto Slug Generate if (empty($url)) { $url = strtolower(preg_replace('/[^a-z0-9]+/', '-', trim($name))); $url = trim($url, '-'); } // 3️⃣ Image Upload $new_image_name = $old_image_path; $file_uploaded = false; if (isset($_FILES['image']) && $_FILES['image']['error'] === UPLOAD_ERR_OK) { $file_name = $_FILES['image']['name']; $file_tmp = $_FILES['image']['tmp_name']; $file_ext = strtolower(pathinfo($file_name, PATHINFO_EXTENSION)); $allowed = ['jpg','jpeg','png','gif','webp']; if (in_array($file_ext,$allowed)) { $unique_name = uniqid('subsubcat_').'.'.$file_ext; $target_path = $upload_dir.$unique_name; if (move_uploaded_file($file_tmp,$target_path)) { $new_image_name = $unique_name; $file_uploaded = true; } else { $_SESSION['error']="Failed to upload image."; header("Location: sub_subcategory_edit.php?id=$sub_subcategory_id"); exit; } } else { $_SESSION['error']="Invalid image format."; header("Location: sub_subcategory_edit.php?id=$sub_subcategory_id"); exit; } } // 4️⃣ Update Query $sql = "UPDATE sub_subcategories SET category_id=?, subcategory_id=?, name=?, subheading=?, content=?, url=?, sort_order=?, image=? WHERE id=?"; $stmt = mysqli_prepare($conn,$sql); if(!$stmt){ $_SESSION['error']="Database error: ".mysqli_error($conn); header("Location: sub_subcategory_edit.php?id=$sub_subcategory_id"); exit; } mysqli_stmt_bind_param( $stmt, "iissssisi", $category_id, $subcategory_id, $name, $subheading, $content, $url, $sort_order, $new_image_name, $sub_subcategory_id ); if(mysqli_stmt_execute($stmt)){ // Delete old image if($file_uploaded && !empty($old_image_path) && $old_image_path != $new_image_name){ $old_file = $upload_dir.basename($old_image_path); if(file_exists($old_file)){ unlink($old_file); } } $_SESSION['success']="Sub Sub Category <strong>{$name}</strong> updated successfully!"; header("Location: sub_subcategory_list.php"); exit; }else{ $_SESSION['error']="Error updating Sub Sub Category: ".mysqli_error($conn); if($file_uploaded && file_exists($upload_dir.$new_image_name)){ unlink($upload_dir.$new_image_name); } header("Location: sub_subcategory_edit.php?id=$sub_subcategory_id"); exit; } mysqli_stmt_close($stmt); mysqli_close($conn); }else{ $_SESSION['error']="Invalid request method."; header("Location: sub_subcategory_list.php"); exit; } ?>