/PHP/Laravel/Laravel eloquent multiple join with where conditions

Laravel eloquent multiple join with where conditions

$users = User::join('posts', 'posts.user_id', '=', 'users.id')
            ->where('users.status', 'active')
            ->where('posts.status','active')
            ->get(['users.*', 'posts.descrption']);

Source: tutsmake.com

Laravel eloquent multiple join

$users = User::join('posts', 'posts.user_id', '=', 'users.id')
              ->join('comments', 'comments.post_id', '=', 'posts.id')
              ->get(['users.*', 'posts.descrption']);

Source: tutsmake.com

Similar codes

0 vote314 views1 answer
Optimistic Locking Laravel
PHP Laravel
1 vote274 views1 answer
Laravel data types
PHP Laravel
0 vote332 views1 answer
Laravel Http client retry request if fail
PHP Laravel
3 votes306 views2 answers
Laravel collection find duplicates
PHP Laravel
4 votes276 views2 answers
Laravel DB wherein
PHP Laravel
9 votes291 views5 answers
Return view with variable laravel
PHP Laravel
0 vote326 views1 answer
Laravel deploy without moving public directory
PHP Laravel
1 vote292 views4 answers
Laravel module package
PHP Laravel
9 votes313 views3 answers
Laravel image validation
PHP Laravel
0 vote313 views1 answer
How to create table for every user in laravel
PHP Laravel