<?php
// db.php
require_once __DIR__ . '/config.php';

try {
    $pdo = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8mb4", DB_USER, DB_PASS);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
} catch (PDOException $e) {
    // สำหรับการตั้งค่าเริ่มต้น ถ้ายังไม่มี DB
    // die("Database connection failed: " . $e->getMessage());
    $pdo = null;
}

function logActivity($pdo, $action, $details) {
    if (!$pdo) return;
    $stmt = $pdo->prepare("INSERT INTO activity_logs (action_type, action_details) VALUES (?, ?)");
    $stmt->execute([$action, $details]);
}

function getSetting($pdo, $key) {
    if (!$pdo) return '';
    $stmt = $pdo->prepare("SELECT setting_value FROM settings WHERE setting_key = ?");
    $stmt->execute([$key]);
    return $stmt->fetchColumn();
}