/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

1 vote194 views2 answers
Get ip address in laravel
PHP Laravel
0 vote181 views1 answer
Clear from faild_jobs laravel
PHP Laravel
0 vote187 views1 answer
What is Trustproxies handle in laravel
PHP Laravel
0 vote277 views1 answer
Comparison of two tables in laravel using model
PHP Laravel
34 votes208 views6 answers
Laravel create controller with methods
PHP Laravel
0 vote191 views1 answer
Datetime-local laravel migration data type
PHP Laravel
1 vote190 views1 answer
Protected gaurded in laravel
PHP Laravel
2 votes170 views1 answer
Laravel force login by id
PHP Laravel
1 vote180 views1 answer
Laravel bindings query
PHP Laravel
8 votes220 views5 answers
Laravel belongs to
PHP Laravel