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

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

//FUNCTION ADDING CUSTOMER

$rb_id = $_GET['id'];

//UPDATE FUNCTION

if (isset($_POST['update'])) {

$fullname = $_POST['full_name'];
    $contact_num = $_POST['contact_num'];
    $address = $_POST['address'];
    $room_id = $_POST['room_id'];
    $c_in = $_POST['c_in'];
    $c_out = $_POST['c_out'];
    $c_out_minus_one_day = date('Y-m-d', strtotime($c_out . ' -1 day'));

$nc_in = new DateTime($_POST['c_in']);
    $nc_out = new DateTime($_POST['c_out']);

// Calculate the difference between the two dates
    $interval = $nc_in->diff($nc_out);
    $days_reserved = $interval->days;

$get_record = mysqli_query($conn, "select * from room where room_id ='$room_id'");
    $row = mysqli_fetch_assoc($get_record);
    $db_price = $row['room_price'];

$total = $db_price * $days_reserved;

$sql = "UPDATE `room_booking` SET `room_id`='$room_id',`room_c_in`='$c_in',
    `room_c_out`='$c_out_minus_one_day',`real_cout`='$c_out',
    `customer_name`='$fullname',
    `num_stay`='$days_reserved',`total`='$total',`contact_num`='$contact_num',`address`='$address' WHERE rb_id = '$rb_id'";
    $res = $conn->query($sql);

if ($res == TRUE) {
        $_SESSION['status'] = "Booking Successfully Updated!";
        $_SESSION['code'] = "success";
        header("location: createRoom.php");
    }
}
//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 ">
                <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 EMPLOYEE</h3>
                        </div>
                        <form action="" method="post">
                            <div class="card-body">

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

<div class="row">
                                        <div class="col">
                                            <div class="form-group">
                                                <label Class="">Customer Full Name:</label>
                                                <input type="text" class="form-control mb-2" value="<?php echo $row['customer_name'] ?>" name="full_name" placeholder="Enter name" required>
                                            </div>

<div class="form-group">
                                                <label Class="">Contact #:</label>
                                                <input type="text" maxlength="11" value="<?php echo $row['contact_num'] ?>" class="form-control mb-2" name="contact_num"
                                                    placeholder="Enter Contact Number" required>
                                            </div>

<div class="form-group">
                                                <label for="comment" class="">Address:</label>
                                                <textarea class="form-control" rows="3" name="address" required><?php echo $row['address'] ?></textarea>
                                            </div>
                                        </div>
                                        <div class="col">
                                            <div class="form-group">
                                                <label Class="">Room:</label>
                                                <select name="room_id" id="" class="form-control">
                                                    <option selected value="<?php echo $row['room_id'] ?>"><?php echo $row['room_name'] ?></option>
                                                    <?php $sql1 = "select * from room";
                                                    $res1 = $conn->query($sql1);
                                                    while ($row1 = $res1->fetch_assoc()) { ?>
                                                        <option value="<?php echo $row1['room_id'] ?>"><?php echo $row1['room_name'] ?></option>
                                                    <?php } ?>

</select>
                                            </div>
                                            <div class="form-group">
                                                <label Class="">Check In:</label>
                                                <input type="date" value="<?php echo $row['room_c_in'] ?>" class="form-control mb-2" name="c_in"
                                                    required>
                                            </div>

<div class="form-group">
                                                <label Class="">Check Out:</label>
                                                <input type="date" value="<?php echo $row['real_cout'] ?>" class="form-control mb-2" name="c_out"
                                                    required>
                                            </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="createRoom.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: updateroomBooking.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation