getDefaultProperties(); if ($is_local) { $host = $props['local_host'] ?? 'localhost'; $db_name = $props['local_name'] ?? ''; $username = $props['local_user'] ?? ''; $password = $props['local_pass'] ?? ''; } else { $host = $props['prod_host'] ?? 'localhost'; $db_name = $props['prod_name'] ?? ''; $username = $props['prod_user'] ?? ''; $password = $props['prod_pass'] ?? ''; } } } // 4. Test MySQL PDO Connection $conn_status = "NOT TESTED"; $pdo_error_code = "-"; $pdo_error_msg = "-"; $server_version = "-"; $tables = []; if ($pdo_mysql_installed && $config_loaded) { try { $dsn = "mysql:host={$host};dbname={$db_name};charset=utf8mb4"; $pdo = new PDO($dsn, $username, $password, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_TIMEOUT => 5 ]); $conn_status = "SUCCESS"; $server_version = $pdo->getAttribute(PDO::ATTR_SERVER_VERSION); // Query list of tables $stmt = $pdo->query("SHOW TABLES"); $tables = $stmt->fetchAll(PDO::FETCH_COLUMN); } catch (PDOException $e) { $conn_status = "FAILED"; $pdo_error_code = $e->getCode(); // Strip sensitive password from error message if present $msg = $e->getMessage(); if (!empty($password)) { $msg = str_replace($password, '********', $msg); } $pdo_error_msg = $msg; } } ?> Database Diagnostic Test (test_db.php)

Database Diagnostic Test

Environment:
PHP Version:
PDO Extension: Enabled' : 'Missing'; ?>
PDO MySQL Driver: Installed' : 'Not Installed'; ?>
Config File (config/db.php): Loaded' : 'Not Found'; ?>
Database Host:
Database Name:
Database User:
Database Password:
Connection Status: SUCCESS FAILED
MySQL Server Version:
Existing Tables in Database ():
0): ?> No tables found. Please import schema.sql
Connection Error Details:
PDO Error Code:
PDO Error Message:
🔒 Security Warning: This diagnostic tool does NOT expose passwords. Please delete test_db.php after testing is completed.