/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 vote211 views2 answers
How to use flash message in laravel
PHP Laravel
0 vote193 views1 answer
Laravel seeding with relationships
PHP Laravel
0 vote172 views1 answer
String length laravel validation
PHP Laravel
0 vote173 views2 answers
Default language laravel
PHP Laravel
18 votes192 views6 answers
Laravel carbon create date from string
PHP Laravel
0 vote193 views1 answer
Eager load relationships by default in the model laravel
PHP Laravel
33 votes178 views6 answers
Create migration command in laravel
PHP Laravel
39 votes205 views6 answers
Laravel foreign key constraint
PHP Laravel
0 vote208 views1 answer
Get database columns laravel
PHP Laravel
3 votes183 views1 answer
Laravel validation number greater than 0
PHP Laravel