🔧 Environment & Database Diagnostic Tool"; echo "

HTTP_HOST: " . htmlspecialchars($_SERVER['HTTP_HOST'] ?? 'None') . "

"; echo "

REQUEST_URI: " . htmlspecialchars($_SERVER['REQUEST_URI'] ?? 'None') . "

"; echo "

SCRIPT_NAME: " . htmlspecialchars($_SERVER['SCRIPT_NAME'] ?? 'None') . "

"; echo "

APP_URL: " . htmlspecialchars(APP_URL) . "

"; echo "

DB_HOST: " . htmlspecialchars(DB_HOST) . "

"; echo "

DB_PORT: " . htmlspecialchars(DB_PORT) . "

"; echo "

DB_NAME: " . htmlspecialchars(DB_NAME) . "

"; echo "

DB_USER: " . htmlspecialchars(DB_USER) . "

"; echo "

Testing PDO Connection...

"; $dsn = "mysql:host=" . DB_HOST . ";port=" . DB_PORT . ";dbname=" . DB_NAME . ";charset=" . DB_CHARSET; try { $pdo = new PDO($dsn, DB_USER, DB_PASS, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ]); echo "

✅ Database Connected Successfully!

"; // Check tables $stmt = $pdo->query("SHOW TABLES"); $tables = $stmt->fetchAll(PDO::FETCH_COLUMN); echo "

Found " . count($tables) . " tables in " . DB_NAME . ":

"; echo "

" . htmlspecialchars($t) . "

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

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

"; echo "

Trying fallback to 127.0.0.1 instead of localhost:

"; $dsn2 = "mysql:host=127.0.0.1;port=" . DB_PORT . ";dbname=" . DB_NAME . ";charset=" . DB_CHARSET; try { $pdo2 = new PDO($dsn2, DB_USER, DB_PASS, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ]); echo "

✅ Connected via 127.0.0.1! (DB_HOST ควรเปลี่ยนเป็น 127.0.0.1)

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

127.0.0.1 also failed: " . htmlspecialchars($e2->getMessage()) . "

"; } }