Laravel 5 / Eloquent - Handling Array Parameters in Dynamic Where Method Input

Question

I have a repository function that gets data by using:

public function get($request){

    return User::where($request)->get();    

}

where the $request array is dynamic. The above works well as long as I pass in regular key value pairs:

$request = array(
    'name' => 'mike',
    'age' => 45
);

The above translates to this SQL:

SELECT * 
FROM users
WHERE name = 'mike' AND age = 45;

Every once in a while, I would like to pass in an array as one of the properties for $request:

$request = array(
    'name' => 'mike',
    'age' => array(45, 46)
)

and have it translate into the following SQL:

SELECT *
FROM users
WHERE name = 'mike' AND age IN(45, 46);

Any properties set as an array in $request should be treated as a where in statement as opposed to a vanilla where statement.

How would I do this?

user1669496 · Accepted Answer · 2016-11-04 12:25:04Z

1

This should handle it nicely...

public function get($request)
{
    $query = User::query();
    foreach ($request as $key => $value) {
        if (is_array($value)) {
            $query->whereIn($key, $value);
        } else {
            $query->where($key, $value);
        }
    }

    return $query->get();
}

edited Nov 4, 2016 at 12:25

answered Nov 3, 2016 at 20:13

user1669496

33.3k9 gold badges76 silver badges65 bronze badges

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

2 Comments

Lloyd Banks Over a year ago

newQuery() isn't a static method. Anyway to do this without instantiating a new instance of my model?

Jan Willem Over a year ago

Just use query() instead of newQuery().

Ahajji87 · Accepted Answer · 2016-11-03 20:11:29Z

0

You need to use the whereIn statement, something like:

User::where(['name' => 'jhon'])->whereIn(['age' => [45, 46])->get();

answered Nov 3, 2016 at 20:11

Ahajji87

513 bronze badges

Comments

Eric Tucker · Accepted Answer · 2016-11-03 22:18:22Z

0

Check out the when() method https://laravel.com/docs/master/queries#conditional-clauses

In your case it would be:

public function get($request)
{
    $query = User::newQuery();

    foreach ($request as $key => $value) {
        $query->when(is_array($value), function($query)
        {
            return $query->whereIn($key, $value);
        }, function($query) use($key, $value)
        {
            return $query->where($key, $value);
        });
    }

    return $query->get();
}

answered Nov 3, 2016 at 22:18

Eric Tucker

6,3851 gold badge28 silver badges39 bronze badges

Collectives™ on Stack Overflow

Laravel 5 / Eloquent - Handling Array Parameters in Dynamic Where Method Input

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