Array result in Laravel query

Question

I want to get products of selected brands can be 1 or more (using checkbox) in laravel but it returns result of only one of my selected brands.

Form

<form action="{{route('mysearch')}}" method="post">
{{csrf_field()}}

<div class="filter-content">
  <div class="checkbox">
   @foreach($brands as $brand)
    <label for="brands">
     <input name="brands[]" type="checkbox" value="{{$brand->id}}">
      {{$brand->title}}
    </label>
   @endforeach
  </div>
</div>

<button type="submit" class="btn btn-danger">submit</button>
</form>

function

public function mysearch(Request $request) {
 $brands = Brand::OfStatus('Active')->get();
 $brand = Input::has('brands') ? Input::get('brands') : [];
 $products = Product::where('brand_id', '=', $brand)->get();
 return view('front.search', compact('products', 'brands'));
}

If I choose brands lenovo and lg I only get result of lenovo brand.

Alexey Mezenin · Accepted Answer · 2018-03-01 08:57:47Z

2

Use the whereIn:

Product::whereIn('brand_id', $brand)->get();

answered Mar 1, 2018 at 8:57

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

3 Comments

djhru Over a year ago

Invalid argument supplied for foreach()

Alexey Mezenin Over a year ago

@djhru please show result of dd($request->brands);

djhru Over a year ago

it's working i'm sorry. (please wait 10 min till i'm allowed to accept your answer)

Collectives™ on Stack Overflow

Array result in Laravel query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related