/PHP/Laravel/Laravel join 2 tables eloquent

Laravel join 2 tables 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 tables eloquent

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

Similar codes

0 vote363 views1 answer
Laravel raw query join many to many
PHP Laravel
11 votes359 views2 answers
Select distinct laravel
PHP Laravel
12 votes378 views4 answers
Laravel get second last record
PHP Laravel
12 votes327 views6 answers
Return redirect with message laravel
PHP Laravel
0 vote396 views1 answer
Laravel command Retrieve a specific option
PHP Laravel
1 vote370 views1 answer
?? ' ' operator in php laravel
PHP Laravel
0 vote360 views1 answer
How to get private images in s3 laravel
PHP Laravel
4 votes415 views1 answer
413 error laravel
PHP Laravel
1 vote326 views1 answer
String to uppercase laravel
PHP Laravel
46 votes435 views3 answers
How to check laravel version in cmd
PHP Laravel