/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 vote348 views1 answer
Convert time to 24 hour format laravel
PHP Laravel
11 votes361 views3 answers
How to remove composer package in laravel
PHP Laravel
12 votes279 views4 answers
Laravel auth setup
PHP Laravel
1 vote338 views1 answer
Laravel word count utf8
PHP Laravel
31 votes290 views6 answers
Update or create laravel
PHP Laravel
43 votes323 views6 answers
Laravel create migration add column
PHP Laravel
0 vote359 views1 answer
Dynamic modal name appending in laravel
PHP Laravel
2 votes346 views2 answers
Laravel relationship with for single data
PHP Laravel
0 vote314 views1 answer
Laravel Deploy in production
PHP Laravel
0 vote290 views1 answer
Laravel model where set fields laravel
PHP Laravel