Cannot save data in more than one array in Laravel

Question

I am trying to save data in Laravel which has multiple arrays.

The array looks like this:

Array
(
    [0] => Array
        (
            [client_personnel_name] => Ron
            [client_id] => 52
            [client_personnel_email] => [email protected]
        )
    [1] => Array
        (
            [client_personnel_name] => John
            [client_id] => 52
            [client_personnel_email] => [email protected]
        )

)

When I save this data:

$personnel = ClientsPersonnel::create($client_personnel);
$personnel->save();

On debugging what data is being created to insert. This is what I get in the attributes where the sent data is stored

[attributes:protected] => Array
        (
            [updated_at] => 2015-04-23 06:53:05
            [created_at] => 2015-04-23 06:53:05
            [id] => 2
        )

How can I save the data which has multiple arrays?

loop the array and save seperately

Eng Cy
– Eng Cy

2015-04-23 07:07:23 +00:00
Commented Apr 23, 2015 at 7:07 — Eng Cy
– Eng Cy, Commented Apr 23, 2015 at 7:07

Jayson · Accepted Answer · 2015-04-23 07:12:57Z

1

You can use DB::insert(), like this:

DB::table('client_personnel')->insert(array($client_personnel));

As an alternative, you could do this using loop like.

foreach ($personnels as $personnelAttributes) {
    $personnel = new ClientsPersonnel($personnelAttributes);
    $personnel->save();
}

Regards,

answered Apr 23, 2015 at 7:12

Jayson

1,1097 silver badges27 bronze badges

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

Comments

Margus Pala · Accepted Answer · 2015-04-23 07:10:00Z

0

Laravel Eloquent does not have bulk update nor insert function. You need to create new ClientsPersonnel for each subarray and save it individually.

answered Apr 23, 2015 at 7:10

Margus Pala

8,7339 gold badges45 silver badges53 bronze badges

Comments

smottt · Accepted Answer · 2015-04-23 07:36:30Z

0

Just loop the arrays and insert seperately:

foreach ($client_personnel as $client) {
    ClientsPersonnel::create($client);
}

edited Apr 23, 2015 at 7:36

smottt

3,33011 gold badges41 silver badges47 bronze badges

answered Apr 23, 2015 at 7:14

Eng Cy

1,55712 silver badges16 bronze badges

Collectives™ on Stack Overflow

Cannot save data in more than one array in Laravel

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related