<?php
define('DB_HOST', $_ENV['DB_HOST'] ?? '127.0.0.1');
define('DB_PORT', $_ENV['DB_PORT'] ?? '3306');
define('DB_NAME', $_ENV['DB_NAME'] ?? 'dropbymatte');
define('DB_USER', $_ENV['DB_USER'] ?? 'root');
define('DB_PASS', $_ENV['DB_PASS'] ?? '');

$dsn = "mysql:host=" . DB_HOST . ";port=" . DB_PORT . ";dbname=" . DB_NAME;

try {
    $pdo = new PDO($dsn, DB_USER, DB_PASS, [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        // FIX macOS socket
        PDO::MYSQL_ATTR_INIT_COMMAND => "SET SESSION wait_timeout=28800"
    ]);
} catch(PDOException $e) {
    error_log("DB Error: " . $e->getMessage());
    http_response_code(500);
    echo "❌ Errore DB: " . $e->getMessage() . "<br>";
    echo "Host: " . DB_HOST . ":" . DB_PORT . "<br>";
    echo "Debug: Verifica che MySQL sia in esecuzione: `brew services list | grep mysql`";
    exit;
}
?>