<?php
/**
 * Database Configuration
 * MariaDB / MySQL
 */

$current_host = $_SERVER['HTTP_HOST'] ?? '';
$is_production = (strpos($current_host, 'webapp69.cm.in.th') !== false);

if ($is_production) {
    // Production (Server) Configuration
    return [
        'host' => 'localhost',
        'port' => 3306,
        'dbname' => 'shop69319090028',
        'username' => 'u69319090028',
        'password' => '@6928',
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'options' => [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
            PDO::ATTR_EMULATE_PREPARES => false,
            PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci"
        ]
    ];
} else {
    // Local (XAMPP) Configuration
    return [
        'host' => '127.0.0.1',
        'port' => 3306,
        'dbname' => 'shop9',
        'username' => 'root',
        'password' => '',
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'options' => [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
            PDO::ATTR_EMULATE_PREPARES => false,
            PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci"
        ]
    ];
}