/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

1 vote195 views2 answers
Modularizing laravel 8.0
PHP Laravel
0 vote206 views1 answer
Https://ols.liu.edu.lb/mod/quiz/rview.php
PHP
0 vote143 views1 answer
Codeigniter set db prefix
PHP
0 vote269 views1 answer
Curl_setopt_array php
PHP
16 votes164 views1 answer
League/omnipay v3.0.0 requires php ^7.1 -> your php version (8.0.11) does not satisfy that requirement
PHP
7 votes195 views2 answers
Transaction commit rollback in laravel
PHP Laravel
6 votes196 views2 answers
Laravel check if request has value
PHP Laravel
47 votes181 views6 answers
Php array lenght
PHP
10 votes153 views2 answers
Convert php array into json online
PHP
1 vote154 views1 answer
Spatie media library retrieve media from url
PHP