Merge two arrays into single arrays in php laravel and displaying in blade

Question

I want to filter the datas according to colleges and universities and my query is

$exams = Exam::where('status', 1);
        if ($request->filled('universities')) {
            $exams = $exams->whereIn('university_id', $request->universities);  //data 1st
        }
        if ($request->filled('colleges')) {
            $exams = $exams->whereIn('college_id', $request->colleges); //data 2nd
        }
        $exams = $exams->get();

Answer 1

You would want to group the wheres for the college or university. You can try something like this:

$exams = Exam::where('status', 1);

if ($request->has('universities', 'colleges')) {
    $exams->where(function ($q) use ($request) {
        if ($request->input('universities')) {
            $q->orWhereIn('university_id', (array) $request->input('universities'));
        }

        if ($request->input('colleges')) {
            $q->orWhereIn('college_id', (array) $request->input('colleges'));
        }
    });
}