How to insert multiple rows in laravel, need explanation

Question

I want to insert multiple rows in a table, where the data collection I am inserting has a unique number. For example : I am inserting 2 row for a user_id number 1. My codes from controller is : I want to keep DB::table() instead of laravel eloquent

foreach($post_data['user_id'] as $key => $no){
        $set_base  = DB::table('package_user')
            ->Insert([
                'base_id' => $post_data['base_id'],
                'base_title' => $post_data['base_title'],
                'user_id' => $no,
                'package_id' => $post_data['package_id'],
                'plan_id' =>  $post_data['plan_id'],
                'currency' => $post_data['currency'],
                'payable_plan_amount' => $post_data['total_amount'],
                'created_at' =>  Carbon::now()

            ]);
    }

Vaithiya Nathan · Accepted Answer · 2021-08-13 15:50:56Z

4

Please refer How to insert multiple rows from a single query using eloquent/fluent there is a solution for both eloquent and querybuilder

      $data = [
    ['user_id'=>'Coder 1', 'subject_id'=> 4096],
    ['user_id'=>'Coder 2', 'subject_id'=> 2048],
];
Model::insert($data); // Eloquent approach
DB::table('table')->insert($data); // Query Builder approach

edited Aug 13, 2021 at 15:50

answered Aug 13, 2021 at 15:45

Vaithiya Nathan

562 silver badges8 bronze badges

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

2 Comments

azim Over a year ago

so we don't need any foreach loop ?

Vaithiya Nathan Over a year ago

Yes you don't need foreach..if it's worked please accept the answer

saifulmasud · Accepted Answer · 2022-12-13 23:08:28Z

0

You can also use fill() method if the model instance already created with the pre-defined populated datas.

<code>
    $modelObj = new Model();
    $modelCollection = collect($request->input())->all();
    $modelObj->fill($modelCollection);
    $modelObj->save();
</code>

answered Dec 13, 2022 at 23:08

saifulmasud

72 bronze badges

Collectives™ on Stack Overflow

How to insert multiple rows in laravel, need explanation

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related