posts.php

<?php
$conn = mysqli_connect('localhost', 'root', '', 'maksitwitter');

$query = "SELECT posts.id, posts.content, posts.author, posts.date_created, posts.likes,
                 users.username, users.pfp_path
          FROM posts
          JOIN users ON posts.author = users.id
          ORDER BY $sort DESC";

$result = mysqli_query($conn, $query);

if (!$result) {
    exit;
}

while ($row = mysqli_fetch_assoc($result)) {

    $author_name = $row['username'] ?? 'Unknown';
    $pfp = $row['pfp_path'] ?? 'default_pfp.png';
    $date = date('M j, Y · H:i', strtotime($row['date_created']));
?>
<div class="post">

    <p><?php echo nl2br(htmlspecialchars($row['content'])) ?></p><br>

    <p>Posted by</p>

    <img src="<?php echo htmlspecialchars($pfp); ?>" width="40" height="40">

    <p><?php echo htmlspecialchars($author_name) ?> on <?php echo $date ?></p>

    <p>Likes: <span class="likes-count"><?php echo $row['likes']; ?></span></p>

    <button
    class="like-btn"
    data-postid="<?php echo $row['id']; ?>">

    <?php
    $postid = $row['id'];
    $userid = $_SESSION['id'];

    $liked = mysqli_query($conn, "SELECT * FROM post_likes WHERE post_id='$postid' AND user_id='$userid'");

    if (!$liked || mysqli_num_rows($liked) == 0) {
        echo "Like";
    } else {
        echo "Liked";
    }
    ?>
    </button>
</div>
<?php
}
mysqli_close($conn);
?>