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: updateRoom.php

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

//FUNCTION ADDING CUSTOMER

//UPDATE FUNCTION

if (isset($_GET['id'])) {
    $room_id = $_GET['id'];

// Database connection

// Get current room details from the database
    $sql = "SELECT * FROM room INNER JOIN room_images ON room.room_id = room_images.room_id WHERE room.room_id = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $room_id);
    $stmt->execute();
    $result = $stmt->get_result();
    $room = $result->fetch_assoc();

if (!$room) {
        die("Room not found!");
    } else {
        // Continue processing
    }
    $current_image = $room['image_path']; // Store the current image path for later removal if necessary
}

if (isset($_POST['update'])) {
    // Collect the 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 (multiple images)
    if (isset($_FILES['event_img']) && $_FILES['event_img']['error'][0] === UPLOAD_ERR_OK) {
        // Step 1: Delete existing images associated with the room (both in DB and in folder)
        $sql_delete_images = "SELECT `image_path` FROM `room_images` WHERE `room_id` = ?";
        $stmt_delete = $conn->prepare($sql_delete_images);
        $stmt_delete->bind_param("i", $room_id);
        $stmt_delete->execute();
        $result = $stmt_delete->get_result();
        $old_images = $result->fetch_all(MYSQLI_ASSOC);

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

// Now delete the records from the room_images table
        $sql_delete_images = "DELETE FROM `room_images` WHERE `room_id` = ?";
        $stmt_delete = $conn->prepare($sql_delete_images);
        $stmt_delete->bind_param("i", $room_id);
        $stmt_delete->execute();
        $stmt_delete->close();

// Step 2: Upload new images
        $imagePaths = [];
        $files = $_FILES['event_img'];
        $totalFiles = count($files['name']);
        $featuredImagePath = '';  // To store the path of the featured image

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

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

// 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)) {
                    $imagePaths[] = $targetFile;
                    // Set the first image as the featured image
                    if ($i == 0) {
                        $featuredImagePath = $targetFile;  // Store the path of the first image
                    }
                } else {
                    $_SESSION['status'] = "Error uploading image.";
                    $_SESSION['code'] = "error";
                    header("Location: rooms_page.php");
                    exit();
                }
            } else {
                $_SESSION['status'] = "Invalid file type. Only JPG, JPEG, and PNG are allowed.";
                $_SESSION['code'] = "error";
                header("Location: rooms_page.php");
                exit();
            }
        }

// Step 3: Insert new image paths into the room_images table
        foreach ($imagePaths as $imagePath) {
            $sql_insert_image = "INSERT INTO `room_images` (`room_id`, `image_path`, `featured`) VALUES (?, ?, ?)";
            // If the image is the featured image, set `featured` to 1, else 0
            $featured = ($imagePath === $featuredImagePath) ? 1 : 0;
            $stmt_insert = $conn->prepare($sql_insert_image);
            $stmt_insert->bind_param("isi", $room_id, $imagePath, $featured);
            $stmt_insert->execute();
            $stmt_insert->close();
        }
    }

// Step 4: Update room details in the room table
    $sql = "UPDATE `room` SET `room_name` = ?, `room_description` = ?, `capacity` = ?, `bed_num` = ?, `bed_description` = ?, `room_price` = ?, `room_type` = ? WHERE `room_id` = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("ssiisssi", $room_name, $room_description, $capacity, $bed_num, $bed, $room_price, $room_type, $room_id);

if ($stmt->execute()) {
        $_SESSION['status'] = "Room successfully updated!";
        $_SESSION['code'] = "success";
    } else {
        $_SESSION['status'] = "Error updating room: " . $stmt->error;
        $_SESSION['code'] = "error";
    }

$stmt->close();
    $conn->close();

// Redirect back to the rooms page
    header("Location: manageRoom.php");
    exit();
}

<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 bg-light">

<div class="row justify-content-center">
                <div class="col-lg-8">
                    <div class="card">
                        <div class="card-header bg-lightblue">
                            <h3 class="card-title font-weight-bold mt-1 text-white">UPDATE ROOM</h3>
                        </div>
                        <form action="" method="post" enctype="multipart/form-data">
                            <div class="card-body">

<?php
                                $sql2 = "select * from room where room_id = '$room_id'";
                                $res2 = $conn->query($sql2);
                                while ($row = $res2->fetch_assoc()) {
                                ?>

<div class="row">
                                        <div class="col">
                                            <div class="form-group">
                                                <label for="comment" class="">Room Name:</label>
                                                <input type="text" class="form-control" value="<?php echo $row['room_name'] ?>" name="room_name" placeholder="Enter Room Name" required>
                                            </div>

<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"><?php echo $row['room_description'] ?></textarea>
                                            </div>

<div class="form-group">
                                                <label Class="">Capacity:</label>
                                                <select name="capacity" id="" class="form-control" required>
                                                    <option selected value="<?php echo $row['capacity'] ?>"><?php echo $row['capacity'] ?> Pax</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 selected value="<?php echo $row['bed_num'] ?>"><?php echo $row['bed_num'] ?> Beds</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 selected value="<?php echo $row['bed_description'] ?>"><?php echo $row['bed_description'] ?></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" value="<?php echo $row['room_price'] ?>" name="room_price" placeholder="Enter Room Price" required>
                                            </div>

<div class="form-group">
                                                <label for="comment" class="">Room Type:</label>
                                                <select name="room_type" id="" class="form-control" required>
                                                    <option selected value="<?php echo $row['room_type'] ?>"><?php echo $row['room_type'] ?></option>
                                                    <option value="Hotel">Hotel</option>
                                                    <option value="Villa">Villa</option>
                                                </select>
                                            </div>

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

<label class="">Images:</label><br>
                                            <div class="row">
                                                <?php
                                                $sql4 = "select * from room_images where room_id = '$room_id'";
                                                $res4 = $conn->query($sql4);
                                                while ($row4 = $res4->fetch_assoc()) {
                                                ?>

<?php } ?>

</div>
                                            <div class="col">
                                                <small>Note: Click the image your desire to be featured.</small>
                                            </div>
                                            <div class="row">
                                                <?php if (isset($_SESSION['featured'])) { ?>
                                                    <div class="col">
                                                        <div class="alert alert-success alert-dismissible">
                                                            <button type="button" class="close" data-dismiss="alert">&times;</button>
                                                            <strong>Success!</strong> <?php echo $_SESSION['featured'] ?>.
                                                        </div>
                                                    </div>
                                                <?php } ?>
                                            </div>

</div>
                                    </div>

<?php } ?>

</div>
                            <div class="card-footer">
                                <button type="submit" name="update"
                                    class="btn btn-primary mt-2 float-right">Update</button>
                                <a href="manageRoom.php">
                                    <input type="button" class="btn btn-danger mt-2 float-right mr-3"
                                        value="Cancel"></a>
                            </div>
                            
                        </form>
                    </div>
                </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>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: updateRoom.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation