laravel 8 insert multiple rows

Add Answer

Snippets answered on December 18, 2020 Popularity 10/10 Helpfulness 5/10

answer laravel 8 insert multiple rows

related insert multiple rows laravel

related how to insert multiple rows in mysql using laravel

related Laravel insert multiple rows from form

related laravel create multiple rows

laravel 8 insert multiple rows

Comment

$array = [
     ['value' => "value1", 'status_id' => 1],
     ['value' => "value2", 'status_id' => 2]
];

ModelName::insert($array);
// or
DB::table('table_name')->insert($array);

Popularity 10/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: insert laravel-8 php rows

Link to this answer
Share Copy Link

Contributed on Sep 02 2021

Snippets

0 Answers Avg Quality 2/10

Closely Related Answers

insert multiple rows laravel

Comment

$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

Popularity 10/10 Helpfulness 4/10 Language php

Source: stackoverflow.com

Tags: insert in

Link to this answer
Share Copy Link

Contributed on Jul 15 2021

Mohamad

0 Answers Avg Quality 2/10

how to insert multiple rows in mysql using laravel

Comment

/*
It is really easy to do a bulk insert in Laravel with or without the query builder.
You can use the following official approach.
*/


Entity::upsert([
    ['name' => 'Pierre Yem Mback', 'city' => 'Eseka', 'salary' => 10000000],
    ['name' => 'Dial rock 360', 'city' => 'Yaounde', 'salary' => 20000000],
    ['name' => 'Ndibou La Menace', 'city' => 'Dakar', 'salary' => 40000000]
], ['name', 'city'], ['salary']);

Popularity 10/10 Helpfulness 2/10 Language sql

Source: laravel.com

Tags: insert in

Link to this answer
Share Copy Link

Contributed on Dec 18 2020

Dialrock360

0 Answers Avg Quality 2/10

Laravel insert multiple rows from form

Comment

foreach($request->input('pr_item') as $key => $value) {

            $Record=new PurchaseRequestItemModel;

            $Record->pr_form_number = $request->get('pr_number')[$key];
            $Record->item_no = $request->get('pr_item')[$key];
            $Record->pr_qty = $request->get('pr_qty')[$key];
            $Record->pr_unit = $request->get('pr_unit')[$key];
            $Record->pr_description =$request->get('pr_desc')[$key]; 
            $Record->pr_cost_per_unit =$request->get('pr_cpu')[$key];
            $Record->pr_estimated_cost =$request->get('pr_cpi')[$key];

            $Record->save();
        }

Popularity 1/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: insert laravel php rows

Link to this answer
Share Copy Link

Contributed on Nov 06 2021

Nasty Nightingale

0 Answers Avg Quality 2/10

laravel create multiple rows

Comment

foreach($request->input('item') as $key => $value) {

            $Record= new ModelName;

            $Record->name = $request->get('name')[$key];
            $Record->item_no = $request->get('item')[$key];
            $Record->description =$request->get('desc')[$key]; 
            $Record->save();
        }

Popularity 1/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: laravel php rows

Link to this answer
Share Copy Link

Contributed on Nov 06 2021

Nasty Nightingale

0 Answers Avg Quality 2/10

laravel 8 insert multiple rows

Contents

More Related Answers

laravel 8 insert multiple rows

Closely Related Answers

insert multiple rows laravel

how to insert multiple rows in mysql using laravel

Laravel insert multiple rows from form

laravel create multiple rows

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.