Purpose
This tool displays a DJ schedule on the website. It is connected to a Google Sheet where DJs can enter their own data. The website updates automatically.
How it works
- The data source is a Google Sheet.
- The schedule is displayed using PHP, HTML, and CSS.
- Only current and future days are shown (max. 10 days ahead).
- The current day is open when the page loads.
For DJs: How to enter your show
- You need a Google Account.
- Please send your Google email address to the admin so they can grant access to the sheet.
- You must enter the following information:
- Date in the format:
MM-DD(e.g.05-31) → Leading zero required - Time of the show
- DJ name
- Genre, Title, and optional notes
- Description (can include a link)
- Date in the format:
Link Handling
- In the Description field, links are only shown if they contain the domain:
icq-chat.com - Other links are hidden.
Missing Info & Placeholder Image
- If a field is empty, a dash (
-) is shown. - If there is no DJ image, a placeholder with a silhouette and ’n/a‘ will be displayed.
Design Notes
- DJ pictures must be in the
/img/folder. - File name = exact DJ name (e.g.
dj^chilly.jpg) - Allowed image formats:
.jpg,.png,.webp - The design works on mobile phones and desktops.
Tech Overview
- Frontend: HTML + CSS
- Backend: PHP (
functions.php,data.php,settings.php) - Data is loaded via JSON from Google Sheets.
- No manual uploads needed.
Customization
- Colors, fonts, and layout can be changed via CSS.
- Settings like number of visible days are in
settings.php. - The placeholder image can be replaced anytime.