<!DOCTYPE HTML>
<html>
    <head>
        <title>Гостевая книга</title>
        <meta charset="UTF-8">
    </head>
    <body>
        <?php
            $user = 'test';
            $password = 'test';
            $db = new PDO('mysql:host=127.0.0.1;dbname=testdb;charset=UTF8', $user, $password);


            $stmt = $db->query('SELECT username, message FROM posts');
            
            while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
                $username = htmlspecialchars($row['username']);
                $message = htmlspecialchars($row['message']);

                echo "<div style='margin-bottom: 10px;'>
                        <div>$username</div>
                        <div>$message</div>
                      </div>";
            }

            $db = null;
        ?>

        <form method="POST" action="/create.php">
            <div>
                <label>Введите Ваше имя:</label><br>
                <input type="text" name="username">
            </div>

            <div>
                <label>Введите сообщение:</label><br>
                <input type="text" name="message">
            </div>

            <input type="submit" name="okbutton" value="Отправить">
        </form>
    </body>
</html>