requireRole(['super_admin', 'admin']); $db = DB(); $flash = getFlashMessage(); // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $action = $_POST['action'] ?? ''; if ($action === 'add' || $action === 'edit') { $data = [ 'title' => cleanInput($_POST['title'] ?? ''), 'content' => $_POST['content'] ?? '', 'link' => cleanInput($_POST['link'] ?? ''), 'link_text' => cleanInput($_POST['link_text'] ?? ''), 'priority' => intval($_POST['priority'] ?? 0), 'bg_color' => cleanInput($_POST['bg_color'] ?? '#3b0b7c'), 'text_color' => cleanInput($_POST['text_color'] ?? '#ffffff'), 'icon' => cleanInput($_POST['icon'] ?? ''), 'is_active' => isset($_POST['is_active']) ? 1 : 0, 'display_from' => $_POST['display_from'] ?: null, 'display_until' => $_POST['display_until'] ?: null, 'created_by' => $_SESSION['user_id'] ]; if ($action === 'add') { $db->insert('marquee', $data); redirectWithMessage('marquee.php', 'News item added successfully', 'success'); } else { $id = intval($_POST['id'] ?? 0); $db->update('marquee', $data, ['id' => $id]); redirectWithMessage('marquee.php', 'News item updated successfully', 'success'); } } if ($action === 'delete') { $id = intval($_POST['id'] ?? 0); $db->delete('marquee', ['id' => $id]); redirectWithMessage('marquee.php', 'News item deleted', 'success'); } if ($action === 'toggle') { $id = intval($_POST['id'] ?? 0); $current = $db->fetchOne("SELECT is_active FROM marquee WHERE id = ?", [$id]); $db->update('marquee', ['is_active' => $current['is_active'] ? 0 : 1], ['id' => $id]); redirectWithMessage('marquee.php', 'Status updated', 'success'); } } // Get all marquee items $items = $db->fetchAll("SELECT * FROM marquee ORDER BY priority DESC, created_at DESC"); // Get single item for edit $editItem = null; if (isset($_GET['edit'])) { $editItem = $db->fetchOne("SELECT * FROM marquee WHERE id = ?", [intval($_GET['edit'])]); } ?> Marquee/News CMS - <?= APP_SHORT_NAME ?>

Marquee / News CMS

Live Preview (Top 2 Active Items)
= time()); }); $topItems = array_slice($activeItems, 0, 2); ?>
No active news items to display
: |
Priority:

...

From:
Until:
Edit