array data insert in laravel

Question

I am getting this kind of data from the database in array form.

Illuminate\Support\Collection {#1434
  #items: array:4 [
    0 => 20
    1 => 21
    2 => 22
    3 => 19
  ]
}

I want to insert the this array data through the controller For each array element.

 foreach($plucked as $data){
    $attendant_data = new EmployeeAttendant();
    $attendant_data->user_id = $data;
    $attendant_data->date = Carbon::now()->format('Y-m-d');
    $attendant_data->time = Carbon::now()->format('H:i:s');
    $attendant_data->present = '0';
    $attendant_data->save();
 }

Data is being inserted only for the first array element.

N69S · Accepted Answer · 2021-05-03 14:01:48Z

1

Just prepare the data and insert it.

$insertableAttendant = [];
foreach($plucked as $data){
    $attendant_data = [];
    $attendant_data['user_id'] = $data;
    $attendant_data['date'] = Carbon::now()->format('Y-m-d');
    $attendant_data['time'] = Carbon::now()->format('H:i:s');
    $attendant_data['present'] = '0';
    $insertableAttendant[] = $attendant_data;
 }
EmployeeAttendant::insert($insertableAttendant);

answered May 3, 2021 at 14:01

N69S

17.3k4 gold badges25 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

array data insert in laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related