Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache/2

System:

Linux 5.15.0-161-generic

PHP Version:

8.1.32

User:

myvacationholi

Directory:

/home/myvacationholi/public_html/admin

Free Space:

14 GB

🔧 Quick Actions

✏️ Editing: all-hotels.php

<?php
include 'config.php';

// Check if 'id' is passed in the URL for deletion
if (isset($_GET['delete_id'])) {
    $id = intval($_GET['delete_id']); // Get the ID of the hotel to delete

// Delete the hotel from the database
    $deleteQuery = "DELETE FROM hotels WHERE id = ?";
    $deleteStmt = $conn->prepare($deleteQuery);
    $deleteStmt->bind_param('i', $id);

if ($deleteStmt->execute()) {
        echo "<script>alert('Hotel deleted successfully!'); window.location.href='all-hotels.php';</script>";
    } else {
        echo "<script>alert('Error deleting hotel. Please try again.'); window.location.href='all-hotels.php';</script>";
    }
}

// Fetch all hotels from the database
$query = "SELECT h.id, h.name, h.location, h.price, h.image_path, h.inclusion, h.exclusion, h.hotel_images, c.name AS category_name 
          FROM hotels h
          JOIN hotel_categories c ON h.cat_id = c.id";
$result = $conn->query($query);
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>All Hotels</title>

<link href="https://fonts.googleapis.com/css?family=Ubuntu:400,500,700" rel="stylesheet">

<link rel="stylesheet" type="text/css" href="assets/icon/themify-icons/themify-icons.css">

<link rel="stylesheet" type="text/css" href="assets/icon/icofont/css/icofont.css">

<link rel="stylesheet" type="text/css" href="assets/plugins/bootstrap/css/bootstrap.min.css">

<link rel="stylesheet" type="text/css" href="assets/css/main.css">

<link rel="stylesheet" type="text/css" href="assets/css/responsive.css">
</head>

<div class="content-wrapper">
            <div class="container-fluid">
                <div class="row">
                    <div class="main-header">
                        <h4>All Hotels</h4>
                        <a href="add_hotel.php" class="btn btn-primary btn-sm">Add New Hotel</a>
                    </div>
                </div>

<div class="row">
                    <div class="col-sm-12">
                        <div class="card">
                            <div class="card-header">
                                <h5>Hotel Listings</h5>
                            </div>
                            <div class="card-block">
                                <div class="table-responsive">
                                    <table class="table table-bordered table-striped">
                                        <thead>
                                            <tr>
                                                <th>#</th>
                                                <th>Image</th>
                                                <th>Hotel Name</th>
                                                <th>Category</th>
                                                <th>Location</th>
                                                <th>Price</th>
                                                <th>Inclusions</th>
                                                <th>Exclusions</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            if ($result->num_rows > 0) {
                                                $index = 1;
                                                while ($row = $result->fetch_assoc()) {
                                                    // Decode JSON for hotel images
                                                    $hotel_images = json_decode($row['hotel_images'], true);
                                                    $hotel_image_display = !empty($hotel_images) ? $hotel_images[0] : $row['image_path'];

echo "<tr>";
                                                    echo "<td>" . $index++ . "</td>";
                                                    echo "<td><img src='{$hotel_image_display}' alt='Hotel Image' style='width: 80px; height: 80px;'></td>";
                                                    echo "<td>" . $row['name'] . "</td>";
                                                    echo "<td>" . $row['category_name'] . "</td>";
                                                    echo "<td>" . $row['location'] . "</td>";
                                                    echo "<td>$" . $row['price'] . "</td>";
                                                    echo "<td>" . substr(strip_tags($row['inclusion']), 0, 50) . "...</td>";
                                                    echo "<td>" . substr(strip_tags($row['exclusion']), 0, 50) . "...</td>";
                                                    echo "<td>
                                                          <a href='edit_hotel.php?id=" . $row['id'] . "' class='btn btn-primary btn-sm'>
                                                              <i class='icofont icofont-edit'></i> Edit
                                                          </a>
                                                          <a href='all-hotels.php?delete_id=" . $row['id'] . "' class='btn btn-danger btn-sm' onclick='return confirm(\"Are you sure you want to delete this hotel?\");'>
                                                              <i class='icofont icofont-trash'></i> Delete
                                                          </a>
                                                      </td>";
                                                    echo "</tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='9'>No hotels found</td></tr>";
                                            }
                                            ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
   
    <script src="assets/plugins/Jquery/dist/jquery.min.js"></script>
    <script src="assets/plugins/jquery-ui/jquery-ui.min.js"></script>
    <script src="assets/plugins/tether/dist/js/tether.min.js"></script>

<script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>

<script src="assets/plugins/jquery-slimscroll/jquery.slimscroll.js"></script>
    <script src="assets/plugins/jquery.nicescroll/jquery.nicescroll.min.js"></script>

<script src="assets/plugins/classie/classie.js"></script>

<script type="text/javascript" src="assets/js/main.min.js"></script>
    <script type="text/javascript" src="assets/pages/dashboard.js"></script>
    <script src="assets/js/menu.min.js"></script>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: all-hotels.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation