/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 vote312 views2 answers
Codeigniter 4 get method deprecated
PHP
0 vote314 views1 answer
CURL error 60: SSL certificate problem: self signed certificate in certificate chain
PHP
2 votes263 views2 answers
Php redirect in seconds
PHP
7 votes305 views3 answers
Laravel table in model
PHP Laravel
0 vote279 views3 answers
Slick slider and ACF Pro in WordPress
PHP
0 vote282 views1 answer
Many isset posts
PHP
1 vote275 views1 answer
Laravel carbon time format AM PM
PHP
6 votes301 views4 answers
Php catch exception
PHP
1 vote266 views1 answer
Php sql connection string
PHP
0 vote282 views1 answer
Last_insert_id() php
PHP