How to handle multi-select drop-down forms for each row when implementing dynamic form saving in Laravel
<p>In my form, I have a dynamic table with multi-select dropdowns color_id[] and size_id[] with the same name in each row. I don't know how to save multiple selected values as comma separated values in each row stored in the database. I tried saving to database here but it didn't work. </p>
<p>HTML code: </p>
<pre class="brush:php;toolbar:false;"><table><tbody><td><select name="color_id[]" class="select2" id=" ;color_id" style="width:200px; height:100px;" required multiple></select></td><td> <select name="size_id[]" class=" select2" id="size_id" style="width:200px; height:100px;" required multiple> </select></td></tbody></table></pre>
<p>Laravel code saved in controller:</p>
<pre class="brush:php;toolbar:false;">$class_ids = $request->input('class_ids');
for($x=0; $x<count($class_ids); $x ) {
#code...
$color_ids = implode(',', $request->color_id[$x]);
$size_ids = implode(',', $request->size_id[$x]);
$data3[]=array(
'bom_code'=>$TrNo,
'bom_date'=>$request->bom_date,
'cost_type_id'=>$request->cost_type_id,
'Ac_code'=>$request->Ac_code,
'season_id'=>$request->season_id,
'currency_id'=>$request->currency_id,
'item_code' => $request->item_codes[$x],
'class_id' => $request->class_ids[$x],
'description' => $request->descriptions[$x],
'color_id' => $color_ids,
'size_array' => $size_ids,
'consumption' => $request->consumptions[$x],
'unit_id'=> $request->unit_ids[$x],
'rate_per_unit' => $request->rate_per_units[$x],
'wastage' => $request->wastages[$x],
'bom_qty' => $request->bom_qtys[$x],
'total_amount' => $request->total_amounts[$x],
);
}
BOMSewingTrimsDetailModel::insert($data3);</pre>