db.php

<?php
ini_set('display_errors', '0');
error_reporting(E_ALL);

function env($key, $default = null) {
  static $vars;
  if ($vars === null) {
    $vars = [];
    $envPath = __DIR__ . '/.env';
    if (is_readable($envPath)) {
      foreach (file($envPath, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES) as $line) {
        if (str_starts_with(trim($line), '#')) continue;
        [$k, $v] = array_pad(explode('=', $line, 2), 2, null);
        $vars[trim($k)] = $v !== null ? trim($v) : '';
      }
    }
  }
  return $vars[$key] ?? $default;
}

function db() {
  static $pdo;
  if ($pdo) return $pdo;

  $host = env('DB_HOST', '127.0.0.1');
  $name = env('DB_NAME', 'dashboard_demo');
  $user = env('DB_USER', 'demo_user');
  $pass = env('DB_PASS', 'demo_pass');

  $dsn  = "mysql:host=$host;dbname=$name;charset=utf8mb4";
  $opts = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
  ];

  $pdo = new PDO($dsn, $user, $pass, $opts);
  return $pdo;
}