Laravel 7 - how to loop a request array to Controller for attaching data with eloquent

Question

Please help, so i want to use foreach to loop and attach data to database using Eloquent in my Controller, i passed this is the parsed data as an array :

array:3 [▼
  0 => "3"
  1 => "7"
  2 => "9"
]

and i want to loop (foreach) and save it to tables using attach() so it can be saved with the same ID in one time like this :

Course_ID | Facilitator_Id
--------------------------
1         | 2
1         | 3
1         | 4
--------------------------

this is the piece of blade :

<form method="POST" action="{{ '/courses' }}" enctype="multipart/form-data">
...
                            <div class="form-group row">
                            <label class="col-3" for="fasil_id">Fasilitator</label>
                            <div class="col-9">
                                <select class="form-control @error('fasil_id') is-invalid @enderror bootstrap-select" data-style="btn-white" multiple name="fasil_id[]" selected="{{ old('fasil_id') }}" required autocomplete="fasil_id">
                                 @foreach($facilitators as $data)
                                  <option value="{{$data->id}}">{{$data->nama}}</option>
                                 @endforeach
                                </select>
                                @error('fasil_id')
                                <span class="invalid-feedback" role="alert">
                                    <strong>{{ $message }}</strong>
                                </span>
                                @enderror
                            </div>
                        </div>
...
</form>

im using name="fasil_id[]" in the markup properties

and currently i'm using this method for looping :

 foreach($request->fasil_id as $fasil_id) {
 Course::find($id)->facilitators()->attach([$fasil_id]); }

but, sadly i always get this error :

htmlspecialchars() expects parameter 1 to be string, array given

Instead of ->attach([$fasil_id]) use ->attach($fasil_id). — Chris Cynarski
– Chris Cynarski, Commented Dec 22, 2020 at 16:51

ml59 · Accepted Answer · 2020-12-22 17:12:46Z

1

In your <select> opening tag you are setting selected="{{ old('fasil_id') }}".
But since fasil_id is an array it cannot be set as the selected value and {{ }} cannot print it.
Try to remove selected="{{ old('fasil_id').

As a side note: You can pass an array to the attach() method so you don't need to loop here. Just do it like this:

 Course::find($id)->facilitators()->attach($request->fasil_id);

edited Dec 22, 2020 at 17:12

answered Dec 22, 2020 at 17:04

ml59

1,6961 gold badge11 silver badges12 bronze badges

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

1 Comment

Rio Ramadhan Over a year ago

wow, it really worked! Thank you for your help, i didn't know you can pass an array using attach() without looping, thanks again

Collectives™ on Stack Overflow

Laravel 7 - how to loop a request array to Controller for attaching data with eloquent

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related