/PHP/Laravel/Insert multiple rows laravel

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

11 votes179 views3 answers
How to make validate error when password doesnt match with password confirm laravel
PHP Laravel
0 vote188 views1 answer
Route pattern cannot reference variable name more than once. laravel
PHP Laravel
0 vote187 views1 answer
Modifier laravel migration to add a comment a column (MySQL/PostgreSQL)
PHP Laravel
0 vote199 views1 answer
How to install or setup sanctum for laravel api authentication
PHP Laravel
40 votes175 views6 answers
Laravel drop column
PHP Laravel
1 vote177 views2 answers
Laravel Cannot add foreign key constraint
PHP Laravel
24 votes184 views6 answers
Laravel create model
PHP Laravel
17 votes186 views6 answers
Laravel Routing
PHP Laravel
15 votes185 views1 answer
Laravel skip requirements
PHP Laravel
13 votes172 views6 answers
Laravel count
PHP Laravel