/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 vote149 views1 answer
Change verify email template laravel
PHP Laravel
4 votes148 views3 answers
Laravel 7 eloquent on delete set null schema
PHP Laravel
8 votes156 views3 answers
Laravel date between
PHP Laravel
0 vote145 views1 answer
RequestCriteria laravel
PHP Laravel
0 vote144 views2 answers
How to use php in laravel blade
PHP Laravel
10 votes180 views4 answers
Laravel migration change column default
PHP Laravel
40 votes141 views6 answers
Laravel create migration
PHP Laravel
1 vote140 views1 answer
How to use bootstrap in laravel 8 remove tailwind
PHP Laravel
6 votes153 views4 answers
Laravel create project command
PHP Laravel
28 votes153 views6 answers
Laravel make model with migration
PHP Laravel