/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

0 vote146 views1 answer
Link title to blog post wordpress in the loop
PHP
0 vote168 views1 answer
Get post data in laravel
PHP Laravel
0 vote148 views1 answer
Php triple quotes
PHP
0 vote136 views1 answer
How to sort with array and after print by for loop in php
PHP
3 votes158 views2 answers
How to add values to an array in laravel
PHP Laravel
0 vote147 views1 answer
Phpmailer add reply to
PHP
2 votes141 views2 answers
Switch between php version ubuntu nginx
PHP
0 vote183 views1 answer
Index.php wont load as main
PHP
1 vote164 views1 answer
Install symfony ubuntu
PHP
4 votes157 views2 answers
Php cors all
PHP