/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

0 vote131 views1 answer
Migration not found laravel
PHP Laravel
1 vote95 views2 answers
Laravel loop counter
PHP Laravel
2 votes135 views1 answer
Laravel force login by id
PHP Laravel
2 votes147 views1 answer
Multiple routes same controller laravel
PHP Laravel
12 votes136 views6 answers
Set session data in laravel
PHP Laravel
10 votes146 views2 answers
Same password check in laravel
PHP Laravel
0 vote139 views1 answer
Textarea laravel migration
PHP Laravel
0 vote149 views7 answers
Debugger in laravel
PHP Laravel
1 vote132 views3 answers
Laravel artisan command run in route
PHP Laravel
2 votes150 views1 answer
Laravel-ckeditor
PHP Laravel