/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

0 vote160 views2 answers
Laravel get namespace
PHP Laravel
37 votes199 views6 answers
Laravel create or update
PHP Laravel
50 votes363 views6 answers
Laravel add column to table
PHP Laravel
49 votes236 views6 answers
Laravel clear all cache
PHP Laravel
4 votes175 views3 answers
Laravel use config
PHP Laravel
51 votes344 views6 answers
Create model with controller laravel
PHP Laravel
0 vote182 views1 answer
How to wirte laravel dd function in php
PHP Laravel
0 vote161 views1 answer
Field doesn't have default value laravel
PHP Laravel
0 vote183 views1 answer
Pusher in laravel array_merge(): Argument #2 is not an array
PHP Laravel
0 vote163 views1 answer
Composer create-project --prefer-dist laravel/laravel blog
PHP Laravel