Find rows matching values from array

Question

I have a form where user select one or more checkboxes like this:

{!! Form::Label('faults', 'Please select one of the following that best describes your device') !!}
                                            <div class="form-group">                                            
                                                @foreach($faults as $fault)
                                                <div class="col-md-4">
                                                    <span><i class="fa fa-question-circle" rel="popover" data-content="{{$fault->fault_tooltip}}"></i></span>
                                                    <label class="checkbox-inline">
                                                    <input id="faults" type="checkbox" name="faults[]" value="{{$fault->id}}">{{$fault->fault}}
                                                    </label>
                                                </div>
                                                @endforeach
                                            </div>

Now in my controller I am getting the input for faults like this:

$faults = Input::get('faults');

This returns something an array contining the ID's for each fault like this:

    array:2 [▼
  0 => "37"
  1 => "36"
]

I need to loop through the array and find each row in my faults table matching each id from the array and get other values like $fault->name and $fault->price.

I know this is pretty easy but I am starting with coding and I can't get my head around.

Any help will be much appreciated.

Thanks

Vivek Chaudhari · Accepted Answer · 2016-09-02 07:33:04Z

2

$slectedFaults = Input::get('faults');

if you have faults model in \App\ directory then do by following

$faults = Faults::whereIn('id',$slectedFaults)->get();

or do by foloowing way

 $faults = App\DB::table('faults')->whereIn('id',$slectedFaults)->get();

$faults have data selected from your database, then do the rest

$nameArray = [];
foreach($faults as $fault) {
  $nameArray[] = $fault->name;
  //do your thing here
}
print_r($nameArray); //it will print all fault names

answered Sep 2, 2016 at 7:33

Vivek Chaudhari

2,0102 gold badges16 silver badges21 bronze badges

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

Comments

Jeff · Accepted Answer · 2016-02-22 22:22:03Z

0

Do you have a Faults model? if so:

$faults = Faults::findMany(Input::get('faults'));

foreach($faults as $fault) {
   //do your thing here
}

Otherwise with a table:

$faults = DB::table('faults')
  ->select()
  ->whereIn('id',Input::get('faults'))
  ->get();

foreach($faults as $fault) {
   //do your thing here
}

answered Feb 22, 2016 at 22:22

Jeff

25.3k4 gold badges73 silver badges79 bronze badges

2 Comments

Alex Over a year ago

Thanks for responding that quick! That works but if I try to echo $fault_name (inside the loop: $fault_name = $fault->name;) I only get 1 fault, but the user selected two.

Jeff Over a year ago

if you do dd($faults) before the for loop which/how many faults do you see?

Collectives™ on Stack Overflow

Find rows matching values from array

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related