Hello to all, welcome to therichpost.com. In this post, I will tell you, How to use Union query in laravel?  Laravel is one of the top php mvc framework. 

Today I will do Union query laravel.  Union query is use to get same number of fields from multiple tables and I personally like it very much.

Here I am sharing example union query for laravel framework.

//Controller Example:

public function GetEventCount(Request $request){
$users = \DB::table('users')
->select('username')
->where('id'’,'=',$_POST['id']);

$list = \DB::table('shifts')
->select(DB::raw('start_date','count(id) as count'))
->where('day','=',$_POST['day'])
->where('staff_id','=',$_POST['id']);

$results = $users->union($list)->get();
return response()->json($results);
}

 There are so many code tricks in laravel and i will let you know all. Please do comment if you any query related to this post. Thank you. Therichpost.com