File Manager

Editing:banners.php

<?php
$page = 'banners';
$page_title = 'Banners';
require_once '../includes/header.php';

if (isset($_GET['delete'])) {
    $id = intval($_GET['delete']);
    $b = $db->prepare("SELECT image FROM banners WHERE id = ?");
    $b->execute([$id]);
    $bnr = $b->fetch();
    if ($bnr && $bnr['image']) @unlink(UPLOADS_PATH . 'banners/' . $bnr['image']);
    $db->prepare("DELETE FROM banners WHERE id = ?")->execute([$id]);
    admin_set_flash('success', 'Banner deleted');
    header('Location: ' . ADMIN_PATH . 'pages/banners.php');
    exit;
}

$banners = $db->query("SELECT * FROM banners ORDER BY sort_order ASC, id DESC")->fetchAll();
?>

<div class="data-table-wrapper">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h3 style="margin: 0; font-size: 1.2rem;">All Banners</h3>
        <a href="<?= ADMIN_PATH ?>pages/banner-add.php" class="btn-admin btn-primary-admin">
            <i class="fas fa-plus"></i> Add Banner
        </a>
    </div>
    
    <div class="row g-3">
        <?php foreach ($banners as $banner): ?>
        <div class="col-md-4">
            <div style="background: white; border-radius: 12px; overflow: hidden; box-shadow: 0 2px 10px rgba(0,0,0,0.05); position: relative;">
                <img src="<?= UPLOADS_URL ?>banners/<?= $banner['image'] ?>" class="w-100" style="height: 180px; object-fit: cover;">
                <div style="padding: 15px;">
                    <h6 style="font-family: var(--font-primary); margin-bottom: 5px;"><?= htmlspecialchars($banner['title'] ?? 'Untitled') ?></h6>
                    <small class="text-muted d-block mb-2"><?= htmlspecialchars($banner['subtitle'] ?? '') ?></small>
                    <div class="d-flex justify-content-between align-items-center">
                        <span class="status-badge status-<?= $banner['status'] ? 'active' : 'inactive' ?>">
                            <?= $banner['status'] ? 'Active' : 'Inactive' ?>
                        </span>
                        <div class="action-buttons">
                            <a href="<?= ADMIN_PATH ?>pages/banner-add.php?id=<?= $banner['id'] ?>" class="btn-icon btn-admin btn-primary-admin btn-sm-admin" data-bs-toggle="tooltip" title="Edit">
                                <i class="fas fa-edit"></i>
                            </a>
                            <a href="?delete=<?= $banner['id'] ?>" class="btn-icon btn-admin btn-danger-admin btn-sm-admin confirm-delete" data-bs-toggle="tooltip" title="Delete">
                                <i class="fas fa-trash"></i>
                            </a>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <?php endforeach; ?>
    </div>
</div>

<?php require_once '../includes/footer.php'; ?>

Cancel

🤩 File Manager - Mr.X

Editing:banners.php