/PHP/Laravel/Join multiple tables in laravel eloquent

Join multiple tables in laravel eloquent

Join 2 tables laravel

use Illuminate\Support\Facades\DB;

$users = DB::table('users')
            ->join('contacts', 'users.id', '=', 'contacts.user_id')
            ->join('orders', 'users.id', '=', 'orders.user_id')
            ->select('users.*', 'contacts.phone', 'orders.price')
            ->get();

Source: laravel.com

Join multiple tables in laravel eloquent

$users = User::join('posts', 'posts.user_id', '=', 'users.id')
            ->where('users.status', 'active')
            ->where('posts.status','active')
            ->get(['users.*', 'posts.descrption']);

Laravel + join 2 eloquent queries

 $select->joinSub(
                    $selectSubQry,
                    'ag',
                    'ag.id',
                    '=',
                    'agp.userId'
                );

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

Similar codes

0 vote143 views1 answer
Run new oroject laravel with idff port
PHP Laravel
11 votes125 views3 answers
How to make validate error when password doesnt match with password confirm laravel
PHP Laravel
0 vote128 views1 answer
Laravel eloquent select one column in array
PHP Laravel
2 votes143 views1 answer
Laravel model id string
PHP Laravel
0 vote121 views1 answer
Test a single file laravel
PHP Laravel
0 vote124 views1 answer
How to see with page reuested in laravel
PHP Laravel
4 votes128 views2 answers
Laravel kill current session
PHP Laravel
0 vote123 views1 answer
Laravel dingo api response
PHP Laravel
5 votes137 views2 answers
Laravel 8 routes namespace
PHP Laravel
1 vote128 views2 answers
Get unique values in laravel
PHP Laravel