How to get value of multi select in Laravel 5.4

Question

I am using multi select of adminlte. I wan't to get value of multi select, How can I get it

Output of dd($request)

VIEW

<select id="leave_status" name="leave_status[]" title="Leave Status" 
  class="form-control select2" multiple="multiple">       
   <option value="1">Alabama</option>
   <option value="2">Alaska</option>
   <option value="3">California</option>
   <option value="4">Delaware</option>
   <option value="5">Tennessee</option>
   <option value="6">Texas</option>
   <option value="7">Washington</option>
</select>

Controller

function searchLeaveStatus(Request $request){
       $status = $request->input('leave_status');
       $status = implode(',', $status);
       $leave_list = LeaveStatus::whereIn('leave_status', $status)->get();
       dd(leave_list );
   }

Output

Invalid argument supplied for foreach()

@UsmanJdn I already find that but its not working, its give me error Invalid argument supplied for foreach() — Mathew Magante, Aug 14 '18 at 09:53
Are you sure you using `$request->input('leave_status')` ? You don't need to put `[]` here. — Giedrius Kiršys, Aug 14 '18 at 09:54
@GiedriusKiršys I update my question for better information. — Mathew Magante, Aug 14 '18 at 10:03

score 4 · Answer 1 · answered Aug 14 '18 at 09:59

You must send data to the controller with a function like this:

function getData(Request $request){
    $items = $request->get('leave_status');
    $selected_items = '';
    foreach($items as $item){
        \\ do something
        $selected_items .= $item.',';
    }
    dd($selected_items);
}

with this, you can get selected items.

lagbox · Accepted Answer · 2018-08-14T13:49:41.350

2

Not sure why you are imploding that array ... whereIn is going to try an iterate the $values arg (2nd arg) you are passing in.

LeaveStatus::whereIn('leave_status', $request->input('leave_status', []))->get();

Laravel Docs - 5.4 - Query Builder - Wheres - whereIn/whereNotIn

Laravel Docs - 5.4 - Requests - Retrieving Input - Retrieving Input Value

edited Aug 14 '18 at 13:49

answered Aug 14 '18 at 10:11

lagbox

48,571
8
72
83

How to get value of multi select in Laravel 5.4

2 Answers2