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 akyazı escort arifiye escort erenler escort eve gelen escort ferizli escort geyve escort hendek escort otele gelen escort sapanca escort söğütlü escort taraklı escort
sakarya escort sakarya escort sakarya escort sakarya escort sakarya escort sakarya escort sakarya escort serdivan escort sapanca escort karasu escort hendek escort ankara escort
sakarya escort kızlar sakarya escort kaliteli sakarya escort vip sakarya escort elit sakarya escort bayan sakarya escort adresleri.