<?php
// Portfolio - Database Connection Configuration (PHP PDO)

$host = 'localhost';
$db   = 'mura_shop';
$user = 'root';
$pass = '';
$charset = 'utf8mb4';

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

try {
     $pdo = new PDO($dsn, $user, $pass, $options);
     
     // Create table if not exists
     $sql = "CREATE TABLE IF NOT EXISTS `portfolio_contacts` (
         `id` INT AUTO_INCREMENT PRIMARY KEY,
         `name` VARCHAR(100) NOT NULL,
         `email` VARCHAR(100) NOT NULL,
         `message` TEXT NOT NULL,
         `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
     ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
     $pdo->exec($sql);
} catch (\PDOException $e) {
     // If connection fails, we log it and fallback to local file logging in contact.php
     $pdo = null;
}
?>