/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 vote81 views1 answer
Laravel mix build as umd
PHP Laravel
0 vote156 views1 answer
Adding another return message from Laravel Livewire
PHP Laravel
0 vote128 views1 answer
Laravel Google Line Chart
PHP Laravel
5 votes131 views3 answers
Crrate model in laravel
PHP Laravel
0 vote126 views2 answers
Laravel composite unique key
PHP Laravel
0 vote166 views1 answer
Laravel Excel numbers formatted as text still appearing as number
PHP Laravel
11 votes141 views4 answers
Laravel validator make custom message
PHP Laravel
28 votes182 views12 answers
Laravel middleware
PHP Laravel
0 vote130 views1 answer
Explode in laravel blade
PHP Laravel
6 votes132 views4 answers
Insert data using seeder in laravel
PHP Laravel