/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 vote196 views1 answer
How make exception laravel if operation does not work
PHP Laravel
23 votes229 views6 answers
Laravel 8 route
PHP Laravel
0 vote208 views1 answer
Laravel disable config cache
PHP Laravel
18 votes259 views4 answers
Laravel create model controller and migration on line
PHP Laravel
0 vote210 views1 answer
Laravel 8 logout 419 page expired
PHP Laravel
2 votes168 views1 answer
Laravel create txt file
PHP Laravel
1 vote216 views1 answer
Check if url is https laravel
PHP Laravel
2 votes211 views2 answers
Get users other than specific role laravel role spatie
PHP Laravel
0 vote210 views1 answer
How to make custom validator in laravel
PHP Laravel
0 vote225 views1 answer
Set config key dynamic laravel
PHP Laravel