|
1 2 3 4 5 6 |
$productId = 5; $query = Products::SELECT('products.id','products.name','categories.name') ->leftJoin('categories', function($query) use($productId) { $query->on('products.category_id','=','categories.id') ->where('products.category_id', '=', $productId); })->get(); |
More from my site
Join or Left Join where no foreign key – using where condition in Laravel
Left join with last record of right table in Laravel & Mysql
if else and case when in Laravel query
Laravel folder permissions
Dynamic database connection in Laravel 5.5 | Multiple database connection in Laravel 5.5 | MySQL & Redis database connection in Laravel | Change database or schema dynamically in a connection
Laravel RESTful API Tutorial | Laravel RESTful API Example | Login, Register, Logout, and CRUD API in Laravel | Laravel RESTful API Development
