/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 vote114 views1 answer
Laravel php 8 ububtu
PHP Laravel
0 vote130 views1 answer
How To Clear Laravel.Log In Laravel?
PHP Laravel
6 votes120 views1 answer
Route params link laravel
PHP Laravel
25 votes123 views4 answers
ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel
PHP Laravel
0 vote138 views1 answer
Laravel imap - Set message flags
PHP Laravel
0 vote112 views1 answer
Add controller to laravel with requests
PHP Laravel
24 votes126 views4 answers
Where not null in laravel
PHP Laravel
16 votes120 views4 answers
Wherenotnull laravel
PHP Laravel
6 votes122 views2 answers
Disable laravel debugbar
PHP Laravel
0 vote124 views1 answer
Laravel db ssh
PHP Laravel