How to increment or decrement a column value in Laravel?

How to increment or decrement a column value in Laravel?

In this post we will give you information about How to increment or decrement a column value in Laravel?. Hear we will give you detail about How to increment or decrement a column value in Laravel?And how to use it also give you demo for it if it is necessary.

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]);
$article = Article::find($article_id);
$visitors = $article->visitors + 1;
$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');
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);
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');
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);
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');
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')]);
Article::where('id', $article_id)->update(['visitors' => DB::raw('visitors - 1')]);

Laravel Eloquent have awesome helper function to increment and decrement a column value.

Hope this code and post will helped you for implement How to increment or decrement a column value in Laravel?. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs

For More Info See :: laravel And github

Leave a Comment

Your email address will not be published. Required fields are marked *

  +  33  =  34

We're accepting well-written guest posts and this is a great opportunity to collaborate : Contact US