CODEWITHSUNDEEP
phpmysqllaravel
Usama Iftikhar
Usama Iftikhar

Reputation: 183

Converting Sql leftjoin query to Laravel format

My query is giving right result in MySQL, Now I need to convert in laravel query. My current query is:

SELECT menu_choices.*
FROM menu_choices
LEFT JOIN menus
ON menus.id=menu_choices.menu_id WHERE menus.restaurant_id=1
ORDER BY menus.menu_name;

And in laravel I am doing it like this:

MenuChoice::select('name')->leftJoin('menus','menus.id','=','menu_choices.menu_id')
        ->where('menus.restaurant_id',1)
        ->orderBy('menus.menu_name')
        ->get();

Upvotes: 1

Views: 148

Answers (1)

Sagar Arora
Sagar Arora

Reputation: 1783

Your query in laravel will be like this:

MenuChoice::leftJoin('menus','menus.id','=','menu_choices.menu_id')
        ->select('menu_choices.*')
        ->where('menus.restaurant_id',1)
        ->orderBy('menus.menu_name')
        ->get();

Also you can more learn about laravel queries using joins from here:

https://laravel.com/docs/5.4/queries#joins

Thanks

Upvotes: 1

Related Questions