/PHP/Laravel/Laravel create multiple rows

Laravel create multiple rows

Insert batch in laravel

$data = [
  ['name' => 'John', 'age' => 25],
  ['name' => 'Maria', 'age' => 31],
  ['name' => 'Julia', 'age' => 55],
];
DB::table('table_name')->insert($data);

Source: laracasts.com

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

Insert batch in laravel

$data = array(
    array('name'=>'Coder 1', 'rep'=>'4096'),
    array('name'=>'Coder 2', 'rep'=>'2048'),
    //...
);

Coder::insert($data);

Source: stackoverflow.com

Laravel create multiple rows

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

Similar codes

0 vote397 views1 answer
Laravel/framework[v7.29.0, ..., 7.x-dev] require ext-mbstring * -> it is missing from your system. Install or enable PHP's mbstring extension.
PHP Laravel
0 vote385 views1 answer
How to separate admin and user login in laravel
PHP Laravel
1 vote387 views1 answer
Laravel php artisan make:controller in subfolder
PHP Laravel
1 vote443 views1 answer
Laravel api form request validation 404
PHP Laravel
6 votes349 views4 answers
Laravel spatie asigne role
PHP Laravel
0 vote424 views1 answer
Route login not defined how to laravel problems fixed
PHP Laravel
44 votes445 views2 answers
Laravel version command
PHP Laravel
1 vote392 views1 answer
How to pass data to controller in laravel
PHP Laravel
19 votes378 views5 answers
Php artisan auth in laravel 8
PHP Laravel
4 votes387 views4 answers
Laravel meta csrf
PHP Laravel