View Code - 20260721

db.php | 20260721_154032.php Initial Bulk Import

<?php
// /erp/core/db.php

if (isset($pdo) && $pdo instanceof PDO) { return; }

error_reporting(E_ALL);
ini_set('display_errors', 1);

$paths = [
    dirname(__DIR__).'/Config.php',
    dirname(__DIR__).'/config.php',
    __DIR__.'/Config.php',
    __DIR__.'/config.php'
];

foreach ($paths as $p) {
    if (file_exists($p)) {
        require_once $p;
        break;
    }
}

if (!defined('DB_HOST')) {
    http_response_code(500);
    echo 'Missing /erp/config.php';
    exit;
}

try {

$dsn = 'mysql:host='.DB_HOST.';dbname='.DB_NAME.';charset=utf8mb4';

$pdo = new PDO(
        $dsn,
        DB_USER,
        DB_PASS,
        [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
        ]
    );

/* ---- ADD THIS PART ---- */
    date_default_timezone_set('Asia/Kolkata');
    $pdo->exec("SET time_zone = '+05:30'");
    /* ----------------------- */

} catch (Throwable $e) {
    http_response_code(500);
    echo 'DB connection failed.';
    if (ini_get('display_errors')) {
        echo '<pre>'.$e->getMessage().'</pre>';
    }
    exit;
}