How to increment or decrement a column value in Laravel?

How to increment or decrement a column value in Laravel?

If you think Laravel Eloquent mechanism is limited then you are wrong because there are lots of helper function that makes Laravel awesome.

A simple example here that everyone think to do in a straightforward way for increment and decrement a column value of database table.

  1. $article = Article::find($article_id);
  2. $visitors = $article->visitors + 1;
  3. $article->update(['visitors' => $visitors]);

In above example we get the row first then add calculation and finally update row.

But Laravel made this task very easy with increment and decrement function.

Increment a column value
  1. Article::find($article_id)->increment('visitors');

If you want to customize increment value then passes to control the amount by which column gets incremented.

  1. Article::find($article_id)->increment('visitors',2);
Decrement a column value

Same as increment you can use decrement function to decrement a column value in Laravel.

  1. Article::find($article_id)->decrement('visitors');

As you see in above example we pass second argument to increment column value by custom value, In the same way we will pass second argument to decrement by given value but let you know one thing that second argument is optional.

  1. Article::find($article_id)->decrement('visitors',2);

You can also use DB query builder that also provides to increment and decrement a column value.

  1. DB::table('articles')->increment('visitors');
  1. DB::table('articles')->decrement('visitors');

You can also achieve this by update query.

  1. Article::where('id', $article_id)->update(['visitors' => DB::raw('visitors + 1')]);
  1. Article::where('id', $article_id)->update(['visitors' => DB::raw('visitors - 1')]);

Phone: (+91) 8800417876
Noida, 201301
sakarya escort sakarya escort sakarya escort