Laravel DB::table update record

Question

I have this query

 DB::table('product_options')
        ->where('product_id', $id)
        ->where('size', $selected_size)
        ->update(array('stock' => WHAT TO PUT HERE));

In the update part where I've put WHAT TO UPDATE, what should I put here to decrease the number by 1?

slapyo · Accepted Answer · 2014-11-21 00:11:05Z

6

Use the decrement method. http://laravel.com/docs/4.2/queries#updates

 DB::table('product_options')
        ->where('product_id', $id)
        ->where('size', $selected_size)
        ->decrement('stock');

answered Nov 21, 2014 at 0:11

slapyo

2,9911 gold badge18 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

the_unforgiven_II Over a year ago

So I dont need the update method then just decrement? @slapyo

slapyo Over a year ago

Yup, check out the link. You can pass the value you want to decrease by and you can also pass other columns to update if you need.

the_unforgiven_II Over a year ago

Yep always forgot about these little extra bits in Laravel, cheers dude

Collectives™ on Stack Overflow

Laravel DB::table update record

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related