update multiple records in codeigniter

Question

I am working on a CodeIgniter project where i have to change the status of record. Actually I have to update only those records whose id are/is in the ids sting.

Currently, only one record is updated with my code. My model function is:

public function markUnRead() {
    $ids = 1,2,3,4,5,6;
    $update = array('status' => 0);
    $this->db->where_in('id', $ids);
    $this->db->update('tableName',$update);

    if ($this->db->affected_rows() > 0) {
        return true;
    } else {
        return false;
    }
}

Someone help me please.

Hashem Qolami · Accepted Answer · 2013-09-06 09:23:36Z

3

The second parameter of where_in() method should be an array:

$this->db->where_in('id', array(1,2,3,4,5,6));

By any reason, if the $ids is an string like "1,2,3,4,5,6", you could get it to work by:

$ids = explode(',', $ids);
$this->db->where_in('id', $ids);

answered Sep 6, 2013 at 9:23

Hashem Qolami

99.8k27 gold badges157 silver badges165 bronze badges

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

3 Comments

user2702406 Over a year ago

I made the second parameter array but still got the same result. only one record is updated.

user2702406 Over a year ago

yes brother it works now , thank you very much, actually my changes were not correct. You answer is absolutely right. thanks once again.

always-a-learner Over a year ago

I have the same problem and I have applied the same solution which you suggest here but I could not update multiple values, only single values get updated. What to do in this conditions? @HashemQolami

Collectives™ on Stack Overflow

update multiple records in codeigniter

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related