/PHP/Laravel insert multiple rows from form

Laravel insert multiple rows from form

Insert multiple rows laravel

$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

Source: stackoverflow.com

Laravel insert multiple rows from form

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();
        }

Similar codes

9 votes284 views3 answers
Explode array from database php
PHP
0 vote302 views1 answer
Clear console php
PHP
0 vote292 views1 answer
Php set charset utf 8
PHP
0 vote316 views1 answer
Country code validation in laravel
PHP
0 vote338 views1 answer
In Connection.php line 664: could not find driver (SQL: select * from information_schema.tables where table_schema = news and table_name = migrations) In Connector.php line 67: could not find driver
PHP
21 votes316 views3 answers
Query sql in php
PHP
9 votes322 views3 answers
Uninstall phpmyadmin
PHP
53 votes301 views2 answers
Transforming string to integer in php
PHP
5 votes355 views5 answers
Laravel where creation is today carbon
PHP
13 votes341 views6 answers
Laravel route optional parameter
PHP Laravel