27 lines
894 B
PHP
27 lines
894 B
PHP
<?php
|
|
session_start();
|
|
$host = 'localhost';
|
|
$user = 'root';
|
|
$pass = '@Samui@10742'; // Leave empty or set to user's local mysql root password
|
|
$db = 'narenthorn_samui';
|
|
|
|
try {
|
|
$pdo = new PDO("mysql:host=$host;dbname=$db;charset=utf8mb4", $user, $pass);
|
|
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
|
|
} catch (PDOException $e) {
|
|
die("Database connection failed: " . $e->getMessage());
|
|
}
|
|
|
|
// Global settings function
|
|
function getSetting($pdo, $key, $default = '') {
|
|
try {
|
|
$stmt = $pdo->prepare("SELECT setting_value FROM settings WHERE setting_key = ?");
|
|
$stmt->execute([$key]);
|
|
$result = $stmt->fetchColumn();
|
|
return $result !== false ? $result : $default;
|
|
} catch (PDOException $e) {
|
|
return $default; // Settings table might not exist yet
|
|
}
|
|
}
|