Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u184721437

Directory:

/home/u184721437/domains/bago-holdings.com/public_html/admin

Free Space:

7.12 TB

🔧 Quick Actions

✏️ Editing: projectupdatedata.php

<?php
include('../dbcon.php');

$sid = isset($_POST['sid']) ? intval($_POST['sid']) : 0; 
$submenu = mysqli_real_escape_string($conn, $_POST['submenu']);
$title = mysqli_real_escape_string($conn, $_POST['title']);
$subtitle1 = mysqli_real_escape_string($conn, $_POST['subtitle1']);
$page_title = mysqli_real_escape_string($conn, $_POST['page_title']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
$project_name = mysqli_real_escape_string($conn, $_POST['project_name']);
$client = mysqli_real_escape_string($conn, $_POST['client']);
$category = mysqli_real_escape_string($conn, $_POST['category']);
$date = mysqli_real_escape_string($conn, $_POST['date']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
$keywords = mysqli_real_escape_string($conn, $_POST['keywords']);
$robots = mysqli_real_escape_string($conn, $_POST['robots']);
$canonical = mysqli_real_escape_string($conn, $_POST['canonical']);

$aboutimagename = $_FILES['aboutimage']['name'];
$tempname = $_FILES['aboutimage']['tmp_name'];
$imagePath = '';

if (!empty($aboutimagename)) {
    $imagePath = "./dataimg/" . uniqid() . "_" . basename($aboutimagename);
    if (!move_uploaded_file($tempname, $imagePath)) {
        echo "<script>
                alert('Error uploading the image.');
                window.history.back();
              </script>";
        exit();
    }
}

// Update project data
$qry = "UPDATE `project` SET 
        `submenu` = '$submenu',
        `title` = '$title',
        `subtitle1` = '$subtitle1',
        `page_title` = '$page_title',
        `description` = '$description',
        `project_name` = '$project_name',
        `client` = '$client',
        `category` = '$category',
        `date` = '$date',
        `address` = '$address',
        `keywords` = '$keywords',
        `robots` = '$robots',
        `canonical` = '$canonical'";

if (!empty($imagePath)) {
    $qry .= ", `image` = '$imagePath'";
}

$qry .= " WHERE `id` = $sid";

if (!mysqli_query($conn, $qry)) {
    echo "<script>
            alert('Error updating project: " . mysqli_error($conn) . "');
            window.history.back();
          </script>";
    exit();
}

if (isset($_POST['faqs'])) {
    $faqs = $_POST['faqs'];

$faqIds = array_filter(array_column($faqs, 'id'), fn($id) => !empty($id));
    if (!empty($faqIds)) {
        $faqIdList = implode(',', $faqIds);
        $deleteQry = "DELETE FROM `faqs_project` WHERE `project_id` = $sid AND `id` NOT IN ($faqIdList)";
        mysqli_query($conn, $deleteQry);
    } else {
        $deleteQry = "DELETE FROM `faqs_project` WHERE `project_id` = $sid";
        mysqli_query($conn, $deleteQry);
    }

foreach ($faqs as $faq) {
        $faqId = isset($faq['id']) ? intval($faq['id']) : 0;
        $question = mysqli_real_escape_string($conn, $faq['question']);
        $answer = mysqli_real_escape_string($conn, $faq['answer']);

if ($faqId > 0) {
           
            $updateFaqQry = "UPDATE `faqs_project` SET `question` = '$question', `answer` = '$answer' WHERE `id` = $faqId";
            mysqli_query($conn, $updateFaqQry);
        } else {
            
            $insertFaqQry = "INSERT INTO `faqs_project` (`project_id`, `question`, `answer`) VALUES ($sid, '$question', '$answer')";
            mysqli_query($conn, $insertFaqQry);
        }
    }
}

echo "<script>
        alert('Project and FAQs updated successfully');
        window.open('projectshow.php?sid=$sid', '_self');
      </script>";
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: projectupdatedata.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation