soil-report-ai/config/database.php

<?php
/**
 * config/database.php
 *
 * Database configuration and PDO instance.
 */

// Database configuration
define('DB_HOST', 'localhost');
define('DB_NAME', 'cropmonitor');
define('DB_USER', 'cropmonitor');
define('DB_PASS', 'brvnCcaEYxlPCS3');
define('DB_CHARSET', 'utf8');

// Create PDO instance
try {
    $pdo = new PDO(
        "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=" . DB_CHARSET,
        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) {
    error_log("Database connection failed: " . $e->getMessage());
    die("Database connection failed. Please try again later.");
}
?>