# Yoruba Dunlede
**Yoruba Dunlede** is a PHP-based culture and audio learning website that showcases Yoruba greetings, provides an audio library, and includes an admin dashboard for managing audio files with QR code generation.
## Overview
This repository contains:
- A public landing page about Yoruba greetings and culture
- A browsable audio library for Yoruba audio lessons
- A detail page for individual audio tracks
- An admin dashboard for uploading, editing, and deleting audio files
- QR code generation for direct audio page links
## Key Features
- Responsive public site built with PHP, HTML, CSS, and JavaScript
- Audio gallery with cover images, chapter metadata, and playback support
- Admin panel using Material Dashboard for Bootstrap 5
- MP3 upload support with optional cover image upload
- Bulk delete support for admin-managed audio entries
- QR code generation for each uploaded audio track
## Technology Stack
- PHP 8+ / Apache
- MySQL / MariaDB
- Bootstrap 5
- Material Dashboard UI
- `endroid/qr-code` for QR code generation
- Node.js tooling for admin frontend assets
## Prerequisites
- XAMPP or another local PHP/MySQL environment
- PHP with `mysqli` extension enabled
- Composer
- Node.js and npm (for admin frontend asset management)
## Installation
1. Clone the repository into your web root.
2. Import the database schema from `yoruba.sql` into your MySQL server.
3. Update `includes/db.php` with your database credentials if needed.
4. Install PHP dependencies for admin QR code generation:
```bash
cd /c/xampp/htdocs/yoruba/admin
composer install
```
5. Install Node dependencies for admin frontend asset management (optional):
```bash
cd /c/xampp/htdocs/yoruba/admin
npm install
```
## Configuration
- The database connection is configured in `includes/db.php`.
- Uploaded audio and cover images are stored under `admin/uploads/`.
- Generated QR codes are saved under `qrcodes/`.
- The upload flow uses a base URL that defaults to `
localhost …