/PHP/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

18 votes181 views4 answers
Laravel create model controller and migration on line
PHP Laravel
1 vote178 views2 answers
Running laravel as host
PHP Laravel
7 votes148 views3 answers
Php try catch
PHP
0 vote171 views1 answer
Get product price by id woocommerce snippet
PHP
2 votes155 views1 answer
Cookie are not set in php
PHP
0 vote148 views1 answer
How to loop array in laravel
PHP
0 vote203 views1 answer
Check for headers laravel
PHP
0 vote218 views1 answer
Illuminate\contracts\container\bindingresolutionexception: target class laravel 8
PHP
-1 vote180 views3 answers
@parent, @include, @show blade in laravel
PHP
0 vote172 views1 answer
How to send html table in email body in php
PHP