query("SELECT posts.title, posts.content, posts.created_at, users.username FROM posts JOIN users ON posts.user_id = users.id ORDER BY posts.created_at DESC"); echo "

Forum Æternum

"; if (isset($_SESSION['user'])) { echo "

Eingeloggt als: " . $_SESSION['user'] . " | Logout

"; } else { echo "Login | Registrieren"; } echo "

"; foreach($posts as $post) { echo '

' . htmlspecialchars($post['title']) . '

'; echo '

von ' . htmlspecialchars($post['username']) . ' am ' . $post['created_at'] . '

'; echo '

' . nl2br(htmlspecialchars($post['content'])) . '

'; } ?>