Laravel 5.2 whereRaw具有多个条件

Question

below is my query . i want to get all results If (nic or mobile) and course matches ,

please advice

        $conversations = Inquiries::whereRaw("( `course` = $request->input('course'))
            AND( `mobile` = $request->input('mobile') OR 'nic', 'LIKE', '%'.$request->input('nic').'%')")
            ->get();

Answer 1

You need to properly create a query, like this:

$conversations = Inquiries::where('course', '=', $request->input('course'))
    ->where(function($query) use ($request) {
        $query->where('mobile','=', $request->input('mobile'))
            ->orWhere('nic','LIKE','%'.$request->input('nic').'%');
    })
    ->get();