Relationships Between Tables in CodeIgniter

Relationships Between Tables in CodeIgniter — a practical guide to CodeIgniter relationships with clear examples you can reuse in real projects.

CodeIgniter Tutorial Series (38/74). Prefer one article? Read the complete CodeIgniter tutorial.

Short description

CI models do not force Eloquent-style relations, but you can implement belongs-to/has-many patterns with queries and joins.

Join example

return $this->select('posts.*, users.name AS author')
    ->join('users', 'users.id = posts.user_id')
    ->findAll();