UPDATE rows WHERE column value is found in an array with CodeIgniter [duplicate]

Question

I need to target rows where their id is in a flat array.

For example,

$array = (1,2,67,102,178,678);

after query I need rows where id=1,id=2,id=67,id=102,id=178,id=678

and I want update records this condition

Yan Berk · Accepted Answer · 2014-02-14 18:33:09Z

1

You can use where_in:

$this->db->where_in('id', $array);

To retrieve the records use:

$this->db->get('table_name')->result();

To update the records use:

$this->db->update('table_name');

answered Feb 14, 2014 at 18:33

Yan Berk

14.5k9 gold badges58 silver badges52 bronze badges

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

1 Answer 1