Laravel 5 - How to add multiple parameters to laravel array for db insert?

Question

I have an array of 3 companies, which need to be inserted into the db but with 2 additional parameters added to them.

$companyList = [{"name": "apple", "founder": "steve"},
                {"name": "google", "founder": "larry"},
                {"name": "facebook", "founder": "mark"},
               ];

Need to append these 2 parameters for each company (issue is in this step):

$companyListFinal = [];
foreach ($companyList as $company) {
  $companyListFinal[] = array_add($company,['keyAppend1' => 'key 1 appended',
                                            'keyAppend2' => 'key 2 appended'];
}

The final step is to insert the company list with the appended values into the DB:

DB::table('companies')->insert($companyListFinal);

I can't seem to be able to append the 2 new parameters to create the final array to insert:$companyListFinal

What's the correct way to add the parameters to each company so they are all inserted at bulk?

fremail · Accepted Answer · 2016-10-11 22:59:53Z

1

You need to use array_merge instead of array_add

answered Oct 11, 2016 at 22:59

fremail

3104 silver badges8 bronze badges

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

1 Comment

Wonka Over a year ago

Thank you, array_merge was the solution.

Chiragh Dewan · Accepted Answer · 2016-10-11 22:00:59Z

0

Try using array_push() instead on array_add(). That should do the job.

answered Oct 11, 2016 at 22:00

Chiragh Dewan

3771 silver badge11 bronze badges

1 Comment

Wonka Over a year ago

I tried array_push() instead but still didn't work. When we print this $companyListFinal it should list an array, with 3 objects, each with 4 fields, (the 2 old and the 2 newly appended). I am still unable to print that before entry to db as a check.

Collectives™ on Stack Overflow

Laravel 5 - How to add multiple parameters to laravel array for db insert?

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related