Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/goldartsdpi.in/public_html/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: manage_banners.php

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

<?php 
include('includes/head.php');
include('config.php');

// Pagination
$limit = 10;
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;
$offset = ($page - 1) * $limit;

// Search and filter
$search = isset($_GET['search']) ? sanitize($_GET['search']) : '';
$position_filter = isset($_GET['position']) ? sanitize($_GET['position']) : '';
$status_filter = isset($_GET['status']) ? intval($_GET['status']) : -1;

// Build query
$where = [];
$params = [];

if (!empty($search)) {
    $where[] = "banner_text LIKE ?";
    $params[] = "%$search%";
}

if (!empty($position_filter)) {
    $where[] = "position = ?";
    $params[] = $position_filter;
}

if ($status_filter >= 0) {
    $where[] = "is_active = ?";
    $params[] = $status_filter;
}

$where_clause = !empty($where) ? 'WHERE ' . implode(' AND ', $where) : '';

// Get total count for pagination
$count_sql = "SELECT COUNT(*) as total FROM banners $where_clause";
$count_stmt = mysqli_prepare($conn, $count_sql);

if (!empty($params)) {
    $types = str_repeat('s', count($params));
    mysqli_stmt_bind_param($count_stmt, $types, ...$params);
}

mysqli_stmt_execute($count_stmt);
$count_result = mysqli_stmt_get_result($count_stmt);
$total_rows = mysqli_fetch_assoc($count_result)['total'];
$total_pages = ceil($total_rows / $limit);

// Get banners
$sql = "SELECT * FROM banners $where_clause ORDER BY created_at DESC LIMIT ? OFFSET ?";
$params[] = $limit;
$params[] = $offset;

$stmt = mysqli_prepare($conn, $sql);
$types = (!empty($where) ? str_repeat('s', count($where)) : '') . 'ii';
mysqli_stmt_bind_param($stmt, $types, ...$params);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
?>

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">

<?php include('includes/topbar.php')?>

<div class="vertical-menu">
        <div data-simplebar class="h-100">
            
            <?php include('includes/sidebar.php')?>
            
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
            <div class="container-fluid">

<div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Manage Banners</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="javascript: void(0);">Banners</a></li>
                                    <li class="breadcrumb-item active">Manage Banners</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="row mb-3">
                                    <div class="col-md-6">
                                        <h4 class="card-title">Banner List</h4>
                                        <p class="card-title-desc">View and manage all banners</p>
                                    </div>
                                    <div class="col-md-6 text-end">
                                        <a href="add_banner.php" class="btn btn-primary">
                                            <i class="fas fa-plus"></i> Add New Banner
                                        </a>
                                    </div>
                                </div>

<form method="GET" action="">
                                    <div class="row mb-3">
                                        <div class="col-md-3">
                                            <input type="text" class="form-control" name="search" placeholder="Search banners..." value="<?= htmlspecialchars($search) ?>">
                                        </div>
                                        <div class="col-md-3">
                                            <select class="form-select" name="position">
                                                <option value="">All Positions</option>
                                                <option value="homepage-top" <?= $position_filter == 'homepage-top' ? 'selected' : '' ?>>Homepage Top</option>
                                                <option value="homepage-middle" <?= $position_filter == 'homepage-middle' ? 'selected' : '' ?>>Homepage Middle</option>
                                                <option value="homepage-bottom" <?= $position_filter == 'homepage-bottom' ? 'selected' : '' ?>>Homepage Bottom</option>
                                                <option value="category-top" <?= $position_filter == 'category-top' ? 'selected' : '' ?>>Category Page Top</option>
                                            </select>
                                        </div>
                                        <div class="col-md-3">
                                            <select class="form-select" name="status">
                                                <option value="-1">All Statuses</option>
                                                <option value="1" <?= $status_filter === 1 ? 'selected' : '' ?>>Active</option>
                                                <option value="0" <?= $status_filter === 0 ? 'selected' : '' ?>>Inactive</option>
                                            </select>
                                        </div>
                                        <div class="col-md-3">
                                            <button type="submit" class="btn btn-primary me-2">Filter</button>
                                            <a href="manage_banners.php" class="btn btn-secondary">Reset</a>
                                        </div>
                                    </div>
                                </form>

<div class="table-responsive">
                                    <table class="table table-striped table-bordered mb-0">
                                        <thead>
                                            <tr>
                                                <th>#</th>
                                                <th>Banner Image</th>
                                                <th>Banner Text</th>
                                                <th>Button Text</th>
                                                <th>Position</th>
                                                <th>Status</th>
                                                <th>Created At</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            if (mysqli_num_rows($result) > 0) {
                                                $count = $offset + 1;
                                                while ($banner = mysqli_fetch_assoc($result)) {
                                                    $image_path = !empty($banner['banner_image']) ? 
                                                        "uploads/banners/{$banner['banner_image']}" : 
                                                        "assets/images/no-image.png";
                                                    
                                                    $status = $banner['is_active'] ? 
                                                        '<span class="badge bg-success">Active</span>' : 
                                                        '<span class="badge bg-danger">Inactive</span>';
                                                    
                                                    $position_map = [
                                                        'homepage-top' => 'Homepage Top',
                                                        'homepage-middle' => 'Homepage Middle',
                                                        'homepage-bottom' => 'Homepage Bottom',
                                                        'category-top' => 'Category Top'
                                                    ];
                                                    $position = $position_map[$banner['position']] ?? $banner['position'];
                                                    ?>
                                                    <tr>
                                                        <td><?= $count ?></td>
                                                        <td>
                                                            <img src="<?= $image_path ?>" alt="Banner" style="width: 100px; height: auto; max-height: 60px; object-fit: cover;">
                                                        </td>
                                                        <td><?= htmlspecialchars($banner['banner_text']) ?></td>
                                                        <td><?= htmlspecialchars($banner['button_text']) ?></td>
                                                        <td><?= $position ?></td>
                                                        <td><?= $status ?></td>
                                                        <td><?= date('d M Y', strtotime($banner['created_at'])) ?></td>
                                                        <td>
                                                            <a href="edit_banner.php?id=<?= $banner['id'] ?>" class="btn btn-sm btn-primary" title="Edit">
                                                                <i class="fas fa-edit"></i>
                                                            </a>
                                                            <a href="#" class="btn btn-sm btn-danger delete-banner" data-id="<?= $banner['id'] ?>" title="Delete">
                                                                <i class="fas fa-trash-alt"></i>
                                                            </a>
                                                            <a href="banner_details.php?id=<?= $banner['id'] ?>" class="btn btn-sm btn-info" title="View">
                                                                <i class="fas fa-eye"></i>
                                                            </a>
                                                        </td>
                                                    </tr>
                                                    <?php
                                                    $count++;
                                                }
                                            } else {
                                                echo '<tr><td colspan="8" class="text-center">No banners found</td></tr>';
                                            }
                                            ?>
                                        </tbody>
                                    </table>
                                </div>

<?php if ($total_pages > 1): ?>
                                <div class="row mt-3">
                                    <div class="col-md-12">
                                        <nav aria-label="Page navigation">
                                            <ul class="pagination justify-content-center">
                                                <li class="page-item <?= $page <= 1 ? 'disabled' : '' ?>">
                                                    <a class="page-link" href="?<?= http_build_query(array_merge($_GET, ['page' => $page - 1])) ?>" aria-label="Previous">
                                                        <span aria-hidden="true">&laquo;</span>
                                                    </a>
                                                </li>
                                                
                                                <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                                                    <li class="page-item <?= $page == $i ? 'active' : '' ?>">
                                                        <a class="page-link" href="?<?= http_build_query(array_merge($_GET, ['page' => $i])) ?>"><?= $i ?></a>
                                                    </li>
                                                <?php endfor; ?>
                                                
                                                <li class="page-item <?= $page >= $total_pages ? 'disabled' : '' ?>">
                                                    <a class="page-link" href="?<?= http_build_query(array_merge($_GET, ['page' => $page + 1])) ?>" aria-label="Next">
                                                        <span aria-hidden="true">&raquo;</span>
                                                    </a>
                                                </li>
                                            </ul>
                                        </nav>
                                    </div>
                                </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

<?php include('includes/footer.php')?>
    </div>

</div>

<?php include('includes/rightbar.php')?>

<?php include('includes/scripts.php')?>

<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage_banners.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation