prepare(" SELECT b.blog_id, b.title, b.description, b.status, b.date, b.image, CONCAT(u.first_name, ' ', u.last_name) AS author_name, u.email AS author_email, u.profile_pic FROM blogs b JOIN users u ON b.author = u.user_id WHERE b.status != 'deleted' ORDER BY b.date DESC "); $result->execute(); $posts = $result->get_result(); ?>

My Posts

×
+ New Post fetch_assoc()): // Output the HTML structure with dynamic data echo '
' . $post[
Author
' . strtoupper($post["status"]) . '
' . $post["title"] . '
' . $post["author_name"] . '

' . $post["description"] . '

'; endwhile; ?>