Update query increment field plus 1 codeigniter

Question

I got a problem when trying to increment by 1 on given field in my db. I tried with and without active records.

My functions look like this (in my model)

function _set_reads($id){
$this->db->set('reads', 'reads+1', FALSE)
$this->db->where('id', $id);
$this->db->update('article');
}

and

function _set_reads($id){
$sql = 'update article set reads=reads+1 where id=?';
$this->db->query($sql, array($id));
}

I get the same error in both cases and it's the following error message:

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reads+1 WHERE `id` = '15'' at line 1

UPDATE `article` SET `reads` = reads+1 WHERE `id` = '15'

I am using the latest version of MAMP

score 13 · Answer 1 · answered Nov 25 '13 at 00:40

13

-- Need small correction

$this->db->where('id', $id);
$this->db->set('set_row', '`set_row`+ 1', FALSE);

Thank You

answered Nov 25 '13 at 00:40

syyu

409
7
10

score 7 · Answer 2 · answered Oct 15 '12 at 23:06

7

Solved it: I had to change

$this->db->set('reads', 'reads+1', FALSE)

to

$this->db->set('reads', '`reads+1`', FALSE)

Sorry for the post...

answered Oct 15 '12 at 23:06

user1724347

253
1
2
13

why to prevent the value from being escaped ? – Istiaque Ahmed Feb 02 '14 at 15:26
6

```$this->db->set('reads', '`reads+1`', FALSE)``` must be ```$this->db->set('reads', '`reads`+1', FALSE)``` – vee Apr 08 '14 at 19:35
How can i do it with `update_batch()` multiple records have different value to increment? – Jitendra Solanki Oct 03 '17 at 07:54
1

@Jitendra did you ever get a solution to your question? – owsata Mar 21 '20 at 21:45
@owsata, i am really sorry. i don't remember now that. Ofcourse i did some solution for that but i don't remember as of now. – Jitendra Solanki Apr 03 '20 at 05:49

score 3 · Answer 3 · answered Oct 15 '12 at 23:09

3

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

answered Oct 15 '12 at 23:09

Wahyu Kristianto

8,719
6
43
68

Update query increment field plus 1 codeigniter

3 Answers3

Linked

Related