Laravel Query Builder left join

Question

can someone please tell me, why i am not able to select section from sections table using left join. i want list of teachers in a table, i am able to access all data from teachers table, but i am not able to see sections using left join. Teacher Table have section_id column, which should access data from sections table on section column.

right now it is giving error when i try to fetch data in view using {{$teacher->section}} Below is my code.

public function listteachers(Request $request)
{
  $teachers = DB::table('teachers')
  ->select('teachers.*')
  ->leftjoin('sections', 'teachers.section_id', '=', 'sections.id')
  ->orderBy('pass_exp', 'ASC')
  ->get();
return view('teachers.list',compact('teachers'));
}

i guess you are not selecting sections. Just try removing ->select('teachers.*') this line — vijaykumar
– vijaykumar, Commented May 20, 2019 at 9:05
@vijaykumar Missing required parameters for [Route: teachers.edit] — Fayakon
– Fayakon, Commented May 20, 2019 at 9:09
Now, it is an other issue. edit routes need an ID as a parameter. The error comes from your view I guess. — Kévin Bibollet
– Kévin Bibollet, Commented May 20, 2019 at 9:11

Jack · Accepted Answer · 2019-05-20 09:09:07Z

3

You need to select the columns you want from the sections table in your query.

For example:

$teachers = DB::table('teachers')
    ->select('teachers.*', DB::raw('sections.name as section_name'))
    ->leftJoin('sections', 'teachers.section_id', '=', 'sections.id')
    ->orderBy('pass_exp', 'ASC')
    ->get();

answered May 20, 2019 at 9:09

Jack

8876 silver badges11 bronze badges

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

Comments

Jithesh Jose · Accepted Answer · 2019-05-20 09:16:59Z

1

Change the code to the following

  $teachers = DB::table('teachers')
        ->select('teachers.*','sections.name as section_name')
        ->leftJoin('sections', 'teachers.section_id', '=', 'sections.id')
        ->orderBy('pass_exp', 'ASC')
       ->get();

answered May 20, 2019 at 9:16

Jithesh Jose

1,8241 gold badge8 silver badges17 bronze badges

Collectives™ on Stack Overflow

Laravel Query Builder left join

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related