/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 vote191 views1 answer
Send sms by php diafaan
PHP
0 vote246 views1 answer
Symfony 2.8 create database from entities
PHP
2 votes256 views3 answers
Call stored procedure in laravel
PHP Laravel
0 vote203 views1 answer
Hook de pré-commit se déclenche
PHP
0 vote205 views1 answer
Create fake users on click laravel
PHP
4 votes172 views1 answer
How to check query execution time in laravel
PHP
1 vote330 views1 answer
Cakephp 4 change layout view in a method
PHP CakePHP
0 vote168 views1 answer
Array push to json file php
PHP
0 vote240 views1 answer
Php array to array collection
PHP
9 votes231 views4 answers
Laravel group route controller
PHP Laravel