/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

7 votes156 views2 answers
Custom autoload without composer php psr4
PHP
0 vote194 views1 answer
Current time input field in laravel form
PHP
13 votes193 views6 answers
How to run laravel project
PHP
22 votes166 views3 answers
Carbon parse
PHP
15 votes198 views6 answers
Get last character of string php
PHP
0 vote175 views1 answer
Wpml language switcher shortcode
PHP
0 vote188 views1 answer
How to get all post fields in wordpress
PHP
0 vote167 views2 answers
Php infinite loop
PHP
0 vote171 views1 answer
PHP (WordPress) - Increase Maximum Upload File Size
PHP
5 votes157 views3 answers
Get last month php
PHP