/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 vote321 views4 answers
Error": "Trying to get property 'id' of non-object" in laravel
PHP Laravel
2 votes325 views1 answer
Attach multiple files in laravel mailable
PHP Laravel
0 vote322 views1 answer
A facade root has not been set laravel 7
PHP Laravel
0 vote358 views1 answer
Laravel eloquent hasmany select
PHP Laravel
1 vote318 views1 answer
Laravel increment column value in update query
PHP Laravel
0 vote313 views2 answers
How to fix Column not found: 1054 Unknown column 'api_token' in 'where clause' (SQL: select * from `users` where `api_token laravel
PHP Laravel
-1 vote367 views2 answers
Laravel sortby relationship column
PHP Laravel
1 vote248 views2 answers
Laravel loop counter
PHP Laravel
0 vote311 views1 answer
Retrievemultipleimage from database in laravel
PHP Laravel
0 vote321 views2 answers
Default language laravel
PHP Laravel