Model/Database Relationship?

You may want to consider getting this information in a single query using a join - it'll be a lot faster than running four separate queries to get the information, especially at scale.

Yes of course. but that's why I was hoping CI4 had method chaining, like Laravel. Where it uses the query builder to automatically create the joins.

You modify the find() before you call it, not after.

Code:

public function getItem($id)
{
    $post = $this->join('post_files', 'post_files.post_id = posts.id AND post_files.primary = `Y`', 'inner')
                 ->join('post_images', 'post_images.post_id = posts.id  AND post_images.primary = `Y`', 'inner')
                 ->join('post_descriptions', 'post_descriptions.post_id = posts.id  AND post_descriptions.primary = `Y`', 'inner')
                 ->find($id);

    return $post;
}

or something like that.

Support Development •  CodeIgniter 4 Foundations • Practical CodeIgniter 3  • CodeIgniter Tutorials