/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 vote342 views1 answer
Laravel filesystem link
PHP
0 vote282 views1 answer
Laravel maintenance mode custom class
PHP
0 vote323 views1 answer
Getname eloquent slug laravel
PHP Laravel
3 votes345 views2 answers
How to truncate the given string to the specified length in blade.php
PHP
48 votes327 views6 answers
Laravel joins
PHP
0 vote279 views1 answer
Back()->with('message','Successfully Updated the Password'); larvel
PHP
2 votes285 views1 answer
Laravel project editor
PHP
0 vote263 views1 answer
Composer create-project --prefer-dist laravel/laravel blog
PHP
3 votes320 views6 answers
Laravel cors
PHP Laravel
2 votes350 views1 answer
Laravel schema default string length
PHP Laravel