php - CodeIgniter - joining users, posts, comments tables

one text

Solution:

The problem is when you join posts with comments it return many records of comments with the same post. You can modify a little bit first in your controller to store each post with comments belong to it:

function index()
{
    $this->load->model('user_model');
    $comments = $this->user_model->join_user_post();
    $posts = array();
    foreach ($comments as $comment) {
        if (array_key_exists($comment->post_id, $posts)) {
            $posts[$comment->post_id]['comments'][] = $comment;
        } else {
            $posts[$comment->post_id]['post_body'] = $comment->post_body;
            $posts[$comment->post_id]['username'] = $comment->username;
            $posts[$comment->post_id]['date_created'] = $comment->date_created;
            $posts[$comment->post_id]['user_image'] = $comment->user_image;
            $posts[$comment->post_id]['comments'][] = $comment;
        }
    }
    $data['posts'] = $posts;
    $this->load->view("user/homepage", $data);
}

And in your view:

<div>
    <img src="<?php echo $post['user_image'] ?><br>">
    <?php echo $post['username'] ?><br>
    <?php echo $post['post_body'] ?><br>
    <?php echo $post['date_created'] ?><br>

    <?php foreach ($posts['comments'] as $comment) : ?>
        <?php echo $comment->comment_body ?><br>
        <?php echo $comment->date_created ?><br>
    <?php endforeach; ?>

</div>