/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

9 votes232 views2 answers
Laravel collection filter
PHP Laravel
0 vote317 views1 answer
Laravel where 2 column
PHP Laravel
1 vote325 views1 answer
Get current month record in laravel
PHP Laravel
1 vote310 views1 answer
Groupby in laravel with count
PHP Laravel
0 vote333 views1 answer
Include navbar or part in layout in laravel blade template
PHP Laravel
0 vote306 views1 answer
Laravel Pusher 401 Unauthorized
PHP Laravel
0 vote294 views1 answer
Laravel Your requirements could not be resolved to an installable set of packages.
PHP Laravel
0 vote323 views1 answer
Laravel route limit parameter
PHP Laravel
16 votes327 views5 answers
Laravel one command for model table and controller
PHP Laravel
48 votes362 views6 answers
Laravel join table
PHP Laravel