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
Attention Required! | Cloudflare

Sorry, you have been blocked

You are unable to access ressim.net

Why have I been blocked?

This website is using a security service to protect itself from online attacks. The action you just performed triggered the security solution. There are several actions that could trigger this block including submitting a certain word or phrase, a SQL command or malformed data.

What can I do to resolve this?

You can email the site owner to let them know you were blocked. Please include what you were doing when this page came up and the Cloudflare Ray ID found at the bottom of this page.