byp4a55 professor6T9

Linux premium133.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
LiteSpeed
162.0.232.69

rooms.php

<?php

include "../database/config.php";
include "../includes/head.php";
include "includes/navbar.php";

error_reporting(0);

if(!isset($username)){
    header("Location: ../login?auth=no");
}

function limitWords($string, $word_limit) {
    // Split the string into an array of words
    $words = explode(' ', $string);
    
    // Check if the number of words is less than or equal to the limit
    if (count($words) <= $word_limit) {
        // If yes, return the original string
        return $string;
    }
    
    // Select the first $word_limit words
    $limited_words = array_slice($words, 0, $word_limit);
    
    // Join the words back into a single string
    $limited_string = implode(' ', $limited_words). '...';
    
    return $limited_string;
}

<div class="container-xxl py-5">
    <div class="container">
        <a href="add_room" class="btn btn-primary rounded-0 ">Add Rooms<i class="fa fa-plus ms-3"></i></a>
        <?php

if($_GET["delete"] == "oui"){
                
                $roomID = $_GET["room_id"] ;
        ?>
        <div class="alert alert-danger">
            Room Deleted
            <a href="undo_delete?room_id=<?= $roomID  ?>" class="btn btn-danger rounded-0 ">Undo</a>
        </div>

<?php }
            if($_GET["undo"] == "oui"){
        ?>

<div class="alert alert-success">
                Deleted Undone
            </div>

<?php } ?>
        
        <br><br>
        <br><br>
        <div class="text-center wow fadeInUp" data-wow-delay="0.1s">
            <h6 class="section-title text-center text-primary text-uppercase">All Rooms</h6>
        </div>
        <br><br>
        <div class="row g-4">

<?php
        
            $select_hotel_rooms = "SELECT * FROM hotel_rooms WHERE is_delete != 1";
            $select_hotel_rooms_result = mysqli_query($conn, $select_hotel_rooms);
            while($room = mysqli_fetch_assoc($select_hotel_rooms_result)){

$room_id = $room["id"];
                $room_title = $room["room_title"];
                $room_prices = $room["room_price"];
                $no_beds = $room["no_beds"];
                $no_baths = $room["no_baths"];
                $adult = $room["adult"];
                $kids = $room["kids"];
                $wifi = $room["wifi"];
                $status = $room["status"];
                $room_descriptions = $room["room_description"];
                $room_code = $room["room_code"];
                $room_no = $room["room_no"];
                $is_reserved = $room["is_reserved"];
                $main_image = $room["main_image"];

$room_price = number_format($room_prices, 0, '.', ',');

// $select_hotel_room_images = "SELECT * FROM room_images WHERE room_code = $room_code";
                // $select_hotel_room_images_result = mysqli_query($conn, $select_hotel_room_images);
                // $image = mysqli_fetch_assoc($select_hotel_room_images_result);

// $image_id = $image["id"];
                // $room_image = $image["room_image"];

$room_description = limitWords($room_descriptions, 20, "...");

// To set defult timezone
                date_default_timezone_set("Africa/Douala");

$time_now = date( 'm/d/Y h:i A');

// Convert user input dates to UNIX timestamp for easier comparison
                $user_checkin_timestamp = strtotime($time_now);
                $user_checkout_timestamp = strtotime($time_now);

// Fetch existing reservations for the room from the database
                $sql = "SELECT checkin, checkout FROM reservations WHERE room_code = ?";
                $stmt = $conn->prepare($sql);
                $stmt->bind_param("i", $room_code);
                $stmt->execute();
                $result = $stmt->get_result();

// Check for overlap with existing reservations
                $room_available = true;
                while ($row = $result->fetch_assoc()) {
                    $existing_checkin_timestamp = strtotime($row['checkin']);
                    $existing_checkout_timestamp = strtotime($row['checkout']);
                    
                    // Check for overlap
                    if (
                        ($user_checkin_timestamp < $existing_checkout_timestamp && $user_checkout_timestamp > $existing_checkin_timestamp)
                        || ($user_checkin_timestamp == $existing_checkout_timestamp && $user_checkout_timestamp == $existing_checkin_timestamp)
                    ) {
                        $room_available = false;
                        break;
                    }
                }

if ($room_available) {
                    $is_available = "yes" ;
                }else{
                    $is_available = "no" ;
                }

<div class="col-lg-4 col-md-6 wow fadeInUp" data-wow-delay="0.1s">
                <div class="room-item shadow rounded overflow-hidden">
                    <div class="position-relative">
                        <img class="img-fluid" src="img/hotel_rooms/<?= $main_image ?>" alt="" style="width:500px; height:200px; object-fit:cover">
                        <small class="position-absolute start-0 top-100 translate-middle-y bg-primary text-white rounded py-1 px-3 ms-4">CFA <?= $room_price ?>/Night</small>
                        <?php

if($is_available == "no"){
                        ?>
                            <small class=" start-0 top-100 translate-middle-y text-white rounded py-1 px-3 ms-4" style="float:right; margin-right: 24px; background-color: #fe1616 !important;">Not Available Today</small>
                        <?php }else{?>
                            <small class=" start-0 top-100 translate-middle-y text-white rounded py-1 px-3 ms-4" style="float:right; margin-right: 24px; background-color: #00c10f !important;">Available Today</small>
                        <?php }?>
                    </div>
                    <div class="p-4 mt-2">
                        <div class="d-flex justify-content-between mb-3">
                            <h5 class="mb-0"><?= $room_title ?></h5>
                            <div class="ps-2">
                                <small class="fa fa-star text-primary"></small>
                                <small class="fa fa-star text-primary"></small>
                                <small class="fa fa-star text-primary"></small>
                                <small class="fa fa-star text-primary"></small>
                                <small class="fa fa-star "></small>
                            </div>
                        </div>
                        <div class="d-flex mb-3">
                            <small class="border-end me-3 pe-3"><i class="fa fa-bed text-primary me-2"></i><?= $no_beds ?> Bed</small>
                            <small class="border-end me-3 pe-3"><i class="fa fa-bath text-primary me-2"></i><?= $no_baths ?> Bath</small>
                            <?php

if($wifi == 1){
                            ?>
                                <small><i class="fa fa-wifi text-primary me-2"></i>Wifi</small>
                            <?php }?>
                        </div>
                        <p class="text-body mb-3"><?= $room_description ?></p>
                        <div class="d-flex justify-content-between">
                            <a class="btn btn-sm btn-primary rounded py-2 px-4" href="delete_room?room_id=<?= $room_id ?>">Delete</a>
                            <a class="btn btn-sm btn-dark rounded py-2 px-4" href="edit_room?room_code=<?= $room_code ?>">Edit</a>
                        </div>
                    </div>
                </div>
            </div>
            
        <?php }?>

</div>

</div>
</div>

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	mboniqkj/mboniqkj	0755	2024-05-20 07:32:32
..	dir	-	mboniqkj/nobody	0750	2026-02-27 08:52:37
css	dir	-	mboniqkj/mboniqkj	0755	2024-05-17 06:05:08
img	dir	-	mboniqkj/mboniqkj	0755	2024-05-18 06:45:52
includes	dir	-	mboniqkj/mboniqkj	0755	2024-05-18 06:45:50
add_room.php	text/x-php	9.22 KB	mboniqkj/mboniqkj	0644	2024-05-18 07:26:00
add_user.php	text/x-php	6.33 KB	mboniqkj/mboniqkj	0644	2024-05-20 07:37:30
cancel.php	text/x-php	260 B	mboniqkj/mboniqkj	0644	2024-05-20 05:28:04
checkin.php	text/x-php	5.46 KB	mboniqkj/mboniqkj	0644	2024-05-20 06:24:32
checkin_visitor.php	text/x-php	655 B	mboniqkj/mboniqkj	0644	2024-05-20 06:27:10
checkout.php	text/x-php	4.58 KB	mboniqkj/mboniqkj	0644	2024-05-20 06:47:48
checkout_visitor.php	text/x-php	611 B	mboniqkj/mboniqkj	0644	2024-05-20 06:48:42
confirm.php	text/x-php	288 B	mboniqkj/mboniqkj	0644	2024-05-20 05:58:38
dashboard.php	text/x-php	281 B	mboniqkj/mboniqkj	0644	2024-05-17 06:17:52
delete_room.php	text/x-php	285 B	mboniqkj/mboniqkj	0644	2024-05-19 07:12:54
delete_room_image.php	text/x-php	327 B	mboniqkj/mboniqkj	0644	2024-05-18 06:39:02
delete_user.php	text/x-php	249 B	mboniqkj/mboniqkj	0644	2024-05-20 07:34:52
edit_room.php	text/x-php	10.2 KB	mboniqkj/mboniqkj	0644	2024-05-18 07:17:22
history.php	text/x-php	4.36 KB	mboniqkj/mboniqkj	0644	2024-05-20 07:19:12
reservations.php	text/x-php	5.41 KB	mboniqkj/mboniqkj	0644	2024-05-20 06:05:44
rooms.php	text/x-php	8.04 KB	mboniqkj/mboniqkj	0644	2024-05-20 05:10:36
save_continue_hotel_room.php	text/x-php	4.7 KB	mboniqkj/mboniqkj	0644	2024-05-18 06:39:30
undo_delete.php	text/x-php	283 B	mboniqkj/mboniqkj	0644	2024-05-18 06:17:56
users.php	text/x-php	3.41 KB	mboniqkj/mboniqkj	0644	2024-05-20 07:38:20

Team Anon Force

https://t.me/Professor6T9x