README

This pachake add multi row update to Laravel Query Builder. It supports Laravel >= 9.

Installation

You can install the package via composer:

composer require canedoc/laravel-bulk-update

Usage

allow multi row update in one query.

In this example all rows in animes table that have : 1- email = 'aruto@best.com' and name = 'naruto' the age will be set to 33. 2- 'name' = 'sasuki' the email will be set to 'sasuki@best.com' 3- all rows will set is_alive to true

$data = [
    'age' => [
        ['email' => 'naruto@best.com', 'name' => 'naruto', 'age' => 33],
    ],
    'email' => ['email' => 'sasuki@best.com', 'name' => 'sasuki'],
    'is_alive' => true
]

\DB::table('animes')->where('is_active', true)->bulkUpdate($data);

Animes::where('is_active', true)->bulkUpdate($data);

Testing

composer test

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

BOUBRIT Nacim

License

The MIT License (MIT). Please see License File for more information.

canedoc / laravel-bulk-update

Maintainers

Details