Bulk Insertion in Laravel using eloquent ORM

Question

How can we perform bulk database insertions in Laravel using Eloquent ORM   I want to accomplish this in Laravel  https   stackoverflow com a 10615821 600516 but I am getting the following error      SQLSTATE HY093   Invalid parameter number  mixed named and positional parameters

User · Answer

I searched many times for it  finally used custom timestamps like below    now   Carbon  now  - gt toDateTimeString    Model  insert         name   gt  Foo    created at   gt  now   updated at   gt  now         name   gt  Bar    created at   gt  now   updated at   gt  now         name   gt  Baz    created at   gt  now   updated at   gt  now

User · Answer

You can just use Eloquent  insert     For example    data   array      array  name   gt  Coder 1    rep   gt  4096        array  name   gt  Coder 2    rep   gt  2048                  Coder  insert  data

User · Answer

From Laravel 5 7 with Illuminate Database Query Builder you can use insertUsing method    query       foreach  oXML- gt results- gt item- gt item as  oEntry        date   date  Y-m-d H i s        query          oEntry- gt firstname       oEntry- gt lastname       date         Builder  insertUsing   first name    last name    date added    implode        query

User · Answer

Eloquent  insert is the proper solution but it wont update the timestamps  so you can do something like below    json array array map function   a                             return array merge  a   created at   gt                                               Carbon  now    updated at   gt  Carbon  now                                                                                            json array     Model  insert  json array     The idea is to add created at and updated at on whole array before doing insert

User · Answer

For category relations insertion I came across the same problem and had no idea  except that in my eloquent model I used Self   to have an instance of the same class in foreach to record multiple saves and grabing ids   foreach  arCategories as  v                        if  v gt 0            obj   new Self       this is to have new instance of own          obj- gt page id    page id           obj- gt category id    v           obj- gt save              without   obj   new Self    it only saves single record  when  obj was  this

User · Answer

We can update GTF answer to update timestamps easily   data   array      array           name   gt  Coder 1    rep   gt  4096            created at   gt date  Y-m-d H i s             modified at   gt  date  Y-m-d H i s                 array            name   gt  Coder 2    rep   gt  2048             created at   gt date  Y-m-d H i s              modified at   gt  date  Y-m-d H i s                           Coder  insert  data     Update  to simplify the date we can use carbon as  Pedro Moreira suggested    now   Carbon  now  utc  - gt toDateTimeString     data   array      array           name   gt  Coder 1    rep   gt  4096            created at   gt   now           modified at   gt   now               array            name   gt  Coder 2    rep   gt  2048             created at   gt   now            modified at   gt   now                         Coder  insert  data     UPDATE2  for laravel 5   use updated at instead of modified at   now   Carbon  now  utc  - gt toDateTimeString     data   array      array           name   gt  Coder 1    rep   gt  4096            created at   gt   now           updated at   gt   now               array            name   gt  Coder 2    rep   gt  2048             created at   gt   now            updated at   gt   now                         Coder  insert  data

User · Answer

This is how you do it in more Eloquent way         allintests           foreach  intersts as  item      intersts array contains input data          intestcat   new User Category             intestcat- gt memberid    item- gt memberid           intestcat- gt catid   item- gt catid           allintests      intestcat- gt attributesToArray              User Category  insert  allintests

User · Answer

start date   date  Y-m-d h m s                     end date   date  Y-m-d h m s   strtotime  start date        userSubscription  duration     months               user subscription array   array            array               user id    gt   request- gt input  user id                 user subscription plan id    gt   request- gt input  subscription plan id                 name    gt   userSubscription  name                 description    gt   userSubscription  description                 duration    gt   userSubscription  duration                 start datetime    gt   start date               end datetime    gt   end date               amount    gt   userSubscription  amount                 invoice id    gt                   transection datetime    gt                   created by    gt   1                status id    gt   1      array               user id    gt   request- gt input  user id                 user subscription plan id    gt   request- gt input  subscription plan id                 name    gt   userSubscription  name                 description    gt   userSubscription  description                 duration    gt   userSubscription  duration                 start datetime    gt   start date               end datetime    gt   end date               amount    gt   userSubscription  amount                 invoice id    gt                   transection datetime    gt                   created by    gt   1                status id    gt   1                        dd UserSubscription  insert  user subscription array      UserSubscription is my model name  This will return  true  if insert successfully else  false

User · Answer

To whoever is reading this  check out createMany   method          Create a Collection of new instances of the related model         param  array   records     return  Illuminate Database Eloquent Collection     public function createMany array  records         instances    this- gt related- gt newCollection         foreach   records as  record             instances- gt push  this- gt create  record               return  instances

User · Answer

Maybe a more Laravel way to solve this problem is to use a collection and loop it inserting with the model taking advantage of the timestamps    lt  php  use App Continent  use Illuminate Database Seeder   class InitialSeeder extends Seeder                  Run the database seeds                 return void             public function run                 collect                 name    gt   Am  rica                  name    gt     frica                  name    gt   Europa                  name    gt   Asia                  name    gt   Ocean  a              - gt each function   item   key                Continent  forceCreate  item                         EDIT   Sorry for my misunderstanding  For bulk inserting this could help and maybe with this you can make good seeders and optimize them a bit    lt  php  use App Continent  use Carbon Carbon  use Illuminate Database Seeder   class InitialSeeder extends Seeder                  Run the database seeds                 return void             public function run                  timestamp   Carbon  now             password   bcrypt  secret              continents                                    name    gt   Am  rica                   password    gt   password                   created at    gt   timestamp                   updated at    gt   timestamp                                                name    gt     frica                   password    gt   password                   created at    gt   timestamp                   updated at    gt   timestamp                                                name    gt   Europa                   password    gt   password                   created at    gt   timestamp                   updated at    gt   timestamp                                                name    gt   Asia                   password    gt   password                   created at    gt   timestamp                   updated at    gt   timestamp                                                name    gt   Ocean  a                   password    gt   password                   created at    gt   timestamp                   updated at    gt   timestamp                                     Continent  insert  continents

User · Answer

Problem solved    Alter table for migrate   table- gt timestamp  created at  - gt nullable  - gt useCurrent      Solution   Schema  create  spider news   function  Blueprint  table         table- gt bigIncrements  id         table- gt string  source  - gt nullable         table- gt string  title  - gt nullable         table- gt string  description  - gt nullable         table- gt string  daterss  - gt nullable          table- gt timestamp  created at  - gt useCurrent         table- gt timestamp  updated at  - gt useCurrent

[php] Bulk Insertion in Laravel using eloquent ORM

Examples related to php

Examples related to database

Examples related to laravel

Examples related to eloquent