Bitcoin address : 1Lj5e1fmGTqGWSbvSHZ5kBPvwaHEebuPgJ
Litecoin address : LcMjDN72CvzBAyAZn7rYSkWTLsksfmeq4q
Insert and update batch (bulk) in laravel
composer require mavinoo/laravel-batch:dev-master
NOTE: Click to install the previous version 1.0.
file app.php in array providers :
Mavinoo\LaravelBatch\LaravelBatchServiceProvider::class,
file app.php in array aliases :
'Batch' => Mavinoo\LaravelBatch\LaravelBatchFacade::class,
$table = 'users'; $value = [ [ 'id' => 1, 'status' => 'active', 'nickname' => 'Mohammad' ] , [ 'id' => 5, 'status' => 'deactive', 'nickname' => 'Ghanbari' ] , ]; $index = 'id'; Batch::update($table, $value, $index); $table = 'users'; $value = [ [ 'id' => 1, 'status' => 'active' ], [ 'id' => 5, 'status' => 'deactive', 'nickname' => 'Ghanbari' ], [ 'id' => 10, 'status' => 'active', 'date' => Carbon::now() ], [ 'id' => 11, 'username' => 'mavinoo' ] ]; $index = 'id'; Batch::update($table, $value, $index); $table = 'users'; $columns = [ 'firstName', 'lastName', 'email', 'isActive', 'status', ]; $values = [ [ 'Mohammad', 'Ghanbari', 'emailSample_1@gmail.com', '1', '0', ] , [ 'Saeed', 'Mohammadi', 'emailSample_2@gmail.com', '1', '0', ] , [ 'Avin', 'Ghanbari', 'emailSample_3@gmail.com', '1', '0', ] , ]; $batchSize = 500; // insert 500 (default), 100 minimum rows in one query $result = Batch::insert($table, $columns, $values, $batchSize); // result : false or array sample array result: Array ( [totalRows] => 384 [totalBatch] => 500 [totalQuery] => 1 )