Codeigniter update mysql data using increment

Question

I want to add 1 to my column named SIZE (integer), this is my query:

$this->dbsections->update('sections', "SIZE = SIZE + 1");

But in the error message, it reads as:

UPDATE `sections` SET `SIZE = SIZE +` 1 = '' WHERE `NAME` = 'ABC'

I can't remember off hand, can you do $this->dbsections->update('sections', ['size' => 'size + 1']); I have a feeling this won't work and you might need to write the query in a different way, as a full query — gabe3886
– gabe3886, Commented May 12, 2016 at 13:49

Saty · Accepted Answer · 2016-05-12 13:57:44Z

3

You can rewrite your update query

$this->dbsections->set('SIZE', 'SIZE+1', FALSE);// third parameter FALSE
$this->dbsections->where('NAME', "ABC");
$this->dbsections->update('sections');

set() will also accept an optional third parameter ($escape), that will prevent data from being escaped if set to FALSE

Read https://www.codeigniter.com/userguide3/database/query_builder.html#updating-data

edited May 12, 2016 at 13:57

answered May 12, 2016 at 13:51

Saty

22.5k7 gold badges35 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

P. Kumar · Accepted Answer · 2016-05-12 13:54:42Z

2

You can try this:

$this->dbsections->query("UPDATE sections SET SIZE = SIZE + 1 WHERE NAME = 'ABC'");

answered May 12, 2016 at 13:54

P. Kumar

2071 silver badge7 bronze badges

3 Comments

gabe3886 Over a year ago

NAME is a MySQL reserved word so might need escaping. Whilst this does answer the specific question asked, if other fields needed updating also, the query string itself could get quite large and unreadable if not formatted neatly; as a result there are better ways of doing this

Saty Over a year ago

@gabe3886 NAME is keyword in mysql not reserved check there is no (R) after name!! dev.mysql.com/doc/refman/5.7/en/keywords.html

gabe3886 Over a year ago

@Saty My mistake, I misread the documentation. Thanks for pointing it out. It's probably still worth escaping the column names though, just in case that changes in a future version.

Collectives™ on Stack Overflow

Codeigniter update mysql data using increment

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related