<?php
/**
 * Shop (Client) Database Connection
 * Used by member portal to read survey assignments and project data from rrshop DB
 * Location: /shop-db-config.php (root of relevantreflex.com)
 */

function getShopDBConnection() {
    static $shopPdo = null;
    
    if ($shopPdo === null) {
        try {
            $shopPdo = new PDO(
                'mysql:host=localhost;dbname=u752449863_rrshop;charset=utf8mb4',
                'u752449863_rradmin',
                'S@n@h2016',
                [
                    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
                    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
                    PDO::ATTR_EMULATE_PREPARES => false
                ]
            );
        } catch (PDOException $e) {
            error_log("Shop database connection failed: " . $e->getMessage());
            return null;
        }
    }
    
    return $shopPdo;
}