/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 vote203 views1 answer
Laravel sintax
PHP Laravel
0 vote201 views2 answers
What is composer in laravel
PHP Laravel
1 vote207 views2 answers
Redrectnh to https n laravel
PHP Laravel
0 vote215 views1 answer
Array of dates laravel
PHP Laravel
2 votes211 views3 answers
Laravel url with parameters blade
PHP Laravel
2 votes233 views1 answer
Multiple routes same controller laravel
PHP Laravel
12 votes195 views4 answers
Bcrypt laravel
PHP Laravel
18 votes198 views6 answers
Laravel routes
PHP Laravel
16 votes234 views2 answers
Laravel/ui v3.0.0 requires php ^7.3 -> your php version (8.0.2) does not satisfy that requirement.
PHP Laravel
1 vote281 views2 answers
Laravel check if email is real
PHP Laravel