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/pos

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: fetch_extend.php

<?php

include('../controller/config.php');

header('Content-Type: application/json');

// Check if the 'category_id' GET parameter is set
if (isset($_GET['category_id']) && isset($_GET['date']) && isset($_GET['tour'])) {
    $category_id = $_GET['category_id'];
    $date = $_GET['date'];  // The selected date
    $tour = $_GET['tour'];  // The selected tour (Day/Night)

// Prepare the query to fetch cottages based on the category ID, excluding those already reserved
    $sql = "
        SELECT * FROM cottage 
        WHERE c_cat_id = ? 
        AND cottage_id NOT IN (
            SELECT cottage_id FROM cottage_reservation 
            WHERE c_r_date = ? 
            AND tour = ?
        )
    ";

// Prepare the statement and bind the parameters
    $stmt = $conn->prepare($sql);
    $stmt->bind_param('iss', $category_id, $date, $tour);  // 'i' for integer, 's' for string
    $stmt->execute();
    $result = $stmt->get_result();

// Check if there are cottages and prepare the response
    $cottages = [];
    while ($row = $result->fetch_assoc()) {
        $cottages[] = $row; // Add each available cottage to the array
    }

// Return the available cottages as a JSON response
    echo json_encode($cottages);
} else {
    // If category_id, date, or tour is not provided, return an empty array
    echo json_encode([]);
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: fetch_extend.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation