Laravel eloquent using loop

Question

I am using eloquent query to filter data. My query is like this and it is working perfectly for now.

$users = User::where('username','LIKE','%'.request('username').'%')
            ->where('first_name','LIKE','%'.request('first_name').'%')
            ->where('last_name','LIKE','%'.request('last_name').'%')
            ->where('gender','LIKE','%'.request('gender').'%')
            ->where('password','LIKE','%'.request('password').'%')
            ->SimplePaginate(15);

My request data was like this.

However I need to update this query for dynamic fields. There can be different fields. What I did was to send the request in an associative array. So, my request data turned into like this,

What I intend to do is to put all request data in a search array. Then use a loop to run like the above query. How can I do that?

P.S. I checked in the forum and found some similar questions. Some of them are outdated. Others didn't solve my problem.

You have your data and what are you trying to achieve again? Update or use data for another search query — Lim Kean Phang
– Lim Kean Phang, Commented Feb 5, 2019 at 6:07
I want to use new query using 'search' associative array to get the same result. If I use 'search' array, then I can put any number of field in the array. — Nabil Farhan
– Nabil Farhan, Commented Feb 5, 2019 at 6:11

yrv16 · Accepted Answer · 2019-02-05 06:31:18Z

4

If I understand you right you can do like this:

$search = request('search', []);
$users = User::query();

foreach($search as $field=>$value)
{
    $users = $users->where($field,'LIKE','%'.$value.'%');        
}

$users = $users->SimplePaginate(15);

answered Feb 5, 2019 at 6:31

yrv16

2,2751 gold badge15 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nabil Farhan Over a year ago

Thanks. It works. P.S. what is the purpose of this '$users = User::query();' line?

yrv16 Over a year ago

@NabilFarhan You are welcome. it's start of your query because you don't have any condition after User:: all is formed in loop.

Jigar · Accepted Answer · 2019-02-05 06:49:34Z

0

You can try this.

$search = $request->get('search');

User::where(function ($q) use ($search){    
          foreach ($search as $key=>$value) {
            if($value != null ){   
                $q->where($key, 'like', "%{$value}%");  
            }
          }
 })->get();

answered Feb 5, 2019 at 6:49

Jigar

3,2933 gold badges36 silver badges55 bronze badges

Comments

Mozammil · Accepted Answer · 2019-02-05 06:55:45Z

0

The where() clause can also accept an array. With that in mind, you could map over your search parameters and convert it to the format you want and then feed it into the query.

For example:

$search = [
    'first_name' => 'John',
    'last_name'  => 'Smith'
];

$filters = collect($search)->map(function($value, $key) {
    return  [$key, 'LIKE', "%{$value}%"];
})->values()->toArray();

return User::where($filters)->SimplePaginate(15);

edited Feb 5, 2019 at 6:55

answered Feb 5, 2019 at 6:43

Mozammil

8,77017 silver badges30 bronze badges

Collectives™ on Stack Overflow

Laravel eloquent using loop

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related