<?php
// /app/config/database.php

define('DB_HOST', '127.0.0.1:3306');
define('DB_NAME', 'u176134211_founder'); // Replace with Hostinger DB Name
define('DB_USER', 'u176134211_founder');         // Replace with Hostinger User
define('DB_PASS', 'Ayushi@0337##');  // Replace with Hostinger Pass

try {
    $pdo = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8", DB_USER, DB_PASS);
    
    // Set PDO to throw exceptions on error
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    // Set default fetch mode to associative array
    $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);

} catch (PDOException $e) {
    // Log error to file instead of showing to user (Security)
    error_log("Connection Failed: " . $e->getMessage(), 3, __DIR__ . '/../../storage/logs/error.log');
    die("Database connection error. Please try again later.");
}
?>