index.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Список варнов</title>
    <style>
        body {
            font-family: Arial, sans-serif;
            background-color: #333;
            color: #eee;
            margin: 0;
            padding: 20px;
        }

        .container {
            max-width: 800px;
            margin: 0 auto;
        }

        table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 20px;
        }

        th,
        td {
            padding: 8px;
            text-align: left;
            border-bottom: 1px solid #666;
        }

        th {
            background-color: #444;
        }

        tr:nth-child(even) {
            background-color: #555;
        }

        tr:hover {
            background-color: #777;
        }

        h1 {
            text-align: center;
        }
    </style>
</head>
<body>
    <div class="container">
        <h1>Список варнов</h1>
        <table>
            <thead>
                <tr>
                    <th>ID</th>
                    <th>Игрок</th>
                    <th>Истекает</th>
                    <th>Причина</th>
                    <th>Выдал</th>
                </tr>
            </thead>
            <tbody id="warns-table-body">
                <?php
                    $servername = "localhost";
                    $username = "jd";
                    $password = "rWsB9Q";
                    $dbname = "sw";

                    $conn = new mysqli($servername, $username, $password, $dbname);


                    if ($conn->connect_error) {
                        die("Ошибка подключения к базе данных: " . $conn->connect_error);
                    }

                    $sql = "SELECT * FROM warns";
                    $result = $conn->query($sql);

                    if ($result->num_rows > 0) {
                        while($row = $result->fetch_assoc()) {
                            echo "<tr>";
                            echo "<td>" . $row["warnID"] . "</td>";
                            echo "<td>" . $row["playerName"] . "</td>";
                            echo "<td>" . $row["expiry"] . "</td>";
                            echo "<td>" . $row["reason"] . "</td>";
                            echo "<td>" . $row["issuer"] . "</td>";
                            echo "</tr>";
                        }
                    } else {
                        echo "<tr><td colspan='5'>Нет варнов в базе данных.</td></tr>";
                    }
                    $conn->close();
                ?>
            </tbody>
        </table>
    </div>
    <script>
        setInterval(function() {
            location.reload();
        }, 5000);
    </script>
</body>
</html>