/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

9 votes288 views3 answers
Settimezone in php
PHP
3 votes242 views1 answer
Php define strict types
PHP
7 votes279 views5 answers
Laravel foreach loop index in controller
PHP Laravel
0 vote303 views1 answer
Laravel model isdirty
PHP Laravel
2 votes262 views3 answers
Ajax post json data handle in php
PHP
0 vote280 views1 answer
Big int php
PHP
4 votes253 views2 answers
Laravel collection random
PHP
2 votes318 views2 answers
Laravel run controller from command line
PHP Laravel
1 vote281 views3 answers
Laravel invoice toturial
PHP
0 vote260 views1 answer
How to clear previously echoed items in PHP
PHP