Insert Multiple Records At Once With Laravel

Question

I am inserting the data to the rows one by one, but I have heard somewhere that it requires much time if there are many data to insert. So what are the ways of inserting them all at once?

public function add(Request $request)
{
    if ($request->ajax()) {
        $books = $request->books;
        foreach ($books as $book) {
            if (!empty($book)) {
                $add = new Book;
                $add->name = $book;
                $add->user_id = Auth::user()->id;
                $add->save();
            }
        }
    }
}

[This older question may help](http://stackoverflow.com/questions/29723865/how-to-insert-multiple-rows-from-a-single-query-using-eloquent-fluent) the latest comment on the answer links to [something helpful](https://laravel.com/docs/5.1/eloquent-relationships#inserting-related-models) — , Aug 24 '16 at 03:04
Possible duplicate of [Bulk Insertion in Laravel using eloquent ORM](http://stackoverflow.com/questions/12702812/bulk-insertion-in-laravel-using-eloquent-orm) — maiorano84, Aug 24 '16 at 03:04
(I'm not a laravel developer) It seems like any answer coming from more than a year ago wouldn't still be relevant? I guess it depends on the veraion... — , Aug 24 '16 at 03:06

score 30 · Answer 1 · answered Sep 08 '16 at 11:38

public function add(Request $request)
  {
    if($request->ajax())
    {
       $books=$request->books;
       $data = array();
       foreach($books as $book)
       {
        if(!empty($book))
        {
          $data[] =[
                    'name' => $book,
                    'user_id' => Auth::id(),
                   ];                 

       }}
      Book::insert($data);
       <!--DB::table('books')->insert($data);-->
     }}

make sure imported use Illuminate\Support\Facades\Auth;

score 12 · Answer 2 · answered Sep 08 '16 at 17:06

Insert multiple records using the Model

As others have pointed out, using the Query Builder is the only way to insert multiple records at a time. Fortunately Laravel and the Eloquent ORM are coupled in many useful ways. This coupling allows you to use a Model to get a Query Builder instance that is set for that Model.

// use Auth;
// use Carbon;
// use App\Book;

public function add(Request $request)
{
    if($request->ajax())
    {
        // Submitted books
        $books = $request->books;

        // Book records to be saved
        $book_records = [];

        // Add needed information to book records
        foreach($books as $book)
        {
            if(! empty($book))
            {
                // Get the current time
                $now = Carbon::now();

                // Formulate record that will be saved
                $book_records[] = [
                    'name' => $book,
                    'user_id' => Auth::user()->id,
                    'updated_at' => $now,  // remove if not using timestamps
                    'created_at' => $now   // remove if not using timestamps
                ];
            }
        }

        // Insert book records
        Book::insert($book_records);
    }
}

This is to0 bad you posted copy of mine @Qevo – Hamelraj Sep 09 '16 at 04:08 — Hamelraj, Sep 09 '16 at 04:08
Please stop copy-pasting other's solutions. – VijayRana Apr 13 '22 at 10:22 — VijayRana, Apr 13 '22 at 10:22

score 9 · Answer 3 · answered Aug 24 '16 at 03:11

You should be able to do something like below:

DB::table('users')->insert([
    ['email' => 'taylor@example.com', 'votes' => 0],
    ['email' => 'dayle@example.com', 'votes' => 0]
]);

Put all the values you want to insert in to an array and then pass it to the insert function.

Source: https://laravel.com/docs/5.1/queries#inserts

score -1 · Answer 4 · answered Aug 05 '23 at 09:48

-1

foreach($request->refereename as $i =>$value)
  {
    $referees[]=[
        'refereename'=>$request->refereename[$i],
        'refereecompany'=>$request->refereecompany[$i],
        'refereephone'=>$request->refereephone[$i],
        'refereeemail'=>$request->refereeemail[$i],
        'relationship'=>$request->relationship[$i],
        'refereelocation'=>$request->refereelocation[$i],
        'created_at'=>$date,
        'updated_at'=>$date,
        ];
  }

  DB::table('db_referees')->insert($referees); // Query Builder approach

answered Aug 05 '23 at 09:48

Akintan Robert

1
1

1

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Aug 05 '23 at 10:01

score -3 · Answer 5 · edited May 23 '17 at 10:29

-3

If you need Eloquent model events - there is no other way to insert multiple models. In other way - check Anushan W answer

edited May 23 '17 at 10:29

Community

1
1

answered Aug 24 '16 at 09:48

Bogdan Koliesnik

780
6
14

Insert Multiple Records At Once With Laravel

5 Answers5

Insert multiple records using the Model

Linked