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?

Bunsen

Answer 1

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)

Hardy

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. – Bunsen