How to join three tables in laravel eloquent

Question

I want to join three tables: sections table: sectionid text formid

questions table: questionid question formid sectionid

options table: optionid option questionid

I want to fetch all sections where formid=x (for example) and questions related to sectionid and options related to questionid.

               $data=Section::with('questions','options')
                            ->where('formId',$formId)
                            ->orderBy('sectionid')
                            ->get()
                            ->toJson();

HamHp · Accepted Answer · 2021-05-01 00:57:49Z

1

I've created two relationships in my Section model. One to joining Section model to Question model and other one to join Section Model to Option model through Question model.

class Section extends Model
{
  use HasFactory;
  protected $primaryKey='sectionid';
  public function options(){
      return $this->hasManyThrough(Option::class,Question::class,'sectionid','questionid');

}
public function questions(){
    return $this->hasMany(Question::class,'sectionid');
}

}

My Controller:

            $data=Section::with('questions','options')
                            ->where('formId',$formId)
                            ->orderBy('sectionid')
                            ->get()
                            ->toJson();

It works properly :)

edited May 1, 2021 at 0:57

answered May 1, 2021 at 0:51

HamHp

338 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Farhan Ibn Wahid · Accepted Answer · 2021-04-30 23:50:32Z

0

Laravel docs: https://laravel.com/docs/8.x/queries#joins

According to what you need:

$data = Section::where('formid', x)
            ->join('questions', 'sections.sectionid', '=', 'questions.sectionid')
            ->join('options', 'options.optionid', '=', 'questions.optionid')
            ->select('sections.*', 'questions.question as question', 'options.option as option')
            ->get();

Notes:

Do not fetch * from all tables, for most cases you may get ambiguous column error
Your coding style does not follow convention which is really bad practice. Following convention helps in many ways.

answered Apr 30, 2021 at 23:50

Farhan Ibn Wahid

1,0421 gold badge12 silver badges26 bronze badges

2 Comments

HamHp Over a year ago

Thank you. I found the solution and answered to my question.@Psycho

Farhan Ibn Wahid Over a year ago

your question was about join and your answer is nowhere close to that. Anyway, suggesting you to follow laravel docs

Collectives™ on Stack Overflow

How to join three tables in laravel eloquent

2 Answers 2

Comments

According to what you need:

Notes:

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

According to what you need:

Notes:

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related