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

<?php
session_start();
if (!isset($_SESSION["username"])) {
    header('location:../admin.php');
    exit();
}

include('header.php');
include('../dbcon.php');

// Function moved here so it doesn't get re-declared each loop
function fetchData($conn, $table, $service_id) {
    $query = "SELECT * FROM $table WHERE service_content_id = ?";
    $stmt = $conn->prepare($query);
    $stmt->bind_param("i", $service_id);
    $stmt->execute();
    return $stmt->get_result();
}
?>

<div class="container">
    <h2>Solution</h2>
    <h2 align="right">
        <a class="btn btn-success" href="solutions.php">Add Solution</a>
    </h2>

<table class="table table-bordered table-striped" style="word-wrap: break-word; table-layout: fixed;">
        <thead>
            <tr>
                <th>No.</th>
                <th>Title</th>
                <th>Sub Menu</th>
                <th>Page Title</th>
                <th>Description</th>
                <th>Keywords</th>
                <th>Robots</th>
                <th>Canonical</th>
                <th>Content</th>
                <th>Insurance Policy</th>
                <th>Insurance Tabs</th>
                <th>About Image</th>
                <th>Service Entry Images</th>
                <th>Features Content</th>
                <th>Features List</th>
                <th>FAQs</th>
                <th>Actions</th>
            </tr>
        </thead>
        <tbody>
            <?php
            $query = "SELECT * FROM `solution`";
            $result = $conn->query($query);

if ($result->num_rows > 0) {
                $count = 0;
                while ($row = $result->fetch_assoc()) {
                    $count++;
                    $service_id = $row['id'];

$insuranceTabs = fetchData($conn, 'insurence_tab', $service_id);
                    $serviceImages = fetchData($conn, 'service_entry_images', $service_id);
                    $featuresList = fetchData($conn, 'service_features', $service_id);
                    $faqs = fetchData($conn, 'service_faqs', $service_id);
                    ?>
                    <tr>
                        <td><?= $count ?></td>
                        <td><?= htmlspecialchars($row['title']) ?></td>
                        <td><?= htmlspecialchars($row['submenu']) ?></td>
                        <td><?= htmlspecialchars($row['page_title']) ?></td>
                        <td style="max-width:250px;"><?= html_entity_decode($row['description']) ?></td>
                        <td><?= htmlspecialchars($row['keywords']) ?></td>
                        <td><?= htmlspecialchars($row['robots']) ?></td>
                        <td><?= htmlspecialchars($row['canonical']) ?></td>
                        <td style="max-width:250px;"><?= html_entity_decode($row['subtitle1']) ?></td>
                        <td><?= htmlspecialchars($row['insurence']) ?></td>

<td style="max-width:250px;">
                            <?php
                            if ($insuranceTabs->num_rows > 0) {
                                while ($tab = $insuranceTabs->fetch_assoc()) {
                                    echo "<strong>Q:</strong> " . htmlspecialchars($tab['question']) . "<br>";
                                    echo "<strong>A:</strong> " . htmlspecialchars($tab['answer']) . "<br><br>";
                                }
                            } else {
                                echo "No Insurance Tabs.";
                            }
                            ?>
                        </td>

<td>
                            <?php if (!empty($row['aboutimage'])): ?>
                                <img src="dataimg/<?= htmlspecialchars($row['aboutimage']) ?>" 
                                     style="max-height:150px; max-width:200px;" alt="About Image">
                            <?php else: ?>
                                No Image
                            <?php endif; ?>
                        </td>

<td style="max-width:250px;">
                            <?php
                            if ($serviceImages->num_rows > 0) {
                                while ($img = $serviceImages->fetch_assoc()) {
                                    echo '<img src="dataimg/' . htmlspecialchars($img['image']) . '" 
                                           style="max-height:100px; max-width:100px;" alt="Service Image"><br>';
                                    if (!empty($img['text'])) {
                                        echo "<em>" . htmlspecialchars($img['text']) . "</em><br>";
                                    }
                                }
                            } else {
                                echo "No Service Images.";
                            }
                            ?>
                        </td>

<td style="max-width:250px;"><?= html_entity_decode($row['features']) ?></td>

<td style="max-width:250px;">
                            <?php
                            if ($featuresList->num_rows > 0) {
                                while ($feature = $featuresList->fetch_assoc()) {
                                    echo '<img src="dataimg/' . htmlspecialchars($feature['image']) . '" 
                                           style="max-height:100px; max-width:100px;" alt="Feature Image"><br>';
                                    echo htmlspecialchars($feature['text']) . "<br><br>";
                                }
                            } else {
                                echo "No Features List.";
                            }
                            ?>
                        </td>

<td style="max-width:250px;">
                            <?php
                            if ($faqs->num_rows > 0) {
                                while ($faq = $faqs->fetch_assoc()) {
                                    echo "<strong>Q:</strong> " . htmlspecialchars($faq['question']) . "<br>";
                                    echo "<strong>A:</strong> " . htmlspecialchars($faq['answer']) . "<br><br>";
                                }
                            } else {
                                echo "No FAQs.";
                            }
                            ?>
                        </td>

<td>
                            <a class="btn btn-primary" href="solutionsform.php?sid=<?= $row['id']; ?>">Edit</a>
                            <a class="btn btn-danger" href="solutionsdelete.php?sid=<?= $row['id']; ?>" 
                               onclick="return confirm('Are you sure you want to delete this?');">Delete</a>
                        </td>
                    </tr>
                    <?php
                }
            } else {
                echo "<tr><td colspan='17' class='text-center'>No data found.</td></tr>";
            }
            ?>
        </tbody>
    </table>
</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 async defer src="https://buttons.github.io/buttons.js"></script>
  </body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: solutionsshow.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation