/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 vote327 views1 answer
Laravel array in lang
PHP
0 vote334 views1 answer
Migration not found laravel
PHP
0 vote309 views2 answers
Laravel db insert get last id
PHP
31 votes386 views6 answers
Update or create laravel
PHP
0 vote308 views2 answers
Sage theme get template
PHP
0 vote394 views1 answer
Laravel target is not instantiable while building
PHP Laravel
0 vote378 views1 answer
Get first cat php wp
PHP Wordpress
0 vote365 views1 answer
Lcomposer symfony/filesystem
PHP
48 votes342 views6 answers
Php find in array
PHP
6 votes461 views1 answer
Laravel add attribute migration column
PHP Laravel