update database value on laravel

Question

does laravel have short cut for $i++; i want to update my database value went seomething happend. on php i could just use sql like

UPDATE goods SET qty++ WHERE id = '4'

here is my controller code

public function store(Request $request)
{
      $g = new goods();
      $g->qty = ++;
      $g->save();
}

If i have stuff let say A with QTY of 10 when i do something i would be update the QTY based on what the QTY i inputed — Martin Christopher, Jan 22 '19 at 08:45

score 1 · Accepted Answer · answered Jan 22 '19 at 08:29

1

Here is the solution

$post      = Goods::find(3);
$post->qty = $post->qty + 1;
$post->save();

you can just find that record and update with +1.

answered Jan 22 '19 at 08:29

Ritul Lakhtariya

362
1
16

score 1 · Answer 2 · answered Jan 22 '19 at 08:29

1

Look at the docs: https://laravel.com/docs/5.7/queries#increment-and-decrement For example: DB::table('users')->increment('votes', 5);

answered Jan 22 '19 at 08:29

Ruub

619
1
13
41

Kiran Kanzar · Answer 3 · 2019-01-22T08:52:28.897

0

Can you try this.

public function store(Request $request) {
    $g = goods::find(4);
    $g->qty += 1;
    $g->save;
}

edited Jan 22 '19 at 08:52

answered Jan 22 '19 at 08:29

Kiran Kanzar

329
1
5
14

No I can’t... laravel think I’m going to insert new data... not update it – Martin Christopher Jan 22 '19 at 08:32
@MartinChristopher you are use `new` keyword, so laravel think you are insert new data. please remove new keyword and use this code `$g = goods::find(4);` – Kiran Kanzar Jan 22 '19 at 08:36
Please accept and upvoted my answer to helpful other people. – Kiran Kanzar Jan 22 '19 at 08:51

score 0 · Answer 4 · answered Jan 22 '19 at 08:29

0

You can't just call ++ on nothing, and doing (if it would work) would just add 1. Why not just say $g->qty = 1;? If you already have some value in qty, then call $g->qty++; and then call ->save(); on it (note the "()").

answered Jan 22 '19 at 08:29

Christian Kaal

232
3
13

update database value on laravel

4 Answers4