/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

6 votes104 views5 answers
Check php version linux terminal
PHP
0 vote104 views1 answer
Generate press viewport
PHP
0 vote120 views1 answer
Laravel session wont update
PHP
0 vote127 views2 answers
Mysqli::real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
PHP
8 votes100 views1 answer
Laravel link storage to public
PHP Laravel
76 votes117 views6 answers
Show php errors
PHP
0 vote102 views1 answer
Get first name user
PHP
12 votes109 views4 answers
Laravel auth setup
PHP
0 vote113 views1 answer
How to read data from curl php
PHP
14 votes101 views3 answers
Laravel setup auth
PHP