/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

0 vote100 views1 answer
Laravel carbon Could not parse '28/09/2021, 12:00:00 pm': DateTime::__construct(): Failed to parse time string (28/09/2021, 12:00:00 pm) at position 0 (2): Unexpected character
PHP
-1 vote118 views1 answer
Laravel hide columns
PHP Laravel
0 vote117 views1 answer
Double in migration laravel
PHP Laravel
0 vote93 views1 answer
Magento2 move Exception #0 (Exception): Notice: Undefined offset: 2 in /var/www/nucleus/htdocs/vendor/magento/framework/Encryption/Encryptor.php on line 591
PHP
0 vote95 views1 answer
Get value from stdclass object
PHP
4 votes108 views2 answers
Php array to console
PHP
0 vote101 views1 answer
Get current tax page
PHP
0 vote119 views1 answer
Store image to s3 laravel
PHP Laravel
2 votes94 views1 answer
Wordpress get post time
PHP
1 vote103 views2 answers
Set nav link active on the basis of route laravel
PHP