Database Connection Test"; try { $pdo = new PDO( "mysql:host=$host;dbname=$dbname;charset=utf8mb4", $user, $pass, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false ] ); echo "

✅ Connection successful! Database is accessible.

"; // Optional: List tables to confirm schema $stmt = $pdo->query("SHOW TABLES"); $tables = $stmt->fetchAll(PDO::FETCH_COLUMN); echo "

Tables found: " . implode(', ', $tables) . "

"; } catch (PDOException $e) { echo "

❌ Connection failed: " . htmlspecialchars($e->getMessage()) . "

"; echo "

Host: $host | DB: $dbname | User: $user

"; // Common errors: // - "Access denied" = Wrong username/password // - "Unknown database" = DB doesn't exist // - "Can't connect to MySQL" = Host/server issue } ?>