/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

18 votes241 views6 answers
Laravel form validation
PHP Laravel
1 vote305 views1 answer
Laravel change post request before save
PHP Laravel
0 vote227 views2 answers
Laravel log could not be opened fix
PHP Laravel
0 vote221 views1 answer
Laravel change string to text
PHP Laravel
17 votes235 views10 answers
Laravel where and where
PHP Laravel
39 votes282 views3 answers
Add new column to existing table laravel
PHP Laravel
5 votes246 views2 answers
Laravel APP_ENV config
PHP Laravel
1 vote210 views1 answer
Array_last in laravel 8
PHP Laravel
0 vote220 views1 answer
Check the existing image in s3 laravel
PHP Laravel
0 vote218 views1 answer
Laravel: Validation unique on update
PHP Laravel