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/admin/room

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: calendar_show.php

<?php
// Database connection
include('user.php');

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Fetch bookings for all rooms
$sql = "
    SELECT r.room_id, r.room_name, b.room_c_in, b.room_c_out
    FROM room_booking b
    JOIN room r ON r.room_id = b.room_id ORDER BY r.room_id ASC
";

$result = $conn->query($sql);
$rooms = [];

while ($row = $result->fetch_assoc()) {
    $roomId = $row['room_id'];
    $roomName = $row['room_name'];
    $start = new DateTime($row['room_c_in']);
    $end = new DateTime($row['room_c_out']);
    $start->modify('-1 day');
    $end->modify('-1 day');
    // Initialize room entry if not set
    if (!isset($rooms[$roomId])) {
        $rooms[$roomId] = [
            'name' => $roomName,
            'booked_dates' => []
        ];
    }

// Add all dates in the range to booked_dates
    while ($start <= $end) { // Exclude the end date
        $rooms[$roomId]['booked_dates'][] = $start->format('Y-m-d');
        $start->modify('+1 day');
    }
}

// Return JSON response
header('Content-Type: application/json');
echo json_encode($rooms);
exit;

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: calendar_show.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation