/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 vote148 views1 answer
.htaccess Prevent access to php.ini
PHP
0 vote109 views1 answer
When to use self over $this
PHP
0 vote154 views1 answer
Inner pages not found yii
PHP
9 votes163 views6 answers
 Notice: Undefined variable: username in G:\xampp\htdocs\Online Class Platform\students_register.php on line 166 
PHP
1 vote138 views1 answer
Php single quote vs double quote
PHP
4 votes272 views5 answers
Codeigniter base_url
PHP CodeIgniter
3 votes101 views1 answer
Sql where count greater than
PHP
2 votes143 views2 answers
Allowed memory size of 1610612736 bytes exhausted 4096
PHP
1 vote136 views1 answer
Insert data using model in laravel 8
PHP
2 votes187 views1 answer
Magento 2 change customers password
PHP