Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-611.13.1.el9_7.x86_64

PHP Version:

8.5.3

User:

justl3847

Directory:

/home/justlisting.in/public_html/admin

Free Space:

60.73 GB

🔧 Quick Actions

✏️ Editing: prdt_update_back.php

<?php
// Include database configuration file
include("root/db.php");

// Set a shorter lock wait timeout (in seconds)
$mysqli->query("SET innodb_lock_wait_timeout = 5;");

// Sanitize the incoming ID
$id = mysqli_real_escape_string($mysqli, $_POST['id']);

// Check if new images are uploaded
$img1 = "";
if (!empty($_FILES["img1"]['tmp_name'][0])) {
    $imgNames = [];
    foreach ($_FILES['img1']['tmp_name'] as $key => $tmp_name) {
        $temp = explode(".", $_FILES["img1"]["name"][$key]);
        $newfilename = rand() . "_" . date('m-d-Y_hia') . '.' . end($temp);

if (move_uploaded_file($tmp_name, "gallery/" . $newfilename)) {
            $imgNames[] = $newfilename;
        }
    }
    $img1 = implode(',', $imgNames);
}

// Sanitize form inputs
$pr_name = mysqli_real_escape_string($mysqli, $_POST['pr_name']);
$category = mysqli_real_escape_string($mysqli, $_POST['category']);
// $prize = mysqli_real_escape_string($mysqli, $_POST['prize']);
$pr_cnt = mysqli_real_escape_string($mysqli, $_POST['content']);
$location = mysqli_real_escape_string($mysqli, $_POST['location']);
$phone = mysqli_real_escape_string($mysqli, $_POST['phone']);
$email = mysqli_real_escape_string($mysqli, $_POST['email']);
$website = mysqli_real_escape_string($mysqli, $_POST['website']);
$facebook = mysqli_real_escape_string($mysqli, $_POST['facebook']);
$instagram = mysqli_real_escape_string($mysqli, $_POST['instagram']);
$twitter = mysqli_real_escape_string($mysqli, $_POST['twitter']);
$linkedin = mysqli_real_escape_string($mysqli, $_POST['linkedin']);
$youtube = mysqli_real_escape_string($mysqli, $_POST['youtube']);
$tags = mysqli_real_escape_string($mysqli, $_POST['tags']);
$features = mysqli_real_escape_string($mysqli, $_POST['features']);
$business_hours = mysqli_real_escape_string($mysqli, $_POST['business_hours']);
$map = mysqli_real_escape_string($mysqli, $_POST['map']);
$pg_tlt = mysqli_real_escape_string($mysqli, $_POST['pg_tlt']);
$meta_desc = mysqli_real_escape_string($mysqli, $_POST['description']);
$h1 = mysqli_real_escape_string($mysqli, $_POST['h1']);

// ---------------------------------------------------------
// ✅ NEW: Generate URL Slug from H1 Tag (Update Logic)
// ---------------------------------------------------------

// 1. Convert to lowercase
$slug_raw = strtolower($h1);

// 2. Remove special characters (keep letters, numbers, spaces, and hyphens)
$slug_raw = preg_replace('/[^a-z0-9\s-]/', '', $slug_raw);

// 3. Replace multiple spaces or hyphens with a single hyphen
$slug_raw = preg_replace('/[\s-]+/', '-', $slug_raw);

// 4. Trim hyphens from start and end
$url_slug = trim($slug_raw, '-');
// ---------------------------------------------------------

// Construct SQL query
$sql = "UPDATE product SET 
    pr_name = '$pr_name',
    category = '$category',
    content = '$pr_cnt',
    location = '$location',
    phone = '$phone',
    email = '$email',
    website = '$website',
    facebook = '$facebook',
    instagram = '$instagram',
    twitter = '$twitter',
    linkedin = '$linkedin',
    youtube = '$youtube',
    tags = '$tags',
    features = '$features',
    business_hours = '$business_hours',
    map = '$map',
    pg_tlt = '$pg_tlt',
    `description` = '$meta_desc',
    h1 = '$h1',
    url_slug = '$url_slug'"; // ✅ Updated Slug here

// If new images uploaded, update image field
if (!empty($img1)) {
    $sql .= ", pr_img = '$img1'";
}

$sql .= " WHERE id = '$id'";

// Execute SQL query
if (mysqli_query($mysqli, $sql)) {
    header("Location: prdt.php?msg=updated");
    exit();
} else {
    die("Error updating record: " . mysqli_error($mysqli));
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: prdt_update_back.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation