/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

8 votes242 views4 answers
Laravel hash password sample
PHP
1 vote221 views1 answer
Group array php by key
PHP
1 vote239 views2 answers
Laravel sail alias
PHP
3 votes249 views3 answers
Class 'App\Http\Controllers\Auth' not found
PHP
0 vote227 views1 answer
Base url in php
PHP
6 votes243 views5 answers
Check if a String Starts With a Specified String in PHP
PHP
20 votes245 views1 answer
Png to pdf
PHP
1 vote229 views1 answer
Difference between fetch assoc and fetch array or object php
PHP
0 vote257 views1 answer
How to on debugger in wordpress
PHP Wordpress
0 vote231 views1 answer
Fgets in php
PHP