/PHP/Laravel 8 query builder, Inner Join Clause

Laravel 8 query builder, Inner Join Clause

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

Laravel 8 query builder, Left Join / Right Join Clause

//Left join
$users = DB::table('users')
            ->leftJoin('posts', 'users.id', '=', 'posts.user_id')
            ->get();
//Right join
$users = DB::table('users')
            ->rightJoin('posts', 'users.id', '=', 'posts.user_id')
            ->get();

Source: laravel.com

Similar codes

0 vote333 views1 answer
Retrieve the order Id on Order pay page
PHP
0 vote347 views1 answer
CausesActivity trait
PHP
1 vote320 views1 answer
How to request user input in php
PHP
0 vote367 views1 answer
Html table to array php
PHP
14 votes351 views3 answers
Change returning datetime timezone to recalculate with user timezone laravel
PHP
55 votes419 views6 answers
Php if in array
PHP
8 votes340 views3 answers
Php even odd
PHP
0 vote303 views1 answer
Laravel migrate patth
PHP Laravel
4 votes336 views6 answers
Laravel 8 authentication
PHP Laravel
0 vote316 views1 answer
Php wxplode
PHP