Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache/2

System:

Linux 5.15.0-161-generic

PHP Version:

8.1.32

User:

myvacationholi

Directory:

/home/myvacationholi/domains/myvacationholidays.in/private_html/admin

Free Space:

14.04 GB

🔧 Quick Actions

✏️ Editing: mice-services.php

<?php
include 'config.php';

// Function to create URL-friendly slug
function createSlug($string) {
    $slug = strtolower(trim($string));
    $slug = preg_replace('/[^a-z0-9-]/', '-', $slug); // replace non-alphanumeric
    $slug = preg_replace('/-+/', '-', $slug);         // remove multiple dashes
    return rtrim($slug, '-');
}

// Handle delete
if (isset($_GET['delete_id'])) {
    $delete_id = intval($_GET['delete_id']);
    $deleteQuery = "DELETE FROM mice_services WHERE id = ?";
    $deleteStmt = $conn->prepare($deleteQuery);
    $deleteStmt->bind_param('i', $delete_id);

if ($deleteStmt->execute()) {
        echo "<script>alert('Service deleted successfully!'); window.location.href='services_page.php';</script>";
    } else {
        echo "<script>alert('Error deleting service.'); window.location.href='services_page.php';</script>";
    }
}

// Fetch service data if editing
$service = null;
if (isset($_GET['edit_id'])) {
    $edit_id = intval($_GET['edit_id']);
    $editQuery = "SELECT * FROM mice_services WHERE id = ?";
    $editStmt = $conn->prepare($editQuery);
    $editStmt->bind_param('i', $edit_id);
    $editStmt->execute();
    $service = $editStmt->get_result()->fetch_assoc();
}

// Handle form submission for adding or updating
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $category_name = $_POST['category_name'] ?? '';
    $image = $_FILES['image'];
    $url = createSlug($category_name);

// If editing, update existing service
    if (isset($_POST['edit_id'])) {
        $edit_id = intval($_POST['edit_id']);
        $updateQuery = "UPDATE mice_services SET category = ?, url = ?";

// Check if image is uploaded
        if ($image['error'] === 0) {
            $target_dir = "image-of-tours/galleryimg/";
            $imageName = time() . '-' . preg_replace('/[^a-zA-Z0-9\._-]/', '', basename($image['name']));
            $target_path = $target_dir . $imageName;

if (move_uploaded_file($image['tmp_name'], $target_path)) {
                $updateQuery .= ", image = ?";
                $stmt = $conn->prepare($updateQuery);
                $stmt->bind_param('sss', $category_name, $url, $imageName);
            } else {
                $error = "Failed to upload the image.";
            }
        } else {
            $stmt = $conn->prepare($updateQuery);
            $stmt->bind_param('ss', $category_name, $url);
        }

$stmt->execute();
        if ($stmt->affected_rows > 0) {
            $success = 'Service updated successfully!';
        } else {
            $error = 'Error updating service.';
        }
    } else {
        // If adding a new service
        if ($image['error'] === 0) {
            $target_dir = "image-of-tours/galleryimg/";
            $imageName = time() . '-' . preg_replace('/[^a-zA-Z0-9\._-]/', '', basename($image['name']));
            $target_path = $target_dir . $imageName;

if (move_uploaded_file($image['tmp_name'], $target_path)) {
                $query = "INSERT INTO mice_services (category, image, url) VALUES (?, ?, ?)";
                $stmt = $conn->prepare($query);

if ($stmt) {
                    $stmt->bind_param('sss', $category_name, $imageName, $url);

if ($stmt->execute()) {
                        $success = "MICE Service added successfully!";
                    } else {
                        $error = "Error executing statement: " . $stmt->error;
                    }

$stmt->close();
                } else {
                    $error = "Error preparing statement: " . $conn->error;
                }
            } else {
                $error = "Failed to move uploaded image.";
            }
        } else {
            $error = "Error uploading image: " . $image['error'];
        }
    }
}

// Fetch all services
$query = "SELECT * FROM mice_services";
$result = $conn->query($query);
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title> Mice Services</title>
    <link href="https://fonts.googleapis.com/css?family=Ubuntu:400,500,700" rel="stylesheet">
    <link rel="stylesheet" type="text/css" href="assets/icon/themify-icons/themify-icons.css">
    <link rel="stylesheet" type="text/css" href="assets/icon/icofont/css/icofont.css">
    <link rel="stylesheet" type="text/css" href="assets/icon/simple-line-icons/css/simple-line-icons.css">
    <link rel="stylesheet" type="text/css" href="assets/plugins/bootstrap/css/bootstrap.min.css">
    <link rel="stylesheet" type="text/css" href="assets/css/main.css">
    <link rel="stylesheet" type="text/css" href="assets/css/responsive.css">
</head>

<div class="content-wrapper">
            <div class="container-fluid">
                <div class="row">
                    <div class="main-header">
                        <h4>All MICE Services</h4>
                    </div>
                </div>

<div class="row">
                    <div class="col-sm-12">
                        <div class="card">
                            <div class="card-header">
                                <h5>Manage MICE Services</h5>
                            </div>
                            <div class="card-block">
                                
                                <?php if (isset($success)): ?>
                                    <div class="alert alert-success"><?= $success ?></div>
                                <?php elseif (isset($error)): ?>
                                    <div class="alert alert-danger"><?= $error ?></div>
                                <?php endif; ?>

<form method="POST" action="" enctype="multipart/form-data">
                                    <div class="form-group">
                                        <label for="category_name">Service Name</label>
                                        <input type="text" class="form-control" id="category_name" name="category_name" value="<?= $service['category'] ?? '' ?>" placeholder="Enter service name" required>
                                    </div>

<div class="form-group">
                                        <label for="image">Service Image</label>
                                        <input type="file" class="form-control" id="image" name="image" accept="image/*">
                                        <?php if (isset($service['image'])): ?>
                                            <img src="image-of-tours/galleryimg/<?= $service['image']; ?>" width="100" class="mt-2">
                                        <?php endif; ?>
                                    </div>

<?php if (isset($service['id'])): ?>
                                        <input type="hidden" name="edit_id" value="<?= $service['id']; ?>">
                                    <?php endif; ?>

<button type="submit" class="btn btn-success"><?= isset($service['id']) ? 'Update Service' : 'Add Service' ?></button>
                                    <a href="services_page.php" class="btn btn-secondary">Cancel</a>
                                </form>

<div class="table-responsive mt-4">
                                    <table class="table table-bordered table-striped">
                                        <thead>
                                            <tr>
                                                <th>#</th>
                                                <th>Service Name</th>
                                                <th>Image</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if ($result->num_rows > 0): ?>
                                                <?php $count = 1; ?>
                                                <?php while ($row = $result->fetch_assoc()): ?>
                                                    <tr>
                                                        <td><?= $count++ ?></td>
                                                        <td><?= htmlspecialchars($row['category']) ?></td>
                                                        <td><img src="image-of-tours/galleryimg/<?= htmlspecialchars($row['image']) ?>" width="100"></td>
                                                        <td>
                                                            <a href="mice-services.php?edit_id=<?= $row['id'] ?>" class="btn btn-primary btn-sm"><i class="icofont icofont-edit"></i> Edit</a>
                                                            <a href="mice-services.php?delete_id=<?= $row['id'] ?>" class="btn btn-danger btn-sm" onclick="return confirm('Are you sure you want to delete this service?');"><i class="icofont icofont-trash"></i> Delete</a>
                                                        </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            <?php else: ?>
                                                <tr><td colspan="4" class="text-center">No services found</td></tr>
                                            <?php endif; ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

</div>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: mice-services.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation