/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 vote406 views2 answers
Save big data with laravel
PHP Laravel
0 vote334 views2 answers
Laravel model column default value
PHP Laravel
2 votes345 views6 answers
Laravel sanctum authentication
PHP Laravel
0 vote324 views3 answers
Laravel - How to create custom configuration variables and access
PHP Laravel
9 votes354 views2 answers
Laravel query count raw
PHP Laravel
0 vote343 views1 answer
Update function laravel 7
PHP Laravel
1 vote341 views1 answer
Laravel get first letter of each word
PHP Laravel
0 vote360 views1 answer
Validate rule if row exist laravel
PHP Laravel
0 vote353 views1 answer
Create model for existing table in laravel
PHP Laravel
4 votes373 views2 answers
Display all errors at once in laravel
PHP Laravel