<?php
// Database Configuration
define('DB_HOST', 'localhost');
define('DB_USER', 'bonipedi_jok');
define('DB_PASS', 'Wahyu100406');
define('DB_NAME', 'bonipedi_jok');

$pdo = null;
try {
    $pdo = new PDO(
        "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8mb4",
        DB_USER,
        DB_PASS,
        [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
            PDO::ATTR_EMULATE_PREPARES => false,
        ]
    );
} catch (PDOException $e) {
    die(json_encode(['error' => 'Database connection failed: ' . $e->getMessage()]));
}

// Site Settings helper
function getSetting($key, $pdo) {
    $stmt = $pdo->prepare("SELECT value FROM settings WHERE key_name = ?");
    $stmt->execute([$key]);
    $row = $stmt->fetch();
    return $row ? $row['value'] : '';
}

function getAllSettings($pdo) {
    $stmt = $pdo->query("SELECT key_name, value FROM settings");
    $settings = [];
    while ($row = $stmt->fetch()) {
        $settings[$row['key_name']] = $row['value'];
    }
    return $settings;
}

// Base URL
define('BASE_URL', '/kursi');
define('SITE_ROOT', dirname(__DIR__));
