Laravel array whereIn()

Question

I have a form to filter items:

and I'm looking for something similar to this in Laravel 5.3:

// some variables get from request()->input('...')
$mode = ['A'];
$type = ['a', 'b'];
$group = [0, 1];

// desirable query
$results = Item::whereIn([
    ['mode_id', $mode],
    ['type_id', $type],
    ['group_id', $group]
])->paginate(10);

I can do this

$results = Item::whereIn('mode_id', $mode)
               ->whereIn('type_id', $type)
               ->whereIn('group_id', $group)
               ->paginate(10);

but it's not a dynamic way. For example, if a user select nothing in mode, the query returns an empty array.

cespon · Accepted Answer · 2017-01-26 02:07:35Z

4

We can use conditional clauses:

$results = Item::
    when(!empty($mode), function ($query) use ($mode) {
        return $query->where('mode_id', $mode);
    })
    ->when(!empty($type), function ($query) use ($type) {
        return $query->where('type_id', $type);
    })
    ->when(!empty($group), function ($query) use ($group) {
        return $query->where('group_id', $group);
    })
    ->paginate(10);

answered Jan 26, 2017 at 2:07

cespon

5,8108 gold badges38 silver badges49 bronze badges

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

Comments

baikho · Accepted Answer · 2017-01-15 21:52:18Z

1

You can do:

$qb = Item::newQuery();

if (!empty($mode))
{
    $qb->whereIn('mode_id', $mode);
}

if (!empty($type))
{
    $qb->whereIn('type_id', $type);
}

if (!empty($group))
{
    $qb->whereIn('group_id', $group);
}

$results = $qb->paginate(10);

Or build your whereIn associative array w/o empty where's before passing it on.

answered Jan 15, 2017 at 21:52

baikho

5,3884 gold badges43 silver badges49 bronze badges

Comments

Hamid Raza · Accepted Answer · 2023-12-11 07:29:38Z

0

We can use array_filter to remove all falsey values:

$where = array_filter([
    'mode_id' => $mode,
    'type_id' => $type,
    'group_id' => $group
]);

$results = Item::where($where)->paginate(10);

answered Dec 11, 2023 at 7:29

Hamid Raza

421 silver badge8 bronze badges

Collectives™ on Stack Overflow

Laravel array whereIn()

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related