Update multiple rows with different update values feature request · Issue #575 · laravel/ideas

PHOTO

Mon Jun 13 2022 15:01:07 GMT+0000 (Coordinated Universal Time)

Saved by @WMOH

public static function updateValues(array $values)
{
    $table = MyModel::getModel()->getTable();

    $cases = [];
    $ids = [];
    $params = [];

    foreach ($values as $id => $value) {
        $id = (int) $id;
        $cases[] = "WHEN {$id} then ?";
        $params[] = $value;
        $ids[] = $id;
    }

    $ids = implode(',', $ids);
    $cases = implode(' ', $cases);
    $params[] = Carbon::now();

    return \DB::update("UPDATE `{$table}` SET `value` = CASE `id` {$cases} END, `updated_at` = ? WHERE `id` in ({$ids})", $params);
}

https://github.com/laravel/ideas/issues/575

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

Laravel

@WMOH

How to logout a user from API using laravel Passport - log out from all the devices where he's logged in How to logout a user from API using laravel Passport - Stack Overflow authentication - How to add additional condition to Laravel 6 Auth attempt() method? - Stack Overflow replace password reset mail template with custom template laravel 5.3 - Stack Overflow Laravel: How to use foreach loop to decrease stock based on order quantity - Stack Overflow Update multiple rows with different update values feature request · Issue #575 · laravel/ideas Laravel 9 Eloquent WHERE Like Query Example Tutorial php - How can I manually return or throw a validation error/exception in Laravel? - Stack Overflow Dirty Jobs: Debugging Till the Last Minute | HackerNoon Carbon - A simple PHP API extension for DateTime. Detecting slow database operations in Laravel 9.x — Amit Merchant — A blog on PHP, JavaScript, and more Detecting slow database operations in Laravel 9.x — Amit Merchant — A blog on PHP, JavaScript, and more InsertUsing - Laravel - Functions Code php - Laravel | Special validation of a lot of data - Stack Overflow Laravel Migrations change/update - Stack Overflow php - Laravel Eloquent: How to order results of related models? - Stack Overflow php - Laravel Increment / Decrement to update display order field - Stack Overflow php - Laravel Eloquent update just if changes have been made - Stack Overflow

Browse more snippets >>