/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 vote209 views1 answer
How can we check in the table in comma separated values in laravel
PHP
0 vote170 views1 answer
Unable to do sum and getting same value by using while loop php
PHP
0 vote166 views1 answer
Smarty shorthand if
PHP
1 vote184 views1 answer
Laravel model increase the value by one
PHP Laravel
0 vote113 views2 answers
Php get previous url
PHP
0 vote231 views1 answer
Twig render to variable
PHP
3 votes156 views3 answers
Insert timestamps manually in laravel
PHP
0 vote208 views1 answer
Is replace case sensitive php
PHP
0 vote174 views2 answers
Laravel apiresource
PHP
0 vote204 views2 answers
Laravel-check-if-related-model-exists
PHP Laravel