Thursday, August 27, 2026

DB-Driven Banner System & Admin CMS

Built database-driven hero banner/slider system with reusable renderer, admin installer script, and wired showcase page with include-based architecture.

Backend Frontend

New Components

DB Tables

Auto-Advance

Task Summary

Built reusable banner.php renderer with DB-driven slide management (custom_page_banners + custom_page_banner_slides tables)
Implemented responsive slider: full-viewport desktop, 70vh mobile, CSS fade transitions, 7s auto-advance
Built idempotent installer script for banner table creation and sample data seeding
Created showcase page wiring specific project IDs with banner control integration
Enhanced existing include to support banner rendering above property grids
Added group-based lookup via custom_page_groups with IDs fallback

Technical Details

Banner Architecture

Two-table schema: custom_page_banners (one row per banner/control-id) and custom_page_banner_slides (many slides per banner, FK cascade). Usage: set $bannerControlId and include banner.php. Supports <picture> with separate desktop/mobile image sources.

<?php $bannerControlId = 1; include __DIR__ . '/banner.php'; ?>
// Queries custom_page_banners + custom_page_banner_slides
// CSS fade transition + JS auto-advance (7s)