/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 vote169 views1 answer
'cross-env' is not recognized as an internal or external command, laravel
PHP Laravel
0 vote227 views1 answer
ErrorException Undefined index(laravel 7 array helpers)
PHP Laravel
6 votes132 views2 answers
WhereHas site:https://laravel.com/docs/
PHP Laravel
0 vote173 views1 answer
Laravel request object empty
PHP Laravel
0 vote165 views1 answer
Laravel 8 created at format
PHP Laravel
0 vote133 views1 answer
Laravel add model to polymorphic relationships
PHP Laravel
0 vote225 views1 answer
Laravel request protected prop
PHP Laravel
50 votes273 views6 answers
Laravel migration add column to existing table
PHP Laravel
4 votes136 views1 answer
Refresh a specific migration in laravel
PHP Laravel
0 vote178 views1 answer
Laravel joins eloquent model
PHP Laravel