Today, We want to share with you How to Join Two Tables in Laravel 6?.In this post we will show you wordpress plugin require another plugin, hear for Laravel 6 Joins Example Tutorial we will give you demo and example for implement.In this post, we will learn about Laravel 6 – inner join with multiple conditions example using Query Builder with an example.
How to Join Two Tables in Laravel 6?
There are the Following The simple About How to Join Multiple Tables with Eloquent Relationships Full Information With Example and source code.
As I will cover this Post with live Working example to develop laravel join with multiple conditions, so the how to join two table and display data in laravel 6 is used for this example is following below.
How to Join Multiple Table in Laravel 6?
Example 1: Laravel 6 Joins Example Tutorial
DB::table('visitors')
->select('visitors.id','visitors.name','profiles.photo')
->join('profiles','profiles.id','=','visitors.id')
->where(['status' => 'active', 'age' => 25])
->get();
Example 2: Laravel 6 – inner join with multiple conditions example using Query Builder
$visitor = Visitor::select("visitors.*","webistes.id as itemId","clicks.id as clickId")
->join("webistes","webistes.visitor_id","=","visitors.id")
->join("clicks",function($join){
$join->on("clicks.visitor_id","=","visitors.id")
->on("clicks.item_id","=","webistes.id");
})
->get();
print_r($visitor);
Example 3: Laravel join with 3 Tables
$webistes = DB::table('webistes')
->join('visitors', 'visitors.id', '=', 'webistes.visitor_id')
->join('blogs', 'blogs.visitor_id', '=', 'visitors.id')
->where('blogs.blogs_id', '=', 3)
->get();
Example 4:
$visitor_details = Visitor::join('Click','Click.Created_at','=','Visitor.Created_at')
->select(
'Click_count.Created_at'
DB::raw('SUM(Click_count) as Click_count'),
DB::raw('SUM(Visitor_count) as Visitor_count')
)
->groupBy('Click.Created_at')
->orderBy("created_at")
->get();
return view('analytics')->with('visitor_details');
Example 5:
//Left Join Clause
Visitor::leftJoin('webistes', 'webistes.visitor_id', '=', 'visitors.id')
->select('visitors.*')
->get();
//Right Join Clause
Visitor::rightJoin('webistes', 'webistes.visitor_id', '=', 'visitors.id')
->select('visitors.*')
->get();
//Cross Join Clause
Size::crossJoin('webistes')->get();
//Advanced Join Clauses
DB::table('visitors')
->join('webistes', function ($join) {
$join->on('visitors.id', '=', 'webistes.visitor_id')
->where('webistes.visitor_id', '>', 5);
})
->get();
//Sub-Query Joins
DB::table('webistes')
->select('visitor_id', DB::raw('MAX(created_at) as last_webiste_created_at'))
->where('is_published', true)->groupBy('visitor_id');
Web Programming Tutorials Example with Demo
Read :
Summary
You can also read about AngularJS, ASP.NET, VueJs, PHP.
I hope you get an idea about Laravel 6 Join Two Tables.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.