How to join three table by laravel eloquent model

Question

I have three table  Articles table   id  title  body  categories id  user id   Categories table    id   category name   User table   id  user name  user type   I want to show articles with their category name instead of category id and user name instead of user id I try like these query It is work    articles  DB  table  articles                   - gt join  categories    articles id         categories id                   - gt join  users    users id         articles user id                   - gt select  articles id   articles title   articles body   users username    category name                   - gt get      But I want to do by Eloquent way  Please  how could I do

User · Answer

Try     articles   DB  table  articles               - gt select  articles id as articles id                       - gt join  categories    articles categories id         categories id               - gt join  users    articles user id         user id                - gt get

User · Answer

With Eloquent its very easy to retrieve relational data  Checkout the following example with your scenario in Laravel 5   We have three models   1  Article  belongs to user and category   2  Category  has many articles   3  User  has many articles     1  Article php    lt  php  namespace App Models   use Eloquent   class Article extends Eloquent       protected  table    articles        public function user                 return  this- gt belongsTo  App Models User               public function category                 return  this- gt belongsTo  App Models Category                 2  Category php    lt  php  namespace App Models   use Eloquent   class Category extends Eloquent       protected  table    categories        public function articles                 return  this- gt hasMany  App Models Article                 3  User php   lt  php  namespace App Models  use Eloquent   class User extends Eloquent       protected  table    users        public function articles                 return  this- gt hasMany  App Models Article               You need to understand your database relation and setup in models  User has many articles  Category has many articles  Articles belong to user and category  Once you setup the relationships in Laravel  it becomes easy to retrieve the related information   For example  if you want to retrieve an article by using the user and category  you would need to write    article    App Models Article  with   user   category   - gt first      and you can use this like so     retrieve user name   article- gt user- gt user name      retrieve category name   article- gt category- gt category name   In another case  you might need to retrieve all the articles within a category  or retrieve all of a specific user s articles  You can write it like this    categories    App Models Category  with  articles  - gt get      users    App Models Category  with  users  - gt get      You can learn more at http   laravel com docs 5 0 eloquent

User · Answer

articles  DB  table  articles                   - gt join  categories   articles id         categories id                   - gt join  user    articles user id         user id                   - gt select  articles id   articles title   articles body   user user name    categories category name                   - gt get    return view  myarticlesview    articles   gt  articles

[php] How to join three table by laravel eloquent model

Examples related to php

Examples related to mysql

Examples related to laravel