Laravel query with 'LIKE'

Just use where (it's and where by default)

Well when I use it for everything, it doesn't return anything.

Like this

$search_term = $request->get('query');
        $Clients = SourceClient::Where('application','=', 2)
        ->Where('name','LIKE','%'.$search_term.'%')
        ->Where('c_id','LIKE','%'.$search_term.'%')
        ->Where('oid','LIKE','%'.$search_term.'%')
        ->get();
        return response()->json($Clients);
		

I also tried this with no success

	$search_term = $request->get('query');
        $Clients = SourceClient::Where('name','LIKE','%'.$search_term.'%')
        ->orWhere('c_id','LIKE','%'.$search_term.'%')
        ->orWhere('oid','LIKE','%'.$search_term.'%')
	->AND('application', '=', 2)
        ->get();
        return response()->json($Clients);

It's another pb, just put one where, debug, then put the second one, debug, .... and it'll work.

Strange thing is that if I add the following, it works great

$search_term = $request->get('query');
$Clients = SourceClient::Where('application', '=',  $application)
->Where('name','LIKE','%'.$search_term.'%')   

BUT

if I try to add another where like this. It doesn't return anything

$search_term = $request->get('query');
$Clients = SourceClient::Where('application', '=',  $application)
->Where('name','LIKE','%'.$search_term.'%')  
->Where('oid','LIKE','%'.$search_term.'%')

I tried to shuffle them around like this. This works also

$search_term = $request->get('query');
$Clients = SourceClient::Where('application', '=',  $application)
->Where('oid','LIKE','%'.$search_term.'%')

when I add more than two "Where" statments together, i don't get any results. So Strange!

when I add more than two "Where" statments together, i don't get any results

It works fine, that's just that you have no record that matches the 2 where!

Look at your sql* using this doc : https://laravel.com/docs/8.x/queries#debugging

*directly in your db

I see what you're saying. The issue here is that I need something like an "ANDWHERE"

In my case. I need to have the application id match and the name, oid and c_id. They have to match the search term and the id. See what I mean?

I see when I add the "dd()" it shows the query. Thats a great tip.

@dk4210 actually you already have the answer, if you do

$search_term = $request->get('query');
        $sql = SourceClient::Where('application','=', 2)
        ->Where('name','LIKE','%'.$search_term.'%')
        ->Where('c_id','LIKE','%'.$search_term.'%')
        ->Where('oid','LIKE','%'.$search_term.'%')
        ->toSql();
dd($sql);

so

$search_term = $request->get('query');

$Clients = SourceClient::where('application', 2)
            ->where(function ($q) use ($search_term) {
                $q->where('name','LIKE','%'.$search_term.'%')
                  ->orWhere('c_id','LIKE','%'.$search_term.'%')
                  ->orWhere('oid','LIKE','%'.$search_term.'%');
            })
            ->get();

return response()->json($Clients);

Thanks for you help. This is what worked. I used parameter grouping

$application = 2;

        $search_term = $request->get('query');
        $Clients = SourceClient::Where('application',$application)
        ->where(function($query) use ($search_term)
        {
            $query->Where('name','LIKE','%'.$search_term.'%');
            $query->OrWhere('oid','LIKE','%'.$search_term.'%');
            $query->OrWhere('c_id','LIKE','%'.$search_term.'%');
        })