/PHP/Laravel/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 vote261 views1 answer
Laravel 8 jwt api authentication
PHP Laravel
1 vote258 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.sessions' doesn't exist (SQL: select * from `sessions` where `id` = sXWuwluhxC2HlCzzq7jDyPGJFriLGdxQj8bPtcgC limit 1)
PHP Laravel
42 votes244 views6 answers
Laravel cache remember
PHP Laravel
0 vote262 views1 answer
Laravel cron job on shared hosting
PHP Laravel
0 vote223 views1 answer
Quitar html con laravel 5
PHP Laravel
1 vote218 views2 answers
Time left laravel seconds
PHP Laravel
1 vote280 views2 answers
Htaccess redirect https laravel
PHP Laravel
0 vote205 views1 answer
Laravel blade trim whitespace
PHP Laravel
0 vote223 views1 answer
Subquery in laravel
PHP Laravel
8 votes256 views1 answer
Object not found in laravel xampp
PHP Laravel