DB increment method accept array/multiple columns?

DB increment method accept array/multiple columns? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: DB increment method accept array/multiple columns? (/showthread.php?tid=88768)

DB increment method accept array/multiple columns? - CIDave - 11-03-2023

I want to increment two columns in one query.
Currently:

PHP Code:
$this->db->table("my_table")->where("ID", 1)->increment("col1", 1); 

But ideally I'd like to be able to do:

PHP Code:
$this->db->table("my_table")->where("ID", 1)->increment("col1", 1)->increment("col2", 1); 

or pass an array of columns to be incremented. Increment only seems to take a string currently.
https://codeigniter.com/user_guide/database/query_builder.html?highlight=increment#CodeIgniter\Database\BaseBuilder::increment

RE: DB increment method accept array/multiple columns? - kenjis - 11-06-2023

> DB increment method accept array/multiple columns?

No.