/PHP/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 vote278 views2 answers
Add laravel sail build as alias
PHP
0 vote322 views1 answer
Symfony get api data
PHP Symfony
8 votes311 views3 answers
Validate time in laravel
PHP Laravel
1 vote297 views2 answers
Laravel view data
PHP Laravel
0 vote300 views1 answer
Laravel collection transform
PHP Laravel
0 vote247 views1 answer
Ci4 throw new exception
PHP
18 votes271 views2 answers
- root composer.json requires php ^7.1.3 but your php version (8.0.3) does not satisfy that requirement.
PHP
2 votes277 views2 answers
Php redirect seconds
PHP
2 votes270 views1 answer
How to run multiple laravel projects at same time
PHP Laravel
4 votes253 views2 answers
Laravel migration table column nullable
PHP