/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 vote222 views3 answers
When you click on the search button, it is moved to the page laravel
PHP Laravel
18 votes293 views5 answers
Create model, controller and migration in single command laravel
PHP Laravel
6 votes237 views5 answers
Migration rename column laravel
PHP Laravel
17 votes282 views3 answers
Laravel order by desc
PHP Laravel
-1 vote233 views1 answer
Laravel set production
PHP Laravel
0 vote263 views1 answer
Laravel npm run deve error mix
PHP Laravel
7 votes230 views4 answers
Laravel error messages
PHP Laravel
-1 vote259 views1 answer
Chrome web driver laravel
PHP Laravel
2 votes247 views4 answers
Laravel where in array
PHP Laravel
40 votes238 views6 answers
Laravel create migration
PHP Laravel