/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

24 votes142 views6 answers
Validation error message in laravel
PHP Laravel
0 vote156 views1 answer
Laravel model query limit
PHP Laravel
2 votes156 views2 answers
Update laravel 7 to 8
PHP Laravel
1 vote153 views1 answer
Persian error laravel
PHP Laravel
4 votes158 views2 answers
Laravel eloquent get data without duplicates
PHP Laravel
12 votes148 views4 answers
Bcrypt laravel
PHP Laravel
8 votes167 views4 answers
Laravel hash password sample
PHP Laravel
0 vote152 views1 answer
Laravel raw query join many to many
PHP Laravel
1 vote184 views1 answer
Edit data using model in laravel 8
PHP Laravel
8 votes146 views6 answers
Laravel command not found
PHP Laravel