Laravel’s database query builder provides interface to create and running database queries to perform database operations in your application.
I also allow us to write join statements. Following is the example of simple inner join which can be achieve by using ‘join’.
$rows = DB::table('table1')
->join('table2', 'table1.id', '=', 'table2.t1_id')
->select('table1.*', 'table2.field')->get();
For additional conditions in joins, we can write statements like below.
$rows = DB::table('table1')
->join('table2',function ($join) {
$join->on('table1.id', '=', 'table2.t1_id')
})->select('table1.*', 'table2.field')->get();
We can add multiple statements in join function. That’s it, hope this will be helpful.
I hope you already have WSL2 installed and enabled. So, setting up Apache2 on WSL2…
Install NVM on Windows Node Js is a JavaScript runtime environment used widely in today’s…
You can easily reset WSL 2 users' password, by just following the following steps. Open…
DreamHost a web hosting company, founded in 1997. It is offering sort of hosting services,…
Menus in WordPress are highly versatile and can be easily modified to change in your…
Laravel is famous and robust PHP framework, widely used in different type of projects. While…