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:

u612101220

Directory:

/home/u612101220/domains/silverconchawavepoolresortandhotel.com/public_html

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: accommodation.php

<?php
session_start();

if (isset($_SESSION['query'])) {
    $checkin = $_SESSION['checkin-date'];
    $checkout = $_SESSION['checkout-date'];
    $room = $_SESSION['room'];
    $adults = $_SESSION['adults'];
    $children = $_SESSION['children'];
}

include('config.php');
include('user.php');
?>

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

<title>Silverconcha Wavepool Resort</title>

<link rel="icon" href="./img/core-img/logo2.png">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.2.0/css/all.min.css">

<link rel="stylesheet" href="style.css">

form select.form-control {
            width: 100% !important;
            /* Ensure it takes full width */
            display: block !important;
            /* Forces block-level styling */
            padding: 10px;
            /* Adjust padding for better visibility */
        }
    </style>
</head>

<header class="header-area">

<div class="top-header-area" style="background-color:rgb(59, 115, 237);">
            <div class="container">
                <div class="row">

<div class="col-8">
                        <div class="top-header-content">
                            <a href="#"><i class="icon_phone"></i> <span>(+63) 916-638-85747</span></a>
                            <a href="#"><i class="icon_mail"></i> <span>info@silverconchawavepoolresortandhotel.com</span></a>
                        </div>
                    </div>

</div>
            </div>
        </div>

<div class="main-header-area">
            <div class="classy-nav-container breakpoint-off">
                <div class="container">
                    
                    <nav class="classy-navbar justify-content-between" id="robertoNav">

<a class="nav-brand img-fluid " href="index.php"><img src="./img/core-img/logo.png" loading="lazy" style="height: 60px; width: auto;"></a>
                        
                        <div class="classy-navbar-toggler">
                            <span class="navbarToggler"><span></span><span></span><span></span></span>
                        </div>

<div class="classy-menu">
                            
                            <div class="classycloseIcon">
                                <div class="cross-wrap"><span class="top"></span><span class="bottom"></span></div>
                            </div>
                            
                            <div class="classynav pr-5">
                                <ul id="nav">
                                    <li><a href="index">Home</a></li>
                                    <li class="activeLink fw-bold"><a href="accommodation">Accommodation</a></li>
                                    <li><a href="amenities">Amenities</a></li>
                                    <li><a href="#">Pages</a>
                                        <ul class="dropdown">
                                            <li><a href="dining.php"><i class="fa-solid fa-plate-wheat mr-2"></i> Dining</a></li>
                                            <li><a href="event_hall"><i class="fa-solid fa-landmark-dome mr-2"></i> Event Hall</a></li>
                                            <li><a href="event_news"><i class="fa-solid fa-newspaper mr-2"></i> News & Events </a></li>
                                            
                                            <li><a href="faqs"><i class="fa-solid fa-clipboard-question mr-2"></i> FAQs</a></li>
                                        </ul>
                                    </li>
                                    <li class=""><a href="contact_us">Contact Us</a></li>
                                    <?php if (!isset($_SESSION['customer_id'])) { ?>
                                        <li><a href="login" class="btn text-white" style="background-color: #1076b4;"><i class="fa-solid fa-right-to-bracket"></i> Login</a></li>
                                        <li><a href="register" class="btn text-white" style="background-color: #1abc9c;"><i class="fa-solid fa-user"></i> Register</a></li>
                                    <?php } else { ?>
                                        <li>
                                            <a href="#" class="font-weight-bold">
                                                <img src="img/user.png" alt="User Avatar" style="width: 30px; height: 30px; border-radius: 50%; margin-right: 8px;">
                                                <?php echo $db_name ?>
                                            </a>
                                            <ul class="dropdown">

<li><a href="#"><i class="fa-solid fa-calendar-days mr-2"></i> Hotel Reservation</a>
                                                    <ul class="dropdown">
                                                        <li><a href="roomPending"><i class="fa-solid fa-clock-rotate-left mr-2"></i> Pending</a></li>
                                                        <li><a href="roomApproved"><i class="fa-solid fa-circle-check mr-2"></i> Approved</a></li>
                                                        <li><a href="roomDeclined"><i class="fa-solid fa-circle-xmark mr-2"></i> Declined</a></li>
                                                    </ul>
                                                </li>
                                                <li><a href="account"><i class="fa-solid fa-user mr-2"></i> Profile</a></li>
                                                <li><a href="logout"><i class="fa-solid fa-arrow-right-from-bracket mr-1"></i> Log Out</a></li>
                                            </ul>
                                        </li>
                                    <?php } ?>

</ul>

</div>
                            
                        </div>
                    </nav>
                </div>
            </div>
        </div>
    </header>

<div class="breadcrumb-area bg-img bg-overlay jarallax" style="background-image: url(img/bg-img/108.jpg);">
        <div class="container h-100">
            <div class="row h-100 align-items-center">
                <div class="col-12">
                    <div class="breadcrumb-content text-center">
                        <h2 class="page-title">Our Accommodation</h2>
                        <nav aria-label="breadcrumb">
                            <ol class="breadcrumb justify-content-center">
                                <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                                <li class="breadcrumb-item active" aria-current="page">Accommodation</li>
                            </ol>
                        </nav>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
    <div class="container mt-5">
        <div class="row">
            <div class="col-lg-12">
                <form action="" method="GET">
                    
                    <div class="row">
                        <div class="col-md-10">
                            <div class="form-group">
                                <label for="room_type" class="text-secondary"><small><strong>Room Type:</strong></small></label>
                                <select name="room_type" class="form-control" style="width: 100%; display: block;">
                                    <option value="">All Types</option>
                                    <option value="Hotel" <?php echo isset($_GET['room_type']) && $_GET['room_type'] == 'Hotel' ? 'selected' : ''; ?>>Hotel</option>
                                    <option value="Villa" <?php echo isset($_GET['room_type']) && $_GET['room_type'] == 'Villa' ? 'selected' : ''; ?>>Villa</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-md-2">

<button type="submit" class="btn btn-block float-right text-white" style="margin-top: 31px; background-color: #330099;"><i class="fa-solid fa-filter"></i> Apply Filter</button>
                        </div>
                    </div>
                </form>
            </div>
        </div>
    </div>

<div class="row">
                <?php
                $rooms_per_page = 9;  // Number of rooms per page
                $page = isset($_GET['page']) ? (int)$_GET['page'] : 1;  // Get current page or default to 1

// Get the room_type filter from GET request
                $room_type_filter = isset($_GET['room_type']) ? $_GET['room_type'] : '';

// Calculate OFFSET
                $offset = ($page - 1) * $rooms_per_page;

// Modify SQL query to include the room_type filter
                $sql = "SELECT * from room, room_images WHERE room.room_id = room_images.room_id AND room_images.featured = 1";

// If room type filter is set, add it to the query
                if ($room_type_filter) {
                    $sql .= " AND room.room_type = '$room_type_filter'";
                }

// Add pagination with LIMIT and OFFSET
                $sql .= " LIMIT $rooms_per_page OFFSET $offset";

$res = $conn->query($sql);

// Display rooms
                while ($row = $res->fetch_assoc()) {
                    $image = $row['image_path'];
                    $newimage = substr($image, 3);
                ?>
                    <div class="col-12 col-lg-6">
                        <div class="single-room-area d-flex align-items-center mb-50 wow fadeInUp room" data-room-id="1">
                            <div class="room-thumbnail">
                                <img src="admin/<?php echo $newimage ?>" loading="lazy" alt="" style="height: 300px; width: 100%;">
                            </div>
                            <div class="room-content">
                                <h2><?php echo $row['room_name'] ?></h2>
                                <h4>₱ <?php echo number_format($row['room_price'], 2) ?> <span>/ Day</span></h4>
                                <div class="room-feature">
                                    <h6>No. of Bed: <span><?php echo $row['bed_num'] ?></span></h6>
                                    <h6>Capacity: <span><?php echo $row['capacity'] ?></span></h6>
                                    <h6>Bed: <span><?php echo $row['bed_description'] ?></span></h6>
                                    <h6>Services: <span>Wifi, television ...</span></h6>
                                </div>
                                <a href="view_room.php?id=<?php echo $row['room_id'] ?>" class="btn roberto-btn2 py-2 text-white btn-1" style="background-color: #1076b4;">View Details <i class="fa fa-long-arrow-right" aria-hidden="true"></i></a>
                            </div>
                        </div>
                    </div>
                <?php } ?>

</div>

<div class="row">
                    
                    <div class="col float-right">
                        <nav class="roberto-pagination wow fadeInUp mb-100 float-right" >
                            <ul class="pagination">
                                <?php
                                // Get total number of rooms to calculate total pages
                                $total_res = $conn->query("SELECT COUNT(*) AS total FROM room");
                                $total_row = $total_res->fetch_assoc();
                                $total_rooms = $total_row['total'];
                                $total_pages = ceil($total_rooms / $rooms_per_page);  // Calculate total pages

// Pagination Buttons
                                $prev_page = $page - 1;
                                $next_page = $page + 1;

if ($page > 1) {
                                    echo "<li class='page-item'><a class='page-link' href='?page=$prev_page'>Previous</a></li>";
                                }

for ($i = 1; $i <= $total_pages; $i++) {
                                    echo "<li class='page-item " . ($i == $page ? 'active' : '') . "'><a class='page-link' href='?page=$i'>$i</a></li>";
                                }

if ($page < $total_pages) {
                                    echo "<li class='page-item'><a class='page-link' href='?page=$next_page'>Next <i class='fa fa-angle-right'></i></a></li>";
                                }
                                ?>
                            </ul>
                        </nav>
                    </div>
                </div>

</div>
    </div>

<span class="text-white text-center">(+639) 916-638-85747</span>
                            <span class="text-white "><small>info@silverconchawavepoolresortandhotel.com</small></span>
                            <span class="text-white">Sitio Pugo, Malimpec, Bayambang, Pangasinan, Philippines.</span>
                        </div>
                    </div>

<div class="col-12 col-sm-6 col-lg-3">
                        <div class="single-footer-widget mb-80">
                            
                            <h5 class="widget-title">Our Events</h5>

<?php
                            $sql1 = "SELECT * FROM event ORDER BY event_date DESC LIMIT 2";
                            $res2 = $conn->query($sql1);
                            while ($row2 = $res2->fetch_assoc()) {

?>
                                
                                <div class="latest-blog-area">
                                    <a href="#" class="post-title"><?php echo $row2['event_name']; ?></a>
                                    <span class="post-date"><i class="fa fa-clock-o" aria-hidden="true"></i> <?php echo date('M d, Y', strtotime($row2['event_date'])); ?></span>
                                </div>
                            <?php } ?>

</div>
                    </div>

<div class="col-12 col-sm-4 col-lg-2">
                        <div class="single-footer-widget mb-80">
                            
                            <h5 class="widget-title">Links</h5>

<ul class="footer-nav">
                                <ul class="footer-nav">
                                    <li><a href="contact_us"><i class="fa fa-caret-right" aria-hidden="true"></i> Contact Us</a></li>
                                    <li><a href="accommodation"><i class="fa fa-caret-right" aria-hidden="true"></i> Our Room</a></li>
                                    <li><a href="#"><i class="fa fa-caret-right" aria-hidden="true"></i> Career</a></li>
                                    <li><a href="faqs"><i class="fa fa-caret-right" aria-hidden="true"></i> FAQs</a></li>
                                </ul>
                            </ul>
                        </div>
                    </div>

<div class="col-12 col-sm-8 col-lg-4">
                        <div class="single-footer-widget mb-80">
                            
                            <h5 class="widget-title">Subscribe Newsletter</h5>
                            <span>Subscribe our newsletter gor get notification about new updates.</span>

<form action="index" class="nl-form">
                                <input type="email" class="form-control" placeholder="Enter your email...">
                                <button type="submit"><i class="fa fa-paper-plane" aria-hidden="true"></i></button>
                            </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>

<div class="container">
            <div class="copywrite-content">
                <div class="row align-items-center">
                    <div class="col-12 col-md-8">

<div class="copywrite-text ">
                            <p class="text-white">
                                Copyright &copy;<script>
                                    document.write(new Date().getFullYear());
                                </script> All rights reserved | Silverconcha Wavepool Resort and Hotel.
                        </div>
                    </div>
                    <div class="col-12 col-md-4">
                        <div class="social-info text-white">
                            <a href="https://www.facebook.com/pospangasinan" class="">
                                <p class="text-info"><small>Powered by: <span class="text-white">ESG IT-Solutions</span></small></p>
                            </a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </footer>

<script src="js/jquery.min.js"></script>
    
    <script src="js/popper.min.js"></script>
    
    <script src="js/bootstrap.min.js"></script>
    
    <script src="js/roberto.bundle.js"></script>
    
    <script src="js/default-assets/active.js"></script>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: accommodation.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation