CODEWITHSUNDEEP
phpmysqllaravelincrement
Vainglory07
Vainglory07

Reputation: 5273

Increment columns in laravel

Is there a way to increment more than one column in laravel?

Let's say:

DB::table('my_table')
->where('rowID', 1)
->increment('column1', 2)
->increment('column2', 10)
->increment('column3', 13)
->increment('column4', 5);

But this results to:

Call to a member function increment() on integer

I just want to find an efficient way to do this using the given functions from laravel. Thanks. Any suggestions will do.

Upvotes: 43

Views: 81879

Answers (9)

Benson Arafat
Benson Arafat

Reputation: 499

Model::where('id', "rowID")->increment('columne1');

This works for me

Upvotes: 0

HTMHell
HTMHell

Reputation: 6006

In the latest version of 9.x, you can increment and decrement multiple columns using incrementEach and decrementEach methods:

DB::table('users')->incrementEach([
    'votes' => 5,
    'balance' => 100,
]);

(taken from the documentation)

Upvotes: 4

Waad Mawlood
Waad Mawlood

Reputation: 888

just use this code

\App\Models\User::find(1)->increment('column1');  //id = 1

or multi recorded

\App\Models\User::where('column1','>','100')->increment('column1');

Upvotes: 1

genarocupil
genarocupil

Reputation: 51

$id=5;
$votes=20;
DB::table('users')
   ->where('id', $id)
   ->update([
       'votes' => DB::raw('votes + '.$votes)
]);

Upvotes: 1

Ziaur Rahman
Ziaur Rahman

Reputation: 1188

Now in laravel 5.7 laravel query builder, increment and decrement, it can be done easily.

Model::where('id', "rowID")->increment('columne1');`

or you can use DB

DB::table("my_table")->where('id', "rowID")->increment('column1');

Upvotes: 13

Staffan Storm Enemark
Staffan Storm Enemark

Reputation: 132

For future reference in 5.2 it has been made do able by doing the following

You may also specify additional columns to update during the operation: 

DB::table('users')->increment('votes', 1, ['name' => 'John']);

Source: https://laravel.com/docs/5.2/queries#updates

Upvotes: 10

Praveen AK
Praveen AK

Reputation: 621

Increments and Decrements in Laravel Eloquent Model

Add to cart option is one of the most important functions in e-commerce websites. The tricky part is getting the number of items in the cart to display on the cart icon. The predominant approach to get this done is using the increment and decrement function on Laravel. This also facilitates the addition or removal of a product from your cart. The way to implement this function is ,

$user = User::find(‘517c43667db388101e00000f’);
$user->cart_count++;
// $user->cart_count--; // for decrement the count
$user->save()

An alternate and easier way is,

$user = User::find($article_id);
$user->increment('cart_count');

Also these will work:

$user->increment('cart_count');// increase one count
$user->decrement('cart_count'); // decrease one count
$user->increment('cart_count',10); // increase 10 count
$user->decrement('cart_count',10); // decrease 10 count

Upvotes: 39

lukasgeiter
lukasgeiter

Reputation: 152860

There is no existing function to do this. You have to use update():

DB::table('my_table')
   ->where('rowID', 1)
   ->update([
       'column1' => DB::raw('column1 + 2'),
       'column2' => DB::raw('column2 + 10'),
       'column3' => DB::raw('column3 + 13'),
       'column4' => DB::raw('column4 + 5'),
   ]);

Upvotes: 76

Luceos
Luceos

Reputation: 6720

First off, the result of increment is an integer according to the documentation: http://laravel.com/api/4.2/Illuminate/Database/Query/Builder.html

So you would have to do a call for each increment:

DB::table('my_table')
->where('rowID', 1)
->increment('column1', 2);
DB::table('my_table')
->where('rowID', 1)
->increment('column2', 10);
DB::table('my_table')
->where('rowID', 1)
->increment('column3', 13);
DB::table('my_table')
->where('rowID', 1)
->increment('column4', 5);

I'm unable to find any quicker solution, unless you want to solve it with a raw update query command.

Also your example code will probably generate an error as you've closed the statement with ; and continue with a new ->increment call on the next line.

Upvotes: 8

Related Questions