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

How to insert multiple rows in mysql using laravel

/*
It is really easy to do a bulk insert in Laravel with or without the query builder.
You can use the following official approach.
*/


Entity::upsert([
    ['name' => 'Pierre Yem Mback', 'city' => 'Eseka', 'salary' => 10000000],
    ['name' => 'Dial rock 360', 'city' => 'Yaounde', 'salary' => 20000000],
    ['name' => 'Ndibou La Menace', 'city' => 'Dakar', 'salary' => 40000000]
], ['name', 'city'], ['salary']);

Source: laravel.com

Similar codes

1 vote154 views1 answer
Wp-config.php define home page
PHP
0 vote68 views1 answer
How to add a css class to login page in wordpress
PHP
1 vote121 views1 answer
Laravel plural
PHP Laravel
0 vote116 views1 answer
Laravel withcount change name
PHP
1 vote112 views1 answer
$this
PHP
37 votes114 views4 answers
How to generate unique alphanumeric 6 digit code through php myadmin
PHP
15 votes103 views4 answers
Php remove file
PHP
39 votes129 views6 answers
Laravel foreign key constraint
PHP Laravel
35 votes114 views5 answers
Remove the Last Character From a String in PHP
PHP
1 vote135 views2 answers
Get the value without setter method laravel
PHP Laravel