/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

-1 vote107 views2 answers
Php mysql if not exists insert
PHP
2 votes96 views1 answer
Wp get term link
PHP
4 votes125 views5 answers
Laravel db inserr
PHP Laravel
7 votes111 views3 answers
Try catch php
PHP
0 vote128 views1 answer
Php accounting ledger
PHP
0 vote124 views1 answer
Unique string faker laravel
PHP
14 votes143 views6 answers
Update query in laravel eloquent
PHP Laravel
0 vote119 views1 answer
Twig render to variable
PHP
0 vote112 views1 answer
Curl multi exec get index
PHP
7 votes104 views1 answer
Php configuration
PHP