Incrementing DB values

I was finally able to get around to the use case where I needed to do this and here is what worked for me.

PHP Code:

$this->set('field', 'field + ' . $this->db->escape($amount]), false)
    ->where('id', $someId)
    ->update(); 


The key here is that you have to use the set method and not pass the data into the update function. This allows you to use the third parameter to specify that you don't want it to escape the values. This does mean, however, that you have to escape any variable yourself as shown in this example.

I found this in the documentation at https://www.codeigniter.com/user_guide/d...ating-data under the information on the $builder->set() method.