Batch insert in Laravel 5.2

Question

I am using a API's with lot's of calculation almost 100 database fields at the end with a big Foreach loop.

In every iteration i insert data in database. I want to insert data in once at the end (Batch Insert like in CodeIgniter).

Any body have idea how to insert all data at the end of iteration. instead of every iteration it insert row in database.

I want to insert data at the end of loop. Any help or idea appreciated.

that is exactly i also looking. .. – M Arfan Jan 26 '17 at 10:24 — M Arfan, Jan 26 '17 at 10:24
https://github.com/mavinoo/laravelBatch – Mohammad Feb 04 '18 at 05:50 — Mohammad, Feb 04 '18 at 05:50

score 34 · Answer 1 · answered Jan 26 '17 at 10:23

34

Use insert() method for bulk insertion. First, build an array with this structure:

$data = [
    ['name' => 'John', 'age' => 25],
    ['name' => 'Maria', 'age' => 31],
    ['name' => 'Julia', 'age' => 55],
];

Then insert the data using Eloquent model:

Model::insert($data);

Or using query builder:

DB::table('table_name')->insert($data);

answered Jan 26 '17 at 10:23

Alexey Mezenin

2

Alexey Mezenin's answer should be marked as the solution – nemcaninz Jan 14 '19 at 00:26
After insertion will able to get Autoincrement Id with response – sankar muniyappa Aug 22 '19 at 10:08

1 Answers1