Set up modern PHP MVC project structure for GetYourBand platform

- Implemented clean MVC architecture with Router, Controller, and Model base classes - Created database migrations for users, bands, bookings, reviews, and availability - Set up Tailwind CSS with yellow color scheme and modern design - Added Alpine.js for reactive JavaScript components - Configured Vite for asset building and hot module replacement - Created authentication and role-based middleware - Implemented helper functions and configuration system - Added comprehensive README with setup instructions - Configured Apache with proper rewrite rules and security headers - Set up Composer and npm package management with modern dependencies
2025-12-02 21:31:08 +00:00
37 changed files with 2015 additions and 0 deletions
@@ -0,0 +1,45 @@
+# Application
+APP_NAME="GetYourBand"
+APP_ENV=local
+APP_DEBUG=true
+APP_URL=http://localhost
+
+# Database
+DB_CONNECTION=mysql
+DB_HOST=127.0.0.1
+DB_PORT=3306
+DB_DATABASE=getyourband
+DB_USERNAME=root
+DB_PASSWORD=
+
+# Mail (SMTP)
+MAIL_MAILER=smtp
+MAIL_HOST=smtp.mailtrap.io
+MAIL_PORT=2525
+MAIL_USERNAME=null
+MAIL_PASSWORD=null
+MAIL_ENCRYPTION=tls
+MAIL_FROM_ADDRESS=noreply@getyourband.ch
+MAIL_FROM_NAME="${APP_NAME}"
+
+# Payment
+PAYPAL_MODE=sandbox
+PAYPAL_CLIENT_ID=
+PAYPAL_SECRET=
+PAYMENT_ENABLED=false
+COMMISSION_RATE=0.10
+
+# Upload Settings
+MAX_UPLOAD_SIZE=5242880
+ALLOWED_IMAGE_TYPES=jpg,jpeg,png,webp
+ALLOWED_VIDEO_TYPES=mp4,webm
+
+# Security
+SESSION_LIFETIME=120
+SESSION_DRIVER=file
+HASH_ALGO=bcrypt
+
+# Features
+REQUIRE_EMAIL_VERIFICATION=true
+REQUIRE_BAND_APPROVAL=true
+ENABLE_REVIEWS=true
@@ -1,2 +1,41 @@
+# Environment
+.env
+.env.local
+
+# Dependencies
+/vendor/
+/node_modules/
+
+# Build assets
+/public/dist/
+/public/hot
+
+# Storage
 storage/*
 !storage/.gitkeep
+storage/cache/*
+storage/logs/*
+storage/sessions/*
+storage/uploads/*
+
+# IDE
+.vscode/
+.idea/
+*.sublime-*
+*.swp
+*.swo
+*~
+
+# OS
+.DS_Store
+Thumbs.db
+
+# Composer
+composer.lock
+
+# NPM
+package-lock.json
+yarn.lock
+
+# Testing
+.phpunit.result.cache
@@ -1,5 +1,10 @@
 Options -Indexes
 AddDefaultCharset UTF-8
+
 <IfModule mod_rewrite.c>
 RewriteEngine On
+
+# Redirect to public directory
+RewriteCond %{REQUEST_URI} !^/public/
+RewriteRule ^(.*)$ /public/$1 [L,QSA]
 </IfModule>
@@ -0,0 +1,356 @@
+# 🎸 GetYourBand - Bandvermittlungsplattform
+
+Eine moderne, professionelle Plattform für die Vermittlung von Live-Bands in der Schweiz.
+
+## 🚀 Features
+
+- ✨ **Moderne MVC-Architektur** - Saubere Trennung von Logik, Daten und Präsentation
+- 🎨 **Tailwind CSS** - Modernes, responsives Design mit gelben Farbtönen
+- ⚡ **Alpine.js** - Leichtgewichtige JavaScript-Interaktivität
+- 🔐 **Authentifizierung** - Login, Registrierung, E-Mail-Verifizierung
+- 👥 **Mehrere Rollen** - Admin, Band, Kunde
+- 🔍 **Erweiterte Suche** - Nach Genre, Ort, Preis filtern
+- ⭐ **Bewertungssystem** - Nur nach Buchung möglich
+- 📅 **Verfügbarkeitskalender** - Bands können Verfügbarkeit verwalten
+- 💳 **PayPal-Integration** - Optional aktivierbare Zahlungen
+- 📧 **E-Mail-Benachrichtigungen** - Automatische Updates
+- 🛡️ **DSGVO-konform** - Cookie-Banner, Datenschutz
+- 📱 **Mobile-First** - Optimiert für alle Geräte
+
+## 📋 Voraussetzungen
+
+- PHP 8.3 oder höher
+- MySQL 5.7+ oder MariaDB 10.3+
+- Apache mit mod_rewrite
+- Composer
+- Node.js & npm (für Frontend-Build)
+
+## 🔧 Installation
+
+### 1. Repository klonen
+
+```bash
+git clone <repository-url>
+cd ai_playgroud
+```
+
+### 2. PHP-Abhängigkeiten installieren
+
+```bash
+composer install
+```
+
+### 3. Frontend-Abhängigkeiten installieren
+
+```bash
+npm install
+```
+
+### 4. Umgebungskonfiguration
+
+```bash
+cp .env.example .env
+```
+
+Passe die `.env`-Datei an:
+
+```env
+# Datenbank
+DB_HOST=127.0.0.1
+DB_PORT=3306
+DB_DATABASE=getyourband
+DB_USERNAME=root
+DB_PASSWORD=dein_passwort
+
+# Mail (SMTP)
+MAIL_HOST=smtp.gmail.com
+MAIL_PORT=587
+MAIL_USERNAME=deine@email.ch
+MAIL_PASSWORD=dein_passwort
+
+# Optional: PayPal
+PAYPAL_CLIENT_ID=deine_client_id
+PAYPAL_SECRET=dein_secret
+PAYMENT_ENABLED=true
+```
+
+### 5. Datenbank erstellen
+
+```bash
+mysql -u root -p -e "CREATE DATABASE getyourband CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"
+```
+
+### 6. Migrationen ausführen
+
+```bash
+php migrate.php
+```
+
+### 7. Frontend-Assets kompilieren
+
+**Entwicklung:**
+```bash
+npm run dev
+```
+
+**Produktion:**
+```bash
+npm run build
+```
+
+### 8. Berechtigungen setzen
+
+```bash
+chmod -R 755 storage
+chmod -R 755 public/uploads
+```
+
+## 🌐 Entwicklungsserver
+
+### Option 1: PHP Built-in Server
+
+```bash
+cd public
+php -S localhost:8000
+```
+
+Öffne: http://localhost:8000
+
+### Option 2: Apache/XAMPP
+
+1. Erstelle einen Virtual Host oder nutze htdocs
+2. Stelle sicher, dass `mod_rewrite` aktiviert ist
+3. DocumentRoot sollte auf das Hauptverzeichnis zeigen (nicht /public!)
+
+## 📁 Projektstruktur
+
+```
+.
+├── app/
+│   ├── Controllers/        # Controller-Klassen
+│   ├── Models/            # Datenmodelle
+│   ├── Views/             # View-Templates
+│   ├── Middleware/        # Middleware (Auth, etc.)
+│   ├── Core/              # Kern-Framework (Router, Controller, Model)
+│   └── helpers.php        # Helper-Funktionen
+├── config/                # Konfigurationsdateien
+├── database/
+│   ├── migrations/        # SQL-Migrationen
+│   └── Database.php       # Datenbankverbindung
+├── public/                # Öffentliches Verzeichnis (DocumentRoot)
+│   ├── index.php          # Entry Point
+│   ├── .htaccess          # Apache-Konfiguration
+│   ├── css/               # Kompilierte CSS
+│   ├── js/                # Kompilierte JS
+│   └── uploads/           # User-Uploads
+├── resources/
+│   ├── css/               # Quell-CSS (Tailwind)
+│   └── js/                # Quell-JavaScript
+├── routes/
+│   └── web.php            # Route-Definitionen
+├── storage/               # Temporäre Dateien, Logs, Cache
+├── .env                   # Umgebungsvariablen (nicht committen!)
+├── composer.json          # PHP-Abhängigkeiten
+├── package.json           # Frontend-Abhängigkeiten
+├── tailwind.config.js     # Tailwind-Konfiguration
+└── vite.config.js         # Vite-Build-Konfiguration
+```
+
+## 🎨 Design & Farben
+
+Das Projekt nutzt ein modernes gelbes Farbschema:
+
+- **Primary**: Gelb-Orange-Töne (#fbbf24 - #f59e0b)
+- **Accent**: Helles Gelb (#eab308 - #facc15)
+- **Schrift**: Inter (Body), Poppins (Headlines)
+
+## 🔐 Standard-Admin erstellen
+
+Nach der Migration kannst du einen Admin-Account manuell in der Datenbank erstellen:
+
+```sql
+INSERT INTO users (email, password, name, role, email_verified_at, is_active)
+VALUES (
+    'admin@getyourband.ch',
+    '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', -- "password"
+    'Admin',
+    'admin',
+    NOW(),
+    1
+);
+```
+
+**Login:** admin@getyourband.ch
+**Passwort:** password
+
+⚠️ **Wichtig:** Ändere das Passwort nach dem ersten Login!
+
+## 📝 Routen-Übersicht
+
+### Öffentlich
+- `GET /` - Homepage
+- `GET /bands` - Band-Liste
+- `GET /bands/{slug}` - Band-Detail
+- `GET /login` - Login-Formular
+- `POST /login` - Login-Verarbeitung
+- `GET /register` - Registrierungs-Formular
+- `POST /register` - Registrierung
+
+### Geschützt (Authentifiziert)
+- `GET /profile` - User-Profil
+- `POST /profile/update` - Profil aktualisieren
+- `POST /bookings/create` - Buchung erstellen
+- `GET /my-bookings` - Meine Buchungen
+
+### Band-Bereich
+- `GET /band/manage` - Band-Verwaltung
+- `POST /band/update` - Band aktualisieren
+- `GET /band/bookings` - Eingehende Buchungsanfragen
+
+### Admin-Bereich
+- `GET /admin` - Admin-Dashboard
+- `GET /admin/bands` - Band-Verwaltung
+- `POST /admin/bands/{id}/approve` - Band freischalten
+- `GET /admin/reviews` - Bewertungen moderieren
+
+## 🧪 Entwicklung
+
+### Tailwind-Klassen neu kompilieren
+
+```bash
+npm run watch
+```
+
+Dies startet einen Watch-Modus, der bei Änderungen automatisch neu kompiliert.
+
+### Neue Migration erstellen
+
+Erstelle eine neue SQL-Datei in `database/migrations/`:
+
+```bash
+touch database/migrations/007_create_new_table.sql
+```
+
+Führe sie aus:
+
+```bash
+php migrate.php
+```
+
+### Neuen Controller erstellen
+
+```php
+<?php
+
+namespace App\Controllers;
+
+use App\Core\Controller;
+
+class MyController extends Controller
+{
+    public function index(): void
+    {
+        $this->view('my-view', [
+            'data' => 'value'
+        ]);
+    }
+}
+```
+
+### Neues Model erstellen
+
+```php
+<?php
+
+namespace App\Models;
+
+use App\Core\Model;
+
+class MyModel extends Model
+{
+    protected string $table = 'my_table';
+
+    protected array $fillable = [
+        'column1',
+        'column2',
+    ];
+}
+```
+
+## 🐛 Debugging
+
+Debug-Modus aktivieren in `.env`:
+
+```env
+APP_DEBUG=true
+```
+
+Im Debug-Modus werden ausführliche Fehler angezeigt.
+
+### Nützliche Helper-Funktionen
+
+```php
+dd($variable);              // Dump & Die
+config('app.name');         // Konfiguration abrufen
+env('DB_HOST');            // Umgebungsvariable
+old('field_name');         // Vorheriger Formular-Wert
+error('field_name');       // Validierungsfehler
+```
+
+## 📦 Deployment
+
+### Produktion vorbereiten
+
+1. **Assets kompilieren:**
+   ```bash
+   npm run build
+   ```
+
+2. **Composer optimieren:**
+   ```bash
+   composer install --optimize-autoloader --no-dev
+   ```
+
+3. **Environment:**
+   ```env
+   APP_ENV=production
+   APP_DEBUG=false
+   ```
+
+4. **Berechtigungen:**
+   ```bash
+   chmod -R 755 storage
+   chmod -R 755 public/uploads
+   ```
+
+5. **Apache-Konfiguration:**
+   - DocumentRoot auf Hauptverzeichnis setzen (nicht /public!)
+   - `mod_rewrite` aktivieren
+   - `.htaccess` ermöglichen
+
+## 🤝 Contributing
+
+1. Fork das Projekt
+2. Feature-Branch erstellen (`git checkout -b feature/AmazingFeature`)
+3. Änderungen committen (`git commit -m 'Add some AmazingFeature'`)
+4. Branch pushen (`git push origin feature/AmazingFeature`)
+5. Pull Request öffnen
+
+## 📄 Lizenz
+
+Proprietary - Alle Rechte vorbehalten
+
+## 👤 Kontakt
+
+GetYourBand - info@getyourband.ch
+
+## 🙏 Credits
+
+- **Tailwind CSS** - https://tailwindcss.com
+- **Alpine.js** - https://alpinejs.dev
+- **Vite** - https://vitejs.dev
+- **PHP** - https://php.net
+
+---
+
+Made with ❤️ and 🎸 in Switzerland
@@ -0,0 +1,26 @@
+<?php
+
+namespace App\Controllers;
+
+use App\Core\Controller;
+use App\Models\Band;
+
+class HomeController extends Controller
+{
+    public function index(): void
+    {
+        $bandModel = new Band();
+
+        // Get top-rated bands
+        $featuredBands = $bandModel->query(
+            "SELECT * FROM bands
+             WHERE is_approved = 1 AND is_active = 1
+             ORDER BY average_rating DESC, total_reviews DESC
+             LIMIT 6"
+        );
+
+        $this->view('home', [
+            'featuredBands' => $featuredBands,
+        ]);
+    }
+}
@@ -0,0 +1,99 @@
+<?php
+
+namespace App\Core;
+
+class Controller
+{
+    protected function view(string $view, array $data = []): void
+    {
+        extract($data);
+
+        $viewPath = __DIR__ . '/../Views/' . str_replace('.', '/', $view) . '.php';
+
+        if (!file_exists($viewPath)) {
+            throw new \RuntimeException("View not found: {$view}");
+        }
+
+        require_once $viewPath;
+    }
+
+    protected function json($data, int $status = 200): void
+    {
+        http_response_code($status);
+        header('Content-Type: application/json');
+        echo json_encode($data);
+        exit;
+    }
+
+    protected function redirect(string $path): void
+    {
+        header("Location: {$path}");
+        exit;
+    }
+
+    protected function back(): void
+    {
+        $referer = $_SERVER['HTTP_REFERER'] ?? '/';
+        $this->redirect($referer);
+    }
+
+    protected function input(string $key, $default = null)
+    {
+        return $_POST[$key] ?? $_GET[$key] ?? $default;
+    }
+
+    protected function validate(array $rules): array
+    {
+        $errors = [];
+        $data = [];
+
+        foreach ($rules as $field => $fieldRules) {
+            $value = $this->input($field);
+            $fieldRules = explode('|', $fieldRules);
+
+            foreach ($fieldRules as $rule) {
+                if ($rule === 'required' && empty($value)) {
+                    $errors[$field][] = ucfirst($field) . ' is required';
+                }
+
+                if (str_starts_with($rule, 'min:')) {
+                    $min = (int) substr($rule, 4);
+                    if (strlen($value) < $min) {
+                        $errors[$field][] = ucfirst($field) . " must be at least {$min} characters";
+                    }
+                }
+
+                if (str_starts_with($rule, 'max:')) {
+                    $max = (int) substr($rule, 4);
+                    if (strlen($value) > $max) {
+                        $errors[$field][] = ucfirst($field) . " must not exceed {$max} characters";
+                    }
+                }
+
+                if ($rule === 'email' && !filter_var($value, FILTER_VALIDATE_EMAIL)) {
+                    $errors[$field][] = ucfirst($field) . ' must be a valid email';
+                }
+            }
+
+            $data[$field] = $value;
+        }
+
+        if (!empty($errors)) {
+            $_SESSION['errors'] = $errors;
+            $_SESSION['old'] = $data;
+            $this->back();
+        }
+
+        return $data;
+    }
+
+    protected function auth()
+    {
+        return $_SESSION['user'] ?? null;
+    }
+
+    protected function isAuthenticated(): bool
+    {
+        return isset($_SESSION['user']);
+    }
+}
@@ -0,0 +1,100 @@
+<?php
+
+namespace App\Core;
+
+use Database\Database;
+use PDO;
+
+abstract class Model
+{
+    protected PDO $db;
+    protected string $table;
+    protected string $primaryKey = 'id';
+    protected array $fillable = [];
+
+    public function __construct()
+    {
+        $this->db = Database::connect();
+    }
+
+    public function all(): array
+    {
+        $stmt = $this->db->query("SELECT * FROM {$this->table}");
+        return $stmt->fetchAll();
+    }
+
+    public function find(int $id): ?array
+    {
+        $stmt = $this->db->prepare("SELECT * FROM {$this->table} WHERE {$this->primaryKey} = ? LIMIT 1");
+        $stmt->execute([$id]);
+        $result = $stmt->fetch();
+        return $result ?: null;
+    }
+
+    public function where(string $column, $value): array
+    {
+        $stmt = $this->db->prepare("SELECT * FROM {$this->table} WHERE {$column} = ?");
+        $stmt->execute([$value]);
+        return $stmt->fetchAll();
+    }
+
+    public function first(string $column, $value): ?array
+    {
+        $stmt = $this->db->prepare("SELECT * FROM {$this->table} WHERE {$column} = ? LIMIT 1");
+        $stmt->execute([$value]);
+        $result = $stmt->fetch();
+        return $result ?: null;
+    }
+
+    public function create(array $data): int
+    {
+        $data = $this->filterFillable($data);
+        $columns = implode(', ', array_keys($data));
+        $placeholders = implode(', ', array_fill(0, count($data), '?'));
+
+        $sql = "INSERT INTO {$this->table} ({$columns}) VALUES ({$placeholders})";
+        $stmt = $this->db->prepare($sql);
+        $stmt->execute(array_values($data));
+
+        return (int) $this->db->lastInsertId();
+    }
+
+    public function update(int $id, array $data): bool
+    {
+        $data = $this->filterFillable($data);
+        $set = implode(' = ?, ', array_keys($data)) . ' = ?';
+
+        $sql = "UPDATE {$this->table} SET {$set} WHERE {$this->primaryKey} = ?";
+        $stmt = $this->db->prepare($sql);
+
+        return $stmt->execute([...array_values($data), $id]);
+    }
+
+    public function delete(int $id): bool
+    {
+        $stmt = $this->db->prepare("DELETE FROM {$this->table} WHERE {$this->primaryKey} = ?");
+        return $stmt->execute([$id]);
+    }
+
+    public function query(string $sql, array $params = []): array
+    {
+        $stmt = $this->db->prepare($sql);
+        $stmt->execute($params);
+        return $stmt->fetchAll();
+    }
+
+    public function execute(string $sql, array $params = []): bool
+    {
+        $stmt = $this->db->prepare($sql);
+        return $stmt->execute($params);
+    }
+
+    protected function filterFillable(array $data): array
+    {
+        if (empty($this->fillable)) {
+            return $data;
+        }
+
+        return array_intersect_key($data, array_flip($this->fillable));
+    }
+}
@@ -0,0 +1,118 @@
+<?php
+
+namespace App\Core;
+
+class Router
+{
+    private array $routes = [];
+    private array $middlewareStack = [];
+
+    public function get(string $path, $handler): void
+    {
+        $this->addRoute('GET', $path, $handler);
+    }
+
+    public function post(string $path, $handler): void
+    {
+        $this->addRoute('POST', $path, $handler);
+    }
+
+    public function put(string $path, $handler): void
+    {
+        $this->addRoute('PUT', $path, $handler);
+    }
+
+    public function delete(string $path, $handler): void
+    {
+        $this->addRoute('DELETE', $path, $handler);
+    }
+
+    public function group(array $attributes, callable $callback): void
+    {
+        $previousMiddleware = $this->middlewareStack;
+
+        if (isset($attributes['middleware'])) {
+            $this->middlewareStack = array_merge(
+                $this->middlewareStack,
+                (array) $attributes['middleware']
+            );
+        }
+
+        $callback($this);
+
+        $this->middlewareStack = $previousMiddleware;
+    }
+
+    private function addRoute(string $method, string $path, $handler): void
+    {
+        $this->routes[] = [
+            'method' => $method,
+            'path' => $path,
+            'handler' => $handler,
+            'middleware' => $this->middlewareStack,
+        ];
+    }
+
+    public function dispatch(string $requestMethod, string $requestUri): void
+    {
+        $requestUri = parse_url($requestUri, PHP_URL_PATH);
+
+        foreach ($this->routes as $route) {
+            if ($route['method'] !== $requestMethod) {
+                continue;
+            }
+
+            $pattern = $this->convertToPattern($route['path']);
+
+            if (preg_match($pattern, $requestUri, $matches)) {
+                array_shift($matches); // Remove full match
+
+                // Execute middleware
+                foreach ($route['middleware'] as $middleware) {
+                    $this->executeMiddleware($middleware);
+                }
+
+                // Execute handler
+                $this->executeHandler($route['handler'], $matches);
+                return;
+            }
+        }
+
+        // 404 Not Found
+        http_response_code(404);
+        echo "404 - Page Not Found";
+    }
+
+    private function convertToPattern(string $path): string
+    {
+        $pattern = preg_replace('/\{([a-zA-Z0-9_]+)\}/', '([^/]+)', $path);
+        return '#^' . $pattern . '$#';
+    }
+
+    private function executeMiddleware(string $middleware): void
+    {
+        $parts = explode(':', $middleware);
+        $name = $parts[0];
+        $params = $parts[1] ?? null;
+
+        $middlewareClass = "App\\Middleware\\" . ucfirst($name) . "Middleware";
+
+        if (!class_exists($middlewareClass)) {
+            throw new \RuntimeException("Middleware not found: {$middlewareClass}");
+        }
+
+        $instance = new $middlewareClass();
+        $instance->handle($params);
+    }
+
+    private function executeHandler($handler, array $params): void
+    {
+        if (is_array($handler)) {
+            [$class, $method] = $handler;
+            $controller = new $class();
+            call_user_func_array([$controller, $method], $params);
+        } elseif (is_callable($handler)) {
+            call_user_func_array($handler, $params);
+        }
+    }
+}
@@ -0,0 +1,14 @@
+<?php
+
+namespace App\Middleware;
+
+class AuthMiddleware
+{
+    public function handle($params = null): void
+    {
+        if (!isset($_SESSION['user'])) {
+            header('Location: /login');
+            exit;
+        }
+    }
+}
@@ -0,0 +1,19 @@
+<?php
+
+namespace App\Middleware;
+
+class RoleMiddleware
+{
+    public function handle($role = null): void
+    {
+        if (!isset($_SESSION['user'])) {
+            header('Location: /login');
+            exit;
+        }
+
+        if ($role && $_SESSION['user']['role'] !== $role) {
+            http_response_code(403);
+            die('403 - Forbidden');
+        }
+    }
+}
@@ -0,0 +1,96 @@
+<?php
+
+namespace App\Models;
+
+use App\Core\Model;
+
+class Band extends Model
+{
+    protected string $table = 'bands';
+
+    protected array $fillable = [
+        'user_id',
+        'name',
+        'slug',
+        'description',
+        'genre',
+        'location',
+        'postal_code',
+        'price_min',
+        'price_max',
+        'member_count',
+        'phone',
+        'website',
+        'facebook',
+        'instagram',
+        'youtube',
+        'profile_image',
+        'cover_image',
+        'is_approved',
+        'is_active',
+    ];
+
+    public function findBySlug(string $slug): ?array
+    {
+        return $this->first('slug', $slug);
+    }
+
+    public function search(array $filters): array
+    {
+        $sql = "SELECT * FROM {$this->table} WHERE is_approved = 1 AND is_active = 1";
+        $params = [];
+
+        if (!empty($filters['genre'])) {
+            $sql .= " AND genre = ?";
+            $params[] = $filters['genre'];
+        }
+
+        if (!empty($filters['location'])) {
+            $sql .= " AND (location LIKE ? OR postal_code LIKE ?)";
+            $params[] = "%{$filters['location']}%";
+            $params[] = "%{$filters['location']}%";
+        }
+
+        if (!empty($filters['price_max'])) {
+            $sql .= " AND price_min <= ?";
+            $params[] = $filters['price_max'];
+        }
+
+        if (!empty($filters['q'])) {
+            $sql .= " AND MATCH(name, description, genre) AGAINST (? IN NATURAL LANGUAGE MODE)";
+            $params[] = $filters['q'];
+        }
+
+        $sql .= " ORDER BY average_rating DESC, total_reviews DESC";
+
+        return $this->query($sql, $params);
+    }
+
+    public function incrementViews(int $id): bool
+    {
+        return $this->execute(
+            "UPDATE {$this->table} SET view_count = view_count + 1 WHERE id = ?",
+            [$id]
+        );
+    }
+
+    public function updateRating(int $bandId): void
+    {
+        $sql = "
+            UPDATE bands
+            SET average_rating = (
+                SELECT AVG(rating)
+                FROM reviews
+                WHERE band_id = ? AND is_approved = 1
+            ),
+            total_reviews = (
+                SELECT COUNT(*)
+                FROM reviews
+                WHERE band_id = ? AND is_approved = 1
+            )
+            WHERE id = ?
+        ";
+
+        $this->execute($sql, [$bandId, $bandId, $bandId]);
+    }
+}
@@ -0,0 +1,49 @@
+<?php
+
+namespace App\Models;
+
+use App\Core\Model;
+
+class User extends Model
+{
+    protected string $table = 'users';
+
+    protected array $fillable = [
+        'email',
+        'password',
+        'name',
+        'role',
+        'verification_token',
+        'email_verified_at',
+        'is_active',
+    ];
+
+    public function findByEmail(string $email): ?array
+    {
+        return $this->first('email', $email);
+    }
+
+    public function verifyEmail(string $token): bool
+    {
+        $user = $this->first('verification_token', $token);
+
+        if (!$user) {
+            return false;
+        }
+
+        return $this->update($user['id'], [
+            'email_verified_at' => date('Y-m-d H:i:s'),
+            'verification_token' => null,
+        ]);
+    }
+
+    public static function hashPassword(string $password): string
+    {
+        return password_hash($password, PASSWORD_BCRYPT);
+    }
+
+    public static function verifyPassword(string $password, string $hash): bool
+    {
+        return password_verify($password, $hash);
+    }
+}
@@ -0,0 +1,126 @@
+<?php ob_start(); ?>
+
+<!-- Hero Section -->
+<section class="bg-gradient-to-br from-primary-500 via-accent-500 to-primary-600 text-white py-20">
+    <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 text-center">
+        <h1 class="text-5xl md:text-6xl font-display font-bold mb-6 text-balance">
+            Finde die perfekte Band für dein Event
+        </h1>
+        <p class="text-xl md:text-2xl mb-8 text-primary-50 max-w-3xl mx-auto text-balance">
+            Professionelle Live-Bands in der ganzen Schweiz. Einfach buchen, perfekt performen.
+        </p>
+        <div class="flex flex-col sm:flex-row gap-4 justify-center">
+            <a href="/bands" class="btn bg-white text-primary-600 hover:bg-gray-100 text-lg px-8 py-3">
+                Bands entdecken
+            </a>
+            <a href="/register" class="btn bg-primary-700 text-white hover:bg-primary-800 text-lg px-8 py-3">
+                Als Band registrieren
+            </a>
+        </div>
+    </div>
+</section>
+
+<!-- Search Section -->
+<section class="py-16 bg-white">
+    <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8">
+        <div class="bg-gray-50 rounded-2xl shadow-lg p-8" x-data="searchBands">
+            <h2 class="text-3xl font-display font-bold text-center mb-8">Suche deine Band</h2>
+
+            <form @submit.prevent="search" class="grid grid-cols-1 md:grid-cols-4 gap-4">
+                <input
+                    type="text"
+                    x-model="query"
+                    placeholder="Band, Genre, Stil..."
+                    class="input-field"
+                >
+                <input
+                    type="text"
+                    x-model="filters.location"
+                    placeholder="Ort oder PLZ"
+                    class="input-field"
+                >
+                <select x-model="filters.genre" class="input-field">
+                    <option value="">Alle Genres</option>
+                    <option value="Rock">Rock</option>
+                    <option value="Pop">Pop</option>
+                    <option value="Jazz">Jazz</option>
+                    <option value="Blues">Blues</option>
+                    <option value="Funk">Funk</option>
+                    <option value="Cover">Cover</option>
+                </select>
+                <button type="submit" class="btn btn-primary">
+                    Suchen
+                </button>
+            </form>
+        </div>
+    </div>
+</section>
+
+<!-- Featured Bands -->
+<section class="py-16 bg-gray-50">
+    <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8">
+        <h2 class="text-4xl font-display font-bold text-center mb-12">Top bewertete Bands</h2>
+
+        <div class="grid grid-cols-1 md:grid-cols-3 gap-8">
+            <?php foreach ($featuredBands ?? [] as $band): ?>
+                <div class="card group hover:scale-105 transition-transform">
+                    <div class="aspect-video bg-gray-200 rounded-lg mb-4 overflow-hidden">
+                        <?php if ($band['cover_image']): ?>
+                            <img src="<?= $band['cover_image'] ?>" alt="<?= $band['name'] ?>" class="w-full h-full object-cover">
+                        <?php endif; ?>
+                    </div>
+                    <div class="flex items-start justify-between mb-2">
+                        <h3 class="text-xl font-bold text-gray-900"><?= htmlspecialchars($band['name']) ?></h3>
+                        <span class="badge badge-yellow"><?= htmlspecialchars($band['genre']) ?></span>
+                    </div>
+                    <p class="text-gray-600 mb-4 line-clamp-2"><?= htmlspecialchars($band['description']) ?></p>
+                    <div class="flex items-center justify-between">
+                        <div class="flex items-center">
+                            <span class="text-yellow-500 mr-1">⭐</span>
+                            <span class="font-semibold"><?= number_format($band['average_rating'], 1) ?></span>
+                            <span class="text-gray-500 text-sm ml-1">(<?= $band['total_reviews'] ?>)</span>
+                        </div>
+                        <a href="/bands/<?= $band['slug'] ?>" class="text-primary-600 hover:text-primary-700 font-medium">
+                            Details →
+                        </a>
+                    </div>
+                </div>
+            <?php endforeach; ?>
+        </div>
+    </div>
+</section>
+
+<!-- How it Works -->
+<section class="py-16 bg-white">
+    <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8">
+        <h2 class="text-4xl font-display font-bold text-center mb-12">So funktioniert's</h2>
+
+        <div class="grid grid-cols-1 md:grid-cols-3 gap-12">
+            <div class="text-center">
+                <div class="w-16 h-16 bg-primary-100 rounded-full flex items-center justify-center mx-auto mb-4">
+                    <span class="text-3xl">🔍</span>
+                </div>
+                <h3 class="text-xl font-bold mb-2">1. Suchen</h3>
+                <p class="text-gray-600">Finde die perfekte Band für dein Event mit unseren Suchfiltern.</p>
+            </div>
+            <div class="text-center">
+                <div class="w-16 h-16 bg-primary-100 rounded-full flex items-center justify-center mx-auto mb-4">
+                    <span class="text-3xl">📧</span>
+                </div>
+                <h3 class="text-xl font-bold mb-2">2. Anfragen</h3>
+                <p class="text-gray-600">Sende eine unverbindliche Anfrage mit deinen Event-Details.</p>
+            </div>
+            <div class="text-center">
+                <div class="w-16 h-16 bg-primary-100 rounded-full flex items-center justify-center mx-auto mb-4">
+                    <span class="text-3xl">🎉</span>
+                </div>
+                <h3 class="text-xl font-bold mb-2">3. Buchen</h3>
+                <p class="text-gray-600">Bestätige die Buchung und freue dich auf ein unvergessliches Event!</p>
+            </div>
+        </div>
+    </div>
+</section>
+
+<?php $content = ob_get_clean(); ?>
+<?php $title = 'Home'; ?>
+<?php include __DIR__ . '/layouts/app.php'; ?>
@@ -0,0 +1,104 @@
+<!DOCTYPE html>
+<html lang="de" class="h-full">
+<head>
+    <meta charset="UTF-8">
+    <meta name="viewport" content="width=device-width, initial-scale=1.0">
+    <meta http-equiv="X-UA-Compatible" content="IE=edge">
+    <title><?= $title ?? 'GetYourBand' ?> - Bandvermittlung Schweiz</title>
+
+    <!-- Fonts -->
+    <link rel="preconnect" href="https://fonts.googleapis.com">
+    <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
+    <link href="https://fonts.googleapis.com/css2?family=Inter:wght@300;400;500;600;700&family=Poppins:wght@600;700;800&display=swap" rel="stylesheet">
+
+    <!-- Styles -->
+    <link rel="stylesheet" href="/dist/css/app.css">
+
+    <!-- Alpine.js -->
+    <script defer src="/dist/js/app.js"></script>
+</head>
+<body class="h-full">
+    <!-- Navigation -->
+    <nav class="bg-white shadow-sm sticky top-0 z-50">
+        <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8">
+            <div class="flex justify-between h-16">
+                <div class="flex items-center">
+                    <a href="/" class="text-2xl font-display font-bold text-primary-600">
+                        🎸 GetYourBand
+                    </a>
+                </div>
+
+                <div class="hidden md:flex items-center space-x-8">
+                    <a href="/" class="text-gray-700 hover:text-primary-600 transition">Home</a>
+                    <a href="/bands" class="text-gray-700 hover:text-primary-600 transition">Bands</a>
+
+                    <?php if (isset($_SESSION['user'])): ?>
+                        <a href="/profile" class="text-gray-700 hover:text-primary-600 transition">Profil</a>
+                        <form action="/logout" method="POST" class="inline">
+                            <?= csrf_field() ?>
+                            <button type="submit" class="btn btn-secondary">Logout</button>
+                        </form>
+                    <?php else: ?>
+                        <a href="/login" class="text-gray-700 hover:text-primary-600 transition">Login</a>
+                        <a href="/register" class="btn btn-primary">Registrieren</a>
+                    <?php endif; ?>
+                </div>
+            </div>
+        </div>
+    </nav>
+
+    <!-- Main Content -->
+    <main>
+        <?php if (isset($_SESSION['success'])): ?>
+            <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 mt-4">
+                <div class="bg-green-100 border border-green-400 text-green-700 px-4 py-3 rounded">
+                    <?= $_SESSION['success'] ?>
+                    <?php unset($_SESSION['success']); ?>
+                </div>
+            </div>
+        <?php endif; ?>
+
+        <?php if (isset($_SESSION['error'])): ?>
+            <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 mt-4">
+                <div class="bg-red-100 border border-red-400 text-red-700 px-4 py-3 rounded">
+                    <?= $_SESSION['error'] ?>
+                    <?php unset($_SESSION['error']); ?>
+                </div>
+            </div>
+        <?php endif; ?>
+
+        <?= $content ?? '' ?>
+    </main>
+
+    <!-- Footer -->
+    <footer class="bg-gray-900 text-white mt-20">
+        <div class="max-w-7xl mx-auto px-4 sm:px-6 lg:px-8 py-12">
+            <div class="grid grid-cols-1 md:grid-cols-3 gap-8">
+                <div>
+                    <h3 class="text-xl font-display font-bold text-primary-400 mb-4">GetYourBand</h3>
+                    <p class="text-gray-400">Die Plattform für professionelle Bandvermittlung in der Schweiz.</p>
+                </div>
+                <div>
+                    <h4 class="font-semibold mb-4">Links</h4>
+                    <ul class="space-y-2">
+                        <li><a href="/" class="text-gray-400 hover:text-white transition">Home</a></li>
+                        <li><a href="/bands" class="text-gray-400 hover:text-white transition">Bands</a></li>
+                        <li><a href="/register" class="text-gray-400 hover:text-white transition">Als Band registrieren</a></li>
+                    </ul>
+                </div>
+                <div>
+                    <h4 class="font-semibold mb-4">Rechtliches</h4>
+                    <ul class="space-y-2">
+                        <li><a href="/impressum" class="text-gray-400 hover:text-white transition">Impressum</a></li>
+                        <li><a href="/datenschutz" class="text-gray-400 hover:text-white transition">Datenschutz</a></li>
+                        <li><a href="/agb" class="text-gray-400 hover:text-white transition">AGB</a></li>
+                    </ul>
+                </div>
+            </div>
+            <div class="border-t border-gray-800 mt-8 pt-8 text-center text-gray-400">
+                <p>&copy; <?= date('Y') ?> GetYourBand. Alle Rechte vorbehalten.</p>
+            </div>
+        </div>
+    </footer>
+</body>
+</html>
@@ -0,0 +1,100 @@
+<?php
+
+/**
+ * Helper functions available globally
+ */
+
+if (!function_exists('env')) {
+    function env(string $key, $default = null)
+    {
+        return $_ENV[$key] ?? $default;
+    }
+}
+
+if (!function_exists('asset')) {
+    function asset(string $path): string
+    {
+        return '/' . ltrim($path, '/');
+    }
+}
+
+if (!function_exists('url')) {
+    function url(string $path = ''): string
+    {
+        $baseUrl = env('APP_URL', 'http://localhost');
+        return rtrim($baseUrl, '/') . '/' . ltrim($path, '/');
+    }
+}
+
+if (!function_exists('redirect')) {
+    function redirect(string $path): void
+    {
+        header("Location: {$path}");
+        exit;
+    }
+}
+
+if (!function_exists('old')) {
+    function old(string $key, $default = '')
+    {
+        return $_SESSION['old'][$key] ?? $default;
+    }
+}
+
+if (!function_exists('error')) {
+    function error(string $key): ?string
+    {
+        return $_SESSION['errors'][$key][0] ?? null;
+    }
+}
+
+if (!function_exists('csrf_token')) {
+    function csrf_token(): string
+    {
+        if (!isset($_SESSION['csrf_token'])) {
+            $_SESSION['csrf_token'] = bin2hex(random_bytes(32));
+        }
+        return $_SESSION['csrf_token'];
+    }
+}
+
+if (!function_exists('csrf_field')) {
+    function csrf_field(): string
+    {
+        return '<input type="hidden" name="csrf_token" value="' . csrf_token() . '">';
+    }
+}
+
+if (!function_exists('dd')) {
+    function dd(...$vars): void
+    {
+        foreach ($vars as $var) {
+            var_dump($var);
+        }
+        die();
+    }
+}
+
+if (!function_exists('formatPrice')) {
+    function formatPrice($price): string
+    {
+        return 'CHF ' . number_format($price, 2, '.', '\'');
+    }
+}
+
+if (!function_exists('formatDate')) {
+    function formatDate($date): string
+    {
+        return date('d.m.Y', strtotime($date));
+    }
+}
+
+if (!function_exists('generateSlug')) {
+    function generateSlug(string $text): string
+    {
+        $text = mb_strtolower($text, 'UTF-8');
+        $text = preg_replace('/[^a-z0-9\s-]/', '', $text);
+        $text = preg_replace('/[\s-]+/', '-', $text);
+        return trim($text, '-');
+    }
+}
@@ -0,0 +1,50 @@
+<?php
+
+// Start session
+session_start();
+
+// Load Composer autoloader
+require_once __DIR__ . '/vendor/autoload.php';
+
+// Load environment variables
+$dotenv = Dotenv\Dotenv::createImmutable(__DIR__);
+$dotenv->load();
+
+// Set timezone
+date_default_timezone_set('Europe/Zurich');
+
+// Error reporting based on environment
+if (env('APP_DEBUG', false)) {
+    error_reporting(E_ALL);
+    ini_set('display_errors', 1);
+} else {
+    error_reporting(0);
+    ini_set('display_errors', 0);
+}
+
+// Load configuration
+$config = [];
+$configFiles = glob(__DIR__ . '/config/*.php');
+foreach ($configFiles as $file) {
+    $key = basename($file, '.php');
+    $config[$key] = require $file;
+}
+
+// Make config globally accessible
+define('CONFIG', $config);
+
+// Helper function to access config
+function config(string $key, $default = null)
+{
+    $keys = explode('.', $key);
+    $value = CONFIG;
+
+    foreach ($keys as $k) {
+        if (!isset($value[$k])) {
+            return $default;
+        }
+        $value = $value[$k];
+    }
+
+    return $value;
+}
@@ -0,0 +1,40 @@
+{
+    "name": "getyourband/platform",
+    "description": "Modern band booking platform",
+    "type": "project",
+    "license": "proprietary",
+    "require": {
+        "php": ">=8.3",
+        "ext-pdo": "*",
+        "ext-mbstring": "*",
+        "ext-json": "*",
+        "vlucas/phpdotenv": "^5.6",
+        "twig/twig": "^3.8",
+        "phpmailer/phpmailer": "^6.9",
+        "respect/validation": "^2.3"
+    },
+    "require-dev": {
+        "phpunit/phpunit": "^10.5"
+    },
+    "autoload": {
+        "psr-4": {
+            "App\\": "app/",
+            "Database\\": "database/"
+        },
+        "files": [
+            "app/helpers.php"
+        ]
+    },
+    "config": {
+        "optimize-autoloader": true,
+        "preferred-install": "dist",
+        "sort-packages": true
+    },
+    "minimum-stability": "stable",
+    "prefer-stable": true,
+    "scripts": {
+        "post-autoload-dump": [
+            "@php -r \"file_exists('.env') || copy('.env.example', '.env');\""
+        ]
+    }
+}
@@ -0,0 +1,28 @@
+<?php
+
+return [
+    'name' => env('APP_NAME', 'GetYourBand'),
+    'env' => env('APP_ENV', 'production'),
+    'debug' => env('APP_DEBUG', false),
+    'url' => env('APP_URL', 'http://localhost'),
+
+    'timezone' => 'Europe/Zurich',
+    'locale' => 'de_CH',
+
+    'features' => [
+        'email_verification' => env('REQUIRE_EMAIL_VERIFICATION', true),
+        'band_approval' => env('REQUIRE_BAND_APPROVAL', true),
+        'reviews' => env('ENABLE_REVIEWS', true),
+        'payment' => env('PAYMENT_ENABLED', false),
+    ],
+
+    'upload' => [
+        'max_size' => env('MAX_UPLOAD_SIZE', 5242880), // 5MB
+        'allowed_images' => explode(',', env('ALLOWED_IMAGE_TYPES', 'jpg,jpeg,png,webp')),
+        'allowed_videos' => explode(',', env('ALLOWED_VIDEO_TYPES', 'mp4,webm')),
+    ],
+
+    'pagination' => [
+        'per_page' => 12,
+    ],
+];
@@ -0,0 +1,17 @@
+<?php
+
+return [
+    'connection' => env('DB_CONNECTION', 'mysql'),
+
+    'connections' => [
+        'mysql' => [
+            'host' => env('DB_HOST', '127.0.0.1'),
+            'port' => env('DB_PORT', '3306'),
+            'database' => env('DB_DATABASE', 'getyourband'),
+            'username' => env('DB_USERNAME', 'root'),
+            'password' => env('DB_PASSWORD', ''),
+            'charset' => 'utf8mb4',
+            'collation' => 'utf8mb4_unicode_ci',
+        ],
+    ],
+];
@@ -0,0 +1,63 @@
+<?php
+
+namespace Database;
+
+use PDO;
+use PDOException;
+
+class Database
+{
+    private static ?PDO $instance = null;
+
+    public static function connect(): PDO
+    {
+        if (self::$instance === null) {
+            try {
+                $host = $_ENV['DB_HOST'] ?? '127.0.0.1';
+                $port = $_ENV['DB_PORT'] ?? '3306';
+                $dbname = $_ENV['DB_DATABASE'] ?? 'getyourband';
+                $username = $_ENV['DB_USERNAME'] ?? 'root';
+                $password = $_ENV['DB_PASSWORD'] ?? '';
+
+                $dsn = "mysql:host={$host};port={$port};dbname={$dbname};charset=utf8mb4";
+
+                self::$instance = new PDO($dsn, $username, $password, [
+                    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
+                    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
+                    PDO::ATTR_EMULATE_PREPARES => false,
+                ]);
+            } catch (PDOException $e) {
+                throw new \RuntimeException("Database connection failed: " . $e->getMessage());
+            }
+        }
+
+        return self::$instance;
+    }
+
+    public static function disconnect(): void
+    {
+        self::$instance = null;
+    }
+
+    public static function runMigrations(string $migrationsPath): void
+    {
+        $db = self::connect();
+        $files = glob($migrationsPath . '/*.sql');
+        sort($files);
+
+        foreach ($files as $file) {
+            echo "Running migration: " . basename($file) . "\n";
+            $sql = file_get_contents($file);
+
+            try {
+                $db->exec($sql);
+                echo "✓ Migration completed successfully\n";
+            } catch (PDOException $e) {
+                echo "✗ Migration failed: " . $e->getMessage() . "\n";
+                throw $e;
+            }
+        }
+
+        echo "\nAll migrations completed!\n";
+    }
+}
@@ -0,0 +1,21 @@
+-- Migration: Create users table
+-- Created: 2025-12-02
+
+CREATE TABLE IF NOT EXISTS users (
+    id INT AUTO_INCREMENT PRIMARY KEY,
+    email VARCHAR(255) NOT NULL UNIQUE,
+    password VARCHAR(255) NOT NULL,
+    name VARCHAR(255) NOT NULL,
+    role ENUM('admin', 'band', 'customer') NOT NULL DEFAULT 'customer',
+    email_verified_at TIMESTAMP NULL,
+    verification_token VARCHAR(64) NULL,
+    reset_token VARCHAR(64) NULL,
+    reset_token_expires TIMESTAMP NULL,
+    is_active BOOLEAN DEFAULT TRUE,
+    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+    INDEX idx_email (email),
+    INDEX idx_role (role),
+    INDEX idx_verification_token (verification_token),
+    INDEX idx_reset_token (reset_token)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -0,0 +1,38 @@
+-- Migration: Create bands table
+-- Created: 2025-12-02
+
+CREATE TABLE IF NOT EXISTS bands (
+    id INT AUTO_INCREMENT PRIMARY KEY,
+    user_id INT NOT NULL,
+    name VARCHAR(255) NOT NULL,
+    slug VARCHAR(255) NOT NULL UNIQUE,
+    description TEXT,
+    genre VARCHAR(100),
+    location VARCHAR(255),
+    postal_code VARCHAR(10),
+    price_min DECIMAL(10, 2),
+    price_max DECIMAL(10, 2),
+    member_count INT,
+    phone VARCHAR(50),
+    website VARCHAR(255),
+    facebook VARCHAR(255),
+    instagram VARCHAR(255),
+    youtube VARCHAR(255),
+    profile_image VARCHAR(255),
+    cover_image VARCHAR(255),
+    is_approved BOOLEAN DEFAULT FALSE,
+    is_active BOOLEAN DEFAULT TRUE,
+    view_count INT DEFAULT 0,
+    average_rating DECIMAL(3, 2) DEFAULT 0.00,
+    total_reviews INT DEFAULT 0,
+    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
+    INDEX idx_slug (slug),
+    INDEX idx_genre (genre),
+    INDEX idx_location (location),
+    INDEX idx_postal_code (postal_code),
+    INDEX idx_is_approved (is_approved),
+    INDEX idx_average_rating (average_rating),
+    FULLTEXT idx_search (name, description, genre)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -0,0 +1,17 @@
+-- Migration: Create band_media table
+-- Created: 2025-12-02
+
+CREATE TABLE IF NOT EXISTS band_media (
+    id INT AUTO_INCREMENT PRIMARY KEY,
+    band_id INT NOT NULL,
+    type ENUM('image', 'video') NOT NULL,
+    url VARCHAR(500) NOT NULL,
+    title VARCHAR(255),
+    is_featured BOOLEAN DEFAULT FALSE,
+    sort_order INT DEFAULT 0,
+    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    FOREIGN KEY (band_id) REFERENCES bands(id) ON DELETE CASCADE,
+    INDEX idx_band_id (band_id),
+    INDEX idx_type (type),
+    INDEX idx_sort_order (sort_order)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -0,0 +1,26 @@
+-- Migration: Create bookings table
+-- Created: 2025-12-02
+
+CREATE TABLE IF NOT EXISTS bookings (
+    id INT AUTO_INCREMENT PRIMARY KEY,
+    band_id INT NOT NULL,
+    customer_id INT NOT NULL,
+    event_date DATE NOT NULL,
+    event_time TIME,
+    event_location VARCHAR(255) NOT NULL,
+    event_type VARCHAR(100),
+    budget DECIMAL(10, 2),
+    guest_count INT,
+    message TEXT,
+    status ENUM('pending', 'accepted', 'rejected', 'completed', 'cancelled') DEFAULT 'pending',
+    band_response TEXT,
+    responded_at TIMESTAMP NULL,
+    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+    FOREIGN KEY (band_id) REFERENCES bands(id) ON DELETE CASCADE,
+    FOREIGN KEY (customer_id) REFERENCES users(id) ON DELETE CASCADE,
+    INDEX idx_band_id (band_id),
+    INDEX idx_customer_id (customer_id),
+    INDEX idx_status (status),
+    INDEX idx_event_date (event_date)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -0,0 +1,23 @@
+-- Migration: Create reviews table
+-- Created: 2025-12-02
+
+CREATE TABLE IF NOT EXISTS reviews (
+    id INT AUTO_INCREMENT PRIMARY KEY,
+    band_id INT NOT NULL,
+    booking_id INT NOT NULL,
+    customer_id INT NOT NULL,
+    rating INT NOT NULL CHECK (rating BETWEEN 1 AND 5),
+    comment TEXT,
+    is_approved BOOLEAN DEFAULT FALSE,
+    is_visible BOOLEAN DEFAULT TRUE,
+    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+    FOREIGN KEY (band_id) REFERENCES bands(id) ON DELETE CASCADE,
+    FOREIGN KEY (booking_id) REFERENCES bookings(id) ON DELETE CASCADE,
+    FOREIGN KEY (customer_id) REFERENCES users(id) ON DELETE CASCADE,
+    UNIQUE KEY unique_booking_review (booking_id),
+    INDEX idx_band_id (band_id),
+    INDEX idx_customer_id (customer_id),
+    INDEX idx_rating (rating),
+    INDEX idx_is_approved (is_approved)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -0,0 +1,16 @@
+-- Migration: Create band_availability table
+-- Created: 2025-12-02
+
+CREATE TABLE IF NOT EXISTS band_availability (
+    id INT AUTO_INCREMENT PRIMARY KEY,
+    band_id INT NOT NULL,
+    date DATE NOT NULL,
+    is_available BOOLEAN DEFAULT TRUE,
+    notes VARCHAR(255),
+    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+    FOREIGN KEY (band_id) REFERENCES bands(id) ON DELETE CASCADE,
+    UNIQUE KEY unique_band_date (band_id, date),
+    INDEX idx_band_id (band_id),
+    INDEX idx_date (date)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -0,0 +1,20 @@
+#!/usr/bin/env php
+<?php
+
+require __DIR__ . '/vendor/autoload.php';
+
+use Database\Database;
+use Dotenv\Dotenv;
+
+// Load environment variables
+$dotenv = Dotenv::createImmutable(__DIR__);
+$dotenv->load();
+
+try {
+    echo "Starting database migrations...\n\n";
+    Database::runMigrations(__DIR__ . '/database/migrations');
+    echo "\n✓ All migrations completed successfully!\n";
+} catch (Exception $e) {
+    echo "\n✗ Migration failed: " . $e->getMessage() . "\n";
+    exit(1);
+}
@@ -0,0 +1,22 @@
+{
+  "name": "getyourband-platform",
+  "version": "1.0.0",
+  "description": "Modern band booking platform",
+  "private": true,
+  "scripts": {
+    "dev": "vite",
+    "build": "vite build",
+    "watch": "vite build --watch"
+  },
+  "devDependencies": {
+    "vite": "^5.0.0",
+    "tailwindcss": "^3.4.0",
+    "postcss": "^8.4.32",
+    "autoprefixer": "^10.4.16",
+    "@tailwindcss/forms": "^0.5.7",
+    "@tailwindcss/typography": "^0.5.10"
+  },
+  "dependencies": {
+    "alpinejs": "^3.13.3"
+  }
+}
@@ -0,0 +1,6 @@
+export default {
+  plugins: {
+    tailwindcss: {},
+    autoprefixer: {},
+  },
+}
@@ -0,0 +1,31 @@
+RewriteEngine On
+
+# Redirect all requests to index.php
+RewriteCond %{REQUEST_FILENAME} !-f
+RewriteCond %{REQUEST_FILENAME} !-d
+RewriteRule ^(.*)$ index.php [L,QSA]
+
+# Security headers
+<IfModule mod_headers.c>
+    Header set X-Content-Type-Options "nosniff"
+    Header set X-Frame-Options "SAMEORIGIN"
+    Header set X-XSS-Protection "1; mode=block"
+</IfModule>
+
+# Disable directory browsing
+Options -Indexes
+
+# Compress assets
+<IfModule mod_deflate.c>
+    AddOutputFilterByType DEFLATE text/html text/plain text/xml text/css text/javascript application/javascript application/json
+</IfModule>
+
+# Browser caching
+<IfModule mod_expires.c>
+    ExpiresActive On
+    ExpiresByType image/jpeg "access plus 1 year"
+    ExpiresByType image/png "access plus 1 year"
+    ExpiresByType image/webp "access plus 1 year"
+    ExpiresByType text/css "access plus 1 month"
+    ExpiresByType application/javascript "access plus 1 month"
+</IfModule>
@@ -0,0 +1,28 @@
+<?php
+
+require_once __DIR__ . '/../bootstrap.php';
+
+use App\Core\Router;
+
+// Initialize router
+$router = new Router();
+
+// Load routes
+require_once __DIR__ . '/../routes/web.php';
+
+// Dispatch request
+$requestMethod = $_SERVER['REQUEST_METHOD'];
+$requestUri = $_SERVER['REQUEST_URI'];
+
+try {
+    $router->dispatch($requestMethod, $requestUri);
+} catch (Exception $e) {
+    if (config('app.debug')) {
+        echo "<h1>Error</h1>";
+        echo "<p>{$e->getMessage()}</p>";
+        echo "<pre>{$e->getTraceAsString()}</pre>";
+    } else {
+        http_response_code(500);
+        echo "500 - Internal Server Error";
+    }
+}
@@ -0,0 +1,49 @@
+@tailwind base;
+@tailwind components;
+@tailwind utilities;
+
+@layer base {
+  html {
+    @apply scroll-smooth;
+  }
+
+  body {
+    @apply bg-gray-50 text-gray-900 antialiased;
+  }
+}
+
+@layer components {
+  .btn {
+    @apply px-4 py-2 rounded-lg font-medium transition-all duration-200 inline-flex items-center justify-center;
+  }
+
+  .btn-primary {
+    @apply bg-primary-500 text-white hover:bg-primary-600 active:bg-primary-700;
+  }
+
+  .btn-secondary {
+    @apply bg-gray-200 text-gray-800 hover:bg-gray-300 active:bg-gray-400;
+  }
+
+  .card {
+    @apply bg-white rounded-xl shadow-md p-6 transition-shadow hover:shadow-lg;
+  }
+
+  .input-field {
+    @apply w-full px-4 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-primary-500 focus:border-transparent;
+  }
+
+  .badge {
+    @apply inline-flex items-center px-3 py-1 rounded-full text-sm font-medium;
+  }
+
+  .badge-yellow {
+    @apply bg-accent-100 text-accent-800;
+  }
+}
+
+@layer utilities {
+  .text-balance {
+    text-wrap: balance;
+  }
+}
@@ -0,0 +1,99 @@
+import Alpine from 'alpinejs';
+
+// Make Alpine available globally
+window.Alpine = Alpine;
+
+// Alpine Components
+Alpine.data('searchBands', () => ({
+  query: '',
+  filters: {
+    genre: '',
+    location: '',
+    priceMin: '',
+    priceMax: '',
+  },
+  results: [],
+  loading: false,
+
+  init() {
+    console.log('Search component initialized');
+  },
+
+  async search() {
+    this.loading = true;
+    try {
+      const params = new URLSearchParams({
+        q: this.query,
+        ...this.filters
+      });
+      const response = await fetch(`/api/bands/search?${params}`);
+      this.results = await response.json();
+    } catch (error) {
+      console.error('Search error:', error);
+    } finally {
+      this.loading = false;
+    }
+  }
+}));
+
+Alpine.data('bookingForm', () => ({
+  formData: {
+    bandId: '',
+    eventDate: '',
+    location: '',
+    budget: '',
+    eventType: '',
+    message: ''
+  },
+  submitting: false,
+
+  async submit() {
+    this.submitting = true;
+    try {
+      const response = await fetch('/api/bookings', {
+        method: 'POST',
+        headers: {
+          'Content-Type': 'application/json',
+        },
+        body: JSON.stringify(this.formData)
+      });
+
+      if (response.ok) {
+        alert('Buchungsanfrage erfolgreich gesendet!');
+        this.reset();
+      }
+    } catch (error) {
+      console.error('Booking error:', error);
+      alert('Es gab einen Fehler. Bitte versuchen Sie es erneut.');
+    } finally {
+      this.submitting = false;
+    }
+  },
+
+  reset() {
+    this.formData = {
+      bandId: '',
+      eventDate: '',
+      location: '',
+      budget: '',
+      eventType: '',
+      message: ''
+    };
+  }
+}));
+
+// Initialize Alpine
+Alpine.start();
+
+// Smooth scroll for anchor links
+document.addEventListener('DOMContentLoaded', () => {
+  document.querySelectorAll('a[href^="#"]').forEach(anchor => {
+    anchor.addEventListener('click', function (e) {
+      e.preventDefault();
+      const target = document.querySelector(this.getAttribute('href'));
+      if (target) {
+        target.scrollIntoView({ behavior: 'smooth' });
+      }
+    });
+  });
+});
@@ -0,0 +1,49 @@
+<?php
+
+use App\Controllers\HomeController;
+use App\Controllers\BandController;
+use App\Controllers\BookingController;
+use App\Controllers\AuthController;
+use App\Controllers\ProfileController;
+use App\Controllers\Admin\AdminController;
+
+// Public routes
+$router->get('/', [HomeController::class, 'index']);
+$router->get('/bands', [BandController::class, 'index']);
+$router->get('/bands/{slug}', [BandController::class, 'show']);
+
+// Authentication routes
+$router->get('/login', [AuthController::class, 'showLogin']);
+$router->post('/login', [AuthController::class, 'login']);
+$router->get('/register', [AuthController::class, 'showRegister']);
+$router->post('/register', [AuthController::class, 'register']);
+$router->post('/logout', [AuthController::class, 'logout']);
+$router->get('/verify-email/{token}', [AuthController::class, 'verifyEmail']);
+
+// Protected routes (require authentication)
+$router->group(['middleware' => 'auth'], function($router) {
+    // Profile
+    $router->get('/profile', [ProfileController::class, 'show']);
+    $router->post('/profile/update', [ProfileController::class, 'update']);
+
+    // Booking routes
+    $router->post('/bookings/create', [BookingController::class, 'create']);
+    $router->get('/my-bookings', [BookingController::class, 'myBookings']);
+
+    // Band management (for band users)
+    $router->group(['middleware' => 'role:band'], function($router) {
+        $router->get('/band/manage', [BandController::class, 'manage']);
+        $router->post('/band/update', [BandController::class, 'update']);
+        $router->get('/band/bookings', [BookingController::class, 'bandBookings']);
+        $router->post('/band/bookings/{id}/respond', [BookingController::class, 'respond']);
+    });
+
+    // Admin routes
+    $router->group(['middleware' => 'role:admin'], function($router) {
+        $router->get('/admin', [AdminController::class, 'dashboard']);
+        $router->get('/admin/bands', [AdminController::class, 'bands']);
+        $router->post('/admin/bands/{id}/approve', [AdminController::class, 'approveBand']);
+        $router->get('/admin/reviews', [AdminController::class, 'reviews']);
+        $router->post('/admin/reviews/{id}/moderate', [AdminController::class, 'moderateReview']);
+    });
+});
@@ -0,0 +1,45 @@
+/** @type {import('tailwindcss').Config} */
+export default {
+  content: [
+    "./app/Views/**/*.php",
+    "./public/**/*.js",
+  ],
+  theme: {
+    extend: {
+      colors: {
+        primary: {
+          50: '#fffbeb',
+          100: '#fef3c7',
+          200: '#fde68a',
+          300: '#fcd34d',
+          400: '#fbbf24',
+          500: '#f59e0b',
+          600: '#d97706',
+          700: '#b45309',
+          800: '#92400e',
+          900: '#78350f',
+        },
+        accent: {
+          50: '#fefce8',
+          100: '#fef9c3',
+          200: '#fef08a',
+          300: '#fde047',
+          400: '#facc15',
+          500: '#eab308',
+          600: '#ca8a04',
+          700: '#a16207',
+          800: '#854d0e',
+          900: '#713f12',
+        }
+      },
+      fontFamily: {
+        sans: ['Inter', 'system-ui', 'sans-serif'],
+        display: ['Poppins', 'system-ui', 'sans-serif'],
+      },
+    },
+  },
+  plugins: [
+    require('@tailwindcss/forms'),
+    require('@tailwindcss/typography'),
+  ],
+}
@@ -0,0 +1,31 @@
+import { defineConfig } from 'vite';
+import path from 'path';
+
+export default defineConfig({
+  root: '.',
+  build: {
+    outDir: 'public/dist',
+    emptyOutDir: true,
+    manifest: true,
+    rollupOptions: {
+      input: {
+        main: path.resolve(__dirname, 'resources/js/app.js'),
+        css: path.resolve(__dirname, 'resources/css/app.css'),
+      },
+      output: {
+        entryFileNames: 'js/[name].[hash].js',
+        chunkFileNames: 'js/[name].[hash].js',
+        assetFileNames: (assetInfo) => {
+          if (assetInfo.name.endsWith('.css')) {
+            return 'css/[name].[hash][extname]';
+          }
+          return 'assets/[name].[hash][extname]';
+        },
+      },
+    },
+  },
+  server: {
+    port: 3000,
+    strictPort: false,
+  },
+});