Kiosk Administration Dashboard server (LINUX)

Each TV screen at a client location is connected to a Raspberry Pi device. The Raspberry Pi loads a webpage from a central web server in full-screen kiosk mode. The web server dynamically generates the media content for each specific site.
Main Components:
TV Screen
Raspberry Pi (connected via HDMI)
Internet Connection
Central Web Server (PHP + MySQL)
Admin Dashboard
The Raspberry Pi powers on.
It automatically launches a browser in kiosk mode.
The browser loads a URL specific to that location (e.g., display.php?site=SITE001).
The server reads the site ID and retrieves that site's playlist from the database.
The server dynamically builds an HTML page with images/videos.
The browser displays the content in full screen.
The page automatically refreshes periodically to check for updates.
The system includes an Admin Dashboard where administrators can:
Create and manage site locations
Upload images and videos
Create playlists per site
Reorder media items
Set display duration for each item
Monitor screen online/offline status
The screen shows a single image scaled to fit the entire display.
[ FULL SCREEN IMAGE ]
----------------------------------------
| |
| Promotional Banner Image |
| |
----------------------------------------
The screen automatically plays a promotional video in full screen.
[ FULL SCREEN VIDEO ]
----------------------------------------
| |
| Promotional Video Playing |
| |
----------------------------------------
The screen rotates between images and videos automatically.
Playlist Order Example:
1. Image - Welcome Banner (10 seconds)
2. Video - Product Demo (30 seconds)
3. Image - Special Offer (15 seconds)
[ ADMIN DASHBOARD MOCKUP ]
----------------------------------------
| Sites | Media Library | Playlists |
----------------------------------------
| SITE001 | Edit Playlist | Online |
| SITE002 | Edit Playlist | Offline |
----------------------------------------
Centralized control of all screens
No travel required to update content
Scalable to many locations
Cost-effective hardware
Real-time updates
Custom content per client