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: servicesform.php

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

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

if (isset($_POST['submit'])) {

// Retrieve form data
    $sid = $_POST['sid'];
    $title = $_POST['title'];
    $about = $_POST['about'];
    $description1 = $_POST['description1'];
    $description2 = $_POST['description2'];
    $service_description = $_POST['service_description'];
    $choose_title = $_POST['choose_title'];
    $choose_desc = $_POST['choose_desc'];
    $choose_title1 = $_POST['choose_title1'];
    $choose_desc1 = $_POST['choose_desc1'];
    $choose_title2 = $_POST['choose_title2'];
    $choose_desc2 = $_POST['choose_desc2'];
    $choose_title3 = $_POST['choose_title3'];
    $choose_desc3 = $_POST['choose_desc3'];
    $choose_title4 = $_POST['choose_title4'];
    $choose_desc4 = $_POST['choose_desc4'];
    $feature_title = $_POST['feature_title'];
    $feature_desc1 = $_POST['feature_desc1'];
    $feature_desc2 = $_POST['feature_desc2'];
    $submenu = $_POST['submenu'];
    $subtitle1 = $_POST['subtitle1'];
    $page_title = $_POST['page_title'];
    $description = $_POST['description'];
    $keywords = $_POST['keywords'];
    $robots = $_POST['robots'];
    $canonical = $_POST['canonical'];

// Image upload handling
    $imagename = $_FILES['simg']['name'];
    $tempname = $_FILES['simg']['tmp_name'];

$imagename1 = $_FILES['service_image']['name'];
    $tempname1 = $_FILES['service_image']['tmp_name'];

$imagename2 = $_FILES['fea_img1']['name'];
    $tempname2 = $_FILES['fea_img1']['tmp_name'];

$imagename3 = $_FILES['fea_img2']['name'];
    $tempname3 = $_FILES['fea_img2']['tmp_name'];

// Upload images if present
    if (!empty($imagename)) {
        move_uploaded_file($tempname, "dataimg/$imagename");
    }
    if (!empty($imagename1)) {
        move_uploaded_file($tempname1, "dataimg/$imagename1");
    }
    if (!empty($imagename2)) {
        move_uploaded_file($tempname2, "dataimg/$imagename2");
    }
    if (!empty($imagename3)) {
        move_uploaded_file($tempname3, "dataimg/$imagename3");
    }

// Build update query
    $qry = "UPDATE `services` SET 
        `title`='$title',
        `about`='$about',
        `description1`='$description1',
        `description2`='$description2',
        `submenu`='$submenu',
        `service_description`='$service_description',
        `choose_title`='$choose_title',
        `choose_desc`='$choose_desc',
        `choose_title1`='$choose_title1',
        `choose_desc1`='$choose_desc1',
        `choose_title2`='$choose_title2',
        `choose_desc2`='$choose_desc2',
        `choose_title3`='$choose_title3',
        `choose_desc3`='$choose_desc3',
        `choose_title4`='$choose_title4',
        `choose_desc4`='$choose_desc4',
        `feature_title`='$feature_title',
        `feature_desc1`='$feature_desc1',
        `feature_desc2`='$feature_desc2',
        `page_title`='$page_title',
        `description`='$description',
        `keywords`='$keywords',
        `robots`='$robots',
        `canonical`='$canonical',
        `subtitle1`='$subtitle1'";

// Add image fields if a new file was uploaded
    if (!empty($imagename)) {
        $qry .= ", `image`='$imagename'";
    }
    if (!empty($imagename1)) {
        $qry .= ", `service_image`='$imagename1'";
    }
    if (!empty($imagename2)) {
        $qry .= ", `fea_img1`='$imagename2'";
    }
    if (!empty($imagename3)) {
        $qry .= ", `fea_img2`='$imagename3'";
    }

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

$run = mysqli_query($conn, $qry);

if ($run) {
       
        $delFaq = "DELETE FROM `solution_faqs` WHERE `service_content_id`=?";
        $stmtDel = mysqli_prepare($conn, $delFaq);
        mysqli_stmt_bind_param($stmtDel, "i", $sid);
        mysqli_stmt_execute($stmtDel);
        mysqli_stmt_close($stmtDel);

if (!empty($_POST['faqs'])) {
            $insertFaq = "INSERT INTO `solution_faqs` (`service_content_id`, `question`, `answer`) VALUES (?, ?, ?)";
            $stmtInsert = mysqli_prepare($conn, $insertFaq);

foreach ($_POST['faqs'] as $faq) {
                $question = trim($faq['question']);
                $answer = trim($faq['answer']);
                if (!empty($question) && !empty($answer)) {
                    mysqli_stmt_bind_param($stmtInsert, "iss", $sid, $question, $answer);
                    mysqli_stmt_execute($stmtInsert);
                }
            }

mysqli_stmt_close($stmtInsert);
        }

echo '<script>alert("Data Updated Successfully");</script>';
        echo '<script>window.location.href="servicesshow.php";</script>';
    } else {
        echo '<script>alert("Failed to Update Data");</script>';
    }
}

$sid = $_GET['sid'];
$sql = "SELECT * FROM `services` WHERE `id`='$sid'";
$run = mysqli_query($conn, $sql);
$updateabout = mysqli_fetch_assoc($run);

<div class="container">
    <div class="title">Update Service</div>
    <script src="https://cdn.ckeditor.com/4.16.2/standard/ckeditor.js"></script>
    <form action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?>" method="post" enctype="multipart/form-data">
        <div class="form-group">
            <label for="exampleInputEmail1">Title</label>
            <input type="text" class="form-control" id="title" name="title" value="<?php echo $updateabout['title']; ?>" >
        </div>
         <div class="form-group ">
            <label for="exampleInputEmail1">Project Menu</label>
            <input type="text" class="form-control" id="submenu" name="submenu" value="<?php echo $updateabout['submenu']; ?>" >
        </div>

<div class="form-group">
            <label for="exampleInputPassword1">About</label>
            <textarea id="about" name="about"><?php echo $updateabout['about']; ?></textarea>
        </div>

<div class="form-group">
            <label for="exampleInputPassword1">Detail Description 1</label>
            <textarea id="description1" name="description1"><?php echo $updateabout['description1']; ?></textarea>
        </div>

<div class="form-group">
            <label for="exampleInputPassword1">Detail Description 2</label>
            <textarea id="description2" name="description2"><?php echo $updateabout['description2']; ?></textarea>
        </div>

<div class="form-group">
            <label for="exampleInputPassword1">Service Image</label>
            <input type="file" name="service_image">
            <br>
            <small>Current Image: <img src="dataimg/<?php echo $updateabout['service_image']; ?>" width="100"></small>
        </div>

<div class="form-group">
            <label for="exampleInputPassword1">Detail Description 2</label>
            <textarea id="description2" name="service_description"><?php echo $updateabout['service_description']; ?></textarea>
        </div>

<div class="form-group">
            <label for="exampleInputEmail1">Choose Title</label>
            <input type="text" class="form-control" id="title" name="choose_title" value="<?php echo $updateabout['choose_title']; ?>" >
        </div>

<div class="form-group">
            <label for="exampleInputPassword1">Choose Description</label>
            <textarea id="choose_desc" name="choose_desc"><?php echo $updateabout['choose_desc']; ?></textarea>
        </div>

<div class="form-group">
            <label for="title">Choose Title 1</label>
            <input type="text" class="form-control" name="choose_title1" value="<?=$updateabout['choose_title1'];?>" placeholder="Title" >
        </div>

<div class="form-group">
            <label for="about">Choose Service Description 1 </label>
             <textarea rows="3" class="form-control"  name="choose_desc1"><?=$updateabout['choose_desc1'];?></textarea>
        </div>

<div class="form-group">
            <label for="title">Choose Title 2</label>
            <input type="text" class="form-control" name="choose_title2" value="<?=$updateabout['choose_title2'];?>" placeholder="Title" >
        </div>

<div class="form-group">
            <label for="about">Choose Service Description 2 </label>
             <textarea rows="3" class="form-control" name="choose_desc2"><?=$updateabout['choose_desc2'];?></textarea>
        </div>

<div class="form-group">
            <label for="title">Choose Title 3</label>
            <input type="text" class="form-control" name="choose_title3" value="<?=$updateabout['choose_title3'];?>" placeholder="Title" >
        </div>

<div class="form-group">
            <label for="about">Choose Service Description 3</label>
             <textarea rows="3" class="form-control" name="choose_desc3"><?=$updateabout['choose_desc3'];?></textarea>
        </div>

<div class="form-group">
            <label for="title">Choose Title 4</label>
            <input type="text" class="form-control" name="choose_title4" value="<?=$updateabout['choose_title4'];?>" placeholder="Title" >
        </div>

<div class="form-group">
            <label for="about">Choose Service Description 4 </label>
             <textarea rows="3" class="form-control" name="choose_desc4"><?=$updateabout['choose_desc4'];?></textarea>
        </div>

<div class="form-group">
            <label for="exampleInputEmail1">Feature Title</label>
            <input type="text" class="form-control" id="title" name="feature_title" value="<?php echo $updateabout['feature_title']; ?>" >
        </div>

<div class="form-group">
            <label for="exampleInputPassword1">Feature Description</label>
            <textarea id="feature_desc1" name="feature_desc1"><?php echo $updateabout['feature_desc1']; ?></textarea>
        </div>

<div class="form-group">
            <label for="exampleInputPassword1">Feature Description</label>
            <textarea id="feature_desc2" name="feature_desc2"><?php echo $updateabout['feature_desc2']; ?></textarea>
        </div>

<div class="form-group ">
            <label for="exampleInputPassword1">Feature Image 1 </label>
            <input type="file" name="fea_img1">
            <br>
            <small>Current Image: <img src="dataimg/<?php echo $updateabout['fea_img1']; ?>" width="100"></small>
        </div>
        
          <div class="form-group">
            <label for="exampleInputPassword1">Feature Image 1</label>
            <input type="file" name="fea_img2">
            <br>
            <small>Current Image: <img src="dataimg/<?php echo $updateabout['fea_img2']; ?>" width="100"></small>
        </div>

<div class="form-group d-none">
            <label for="exampleInputEmail1">Page Title</label>
            <input type="text" class="form-control" name="page_title" value="<?php echo $updateabout['page_title']; ?>">
        </div>
        <div class="form-group d-none">
            <label for="exampleInputEmail1">Description</label>
            <input type="text" class="form-control" name="description" value="<?php echo $updateabout['description']; ?>">
        </div>
        <div class="form-group d-none">
            <label for="exampleInputEmail1">Keywords</label>
            <input type="text" class="form-control" name="keywords" value="<?php echo $updateabout['keywords']; ?>">
        </div>
        <div class="form-group d-none">
            <label for="exampleInputEmail1">Robots</label>
            <input type="text" class="form-control" name="robots" value="<?php echo $updateabout['robots']; ?>">
        </div>
        <div class="form-group d-none">
            <label for="exampleInputEmail1">Canonical</label>
            <input type="text" class="form-control" name="canonical" value="<?php echo $updateabout['canonical']; ?>">
        </div>
        <div class="form-group d-none">
            <label for="exampleInputPassword1">Sub Title</label>
            <textarea id="subtitle1" name="subtitle1"><?php echo $updateabout['subtitle1']; ?></textarea>
        </div>
        <div class="form-group">
            <label for="exampleInputPassword1">Image</label>
            <input type="file" name="simg">
        </div>

<h3>FAQs</h3>
    <div id="faq-section">
        <?php
        $faqQuery = "SELECT * FROM `solution_faqs` WHERE `service_content_id` = $sid";
        $faqResult = mysqli_query($conn, $faqQuery);
        $faqIndex = 0;
        while ($faq = mysqli_fetch_assoc($faqResult)) {
        ?>
            <div class="faq-item" id="faq-<?php echo $faqIndex; ?>">
                <input type="hidden" name="faqs[<?php echo $faqIndex; ?>][id]" value="<?php echo $faq['id']; ?>">
                <label>Question</label>
                <input type="text" name="faqs[<?php echo $faqIndex; ?>][question]" value="<?php echo $faq['question']; ?>" class="form-control" >
                <label>Answer</label>
                <textarea name="faqs[<?php echo $faqIndex; ?>][answer]" class="form-control" required><?php echo $faq['answer']; ?></textarea>
                <button type="button" class="btn btn-danger" onclick="deleteFaq(<?php echo $faqIndex; ?>)">Delete</button>
            </div>
        <?php
            $faqIndex++;
        }
        ?>
    </div>
    <button type="button" class="btn btn-success" onclick="addFaq()">Add FAQ</button>

<input type="hidden" name="sid" value="<?php echo $sid; ?>">
        <button type="submit" name="submit" class="btn btn-primary">Submit</button>
    </form>
    <script>
        CKEDITOR.replace('subtitle1');
        CKEDITOR.replace('about');
        CKEDITOR.replace('description1');
        CKEDITOR.replace('description2');
        CKEDITOR.replace('service_description');
        CKEDITOR.replace('choose_desc');
        CKEDITOR.replace('feature_desc1');
        CKEDITOR.replace('feature_desc2');
    </script>
</div>

<script src="../assets/vendor/libs/jquery/jquery.js"></script>
    <script src="../assets/vendor/libs/popper/popper.js"></script>
    <script src="../assets/vendor/js/bootstrap.js"></script>
    <script src="../assets/vendor/libs/perfect-scrollbar/perfect-scrollbar.js"></script>

<script src="../assets/js/main.js"></script>
     <script>
let faqCount = <?php echo $faqIndex; ?>;

// Delete a field
function deleteField(button) {
    button.closest('.field-group').remove();
}
</script>

<script async defer src="https://buttons.github.io/buttons.js"></script>
  </body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: servicesform.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation