ZF2 + Zend\Db\Sql\Update, adding to current value

Question

I'm trying to do something relatively simple but can't figure it out.

I just want to add to a current value in the DB is there anyway to do the equivalent of a:

UPDATE `tablename` SET fieldB = fieldB + 1 WHERE fieldA='X'

Using the Zend/db update function?

Tomek Kobyliński · Accepted Answer · 2017-10-11 11:00:06Z

7

it will be something like this:

 $select = $sql->update();
 $select->table('basket');
 $select->set(['quantity' => new Expression("quantity + ? ", [$quantity])]);
 $select->where(['basket_id'=>$basket_id]);

Remember to escape/sanitize your data! (like i do with $quantity)

edited Oct 11, 2017 at 11:00

answered Jun 26, 2013 at 7:50

Tomek Kobyliński

1,30815 silver badges25 bronze badges

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

1 Comment

Juan Over a year ago

Thank you Tomek! do you by any chance know where I can find a good list of examples/documentation with regards to Zend/db queries? I find this to be somewhat lacking on the docs.

Collectives™ on Stack Overflow

ZF2 + Zend\Db\Sql\Update, adding to current value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related