How to create query whereIn OR whereIn in Laravel 5

You can build your query step-by-step and then call get() method. But sometimes it gets a little tricky for more complicated queries – for example, if you have multiple whereIn OR whereIn conditions and you want to put brackets, do it like this.

$getrecord = DiamondMaster::where('is_delete','0')->where('user_id',Auth::user()->id);
if(!empty($request->stone_id))
{
	$postdata = $request->stone_id;
	$certi_id =trim($postdata,",");
	$getrecord = $getrecord->whereIn('id',explode(",", $certi_id))
						   ->orWhereIn('Certi_NO',explode(",", $certi_id));		
}
$getrecord = $getrecord->get();

Leave a Reply

Your email address will not be published. Required fields are marked *