How to Update Database field value +1 in CodeIgniter

Use direct database Update instead of Model to increment a field +1

I always use the CodeIgniter models to do all the MySQL querys (insert, select, updates...) but this won't work if you want to update a count field +1.

Use this direct code in your Controller Function:

$this->db->set('my_field', 'my_field+1', FALSE); $this->db->where('my_other_field', 'test'); $this->db->update('my_table');
Code language: PHP (php)

Leave a Reply

Add <code> Some Code </code> by using this tags.