Laravel: Filtering results based on input from multiple checkboxes

Question

Struggling to figure out how to filter data in view using checkboxes. If only one location is selected, then it's straightforward. But what if multiple locations are selected? Is this a @foreach?

My view

<form method="post" action="filter">    
{{ csrf_field() }}
<input type="checkbox" name="locationfilter[]" value="Chicago">Chicago</label>
<input type="checkbox" name="locationfilter[]" value="New York">New York</label>
<button type="submit" class="btn btn-primary"> Submit </button>

My controller

$lofilter = implode(", ", $request->get('locationfilter'));
$mypostings = Postings::where('location', 'LIKE', '%'. $lofilter .'%')->get();

Are you trying to filter the locations in the view or the controller? — darthaditya
– darthaditya, Commented Nov 27, 2017 at 6:17
whereIN condition will work for comma separated match in Laravel. — Bhaumik Pandhi
– Bhaumik Pandhi, Commented Nov 27, 2017 at 6:40

Casper · Accepted Answer · 2017-11-27 06:31:07Z

3

You can use whereIn() function to get values from given array,

users = DB::table('users')->whereIn('id', [1, 2, 3])->get();

if you want to use LIKE operator try like this,

$checkbox = []; //assume this array as selected checkboxes
DB::query()
->Where(function ($query) use($checkbox) {
    for ($i = 0; $i < count($checkbox ); $i++){
          $query->orwhere('location', 'like',  '%' . $checkbox [$i] .'%');
    }  
})->get();

answered Nov 27, 2017 at 6:31

Casper

1,53911 silver badges19 bronze badges

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

3 Comments

Radu Over a year ago

Sorry I'm beginner in laravel & eloquent but shouldn't be $query->where instead of $query->orwhere?

Casper Over a year ago

read this one, laravel.com/docs/5.2/queries#advanced-where-clauses

Radu Over a year ago

@CasperSL I finally get it, I know I'm slow but I'm 50 years old :) ! You have used orwhere because you will have a lot's of "wheres" due to the for cycle and you have to get all the incidences :) Thank you again!

Collectives™ on Stack Overflow

Laravel: Filtering results based on input from multiple checkboxes

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