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

Question

I am trying to do something relatively simple, but I can’t understand.

I just want to add to the current value in the database, one way or another, to make the equivalent:

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

Using the Zend / db update function?

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 avoid / misinform the data! (for example, I do with $ quantity)