🚀 PHP + Apache + MySQL

<h1>🚀 PHP + Apache + MySQL</h1>
echo "<p>PHP Version: " . phpversion() . "</p>";

// Проверяем доступные расширения
echo "<h3>PHP Extensions:</h3>";
echo "<p>MySQLi: " . (extension_loaded('mysqli') ? '✅ Available' : '❌ Not Available') . "</p>";
echo "<p>PDO: " . (extension_loaded('pdo') ? '✅ Available' : '❌ Not Available') . "</p>";
echo "<p>PDO MySQL: " . (extension_loaded('pdo_mysql') ? '✅ Available' : '❌ Not Available') . "</p>";

// Проверяем подключение к БД
try {
    $db_host = getenv('DB_HOST') ?: 'mysql';
    $db_user = getenv('DB_USER') ?: 'botuser';
    $db_password = getenv('DB_PASSWORD') ?: 'botpassword';
    $db_name = getenv('DB_NAME') ?: 'telegram_bot';
    
    echo "<p>Trying to connect to: mysql:host=$db_host;dbname=$db_name</p>";
    
    $pdo = new PDO("mysql:host=$db_host;dbname=$db_name;charset=utf8mb4", $db_user, $db_password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    echo "<p style='color: green;'>✅ Database Connection: Successful</p>";
    
    // Проверяем таблицу users
    $stmt = $pdo->query("SELECT COUNT(*) as count FROM users");
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    echo "<p>Users Table: ✅ Exists (" . $result['count'] . " users)</p>";
    
    // Показываем пользователей
    $stmt = $pdo->query("SELECT user_id, username, first_name FROM users");
    echo "<h3>Users in database:</h3>";
    echo "<ul>";
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        echo "<li>" . htmlspecialchars($row['first_name']) . " (@". htmlspecialchars($row['username']) . ")</li>";
    }
    echo "</ul>";
    
} catch (PDOException $e) {
    echo "<p style='color: red;'>❌ Database Connection Failed: " . $e->getMessage() . "</p>";
}

echo "<p>Server Time: " . date('Y-m-d H:i:s') . "</p>";