MySQL update query in CodeIgniter using where in [duplicate]

Question

I have to update my table data where id in (1,2,3,4,5).

How can I implement this query in CodeIgniter?
What I have tried:

$id_list = '1,2,3,4,5';
$this->db->where_in('id', $id_list);
$this->db->update('my_table', $mydata);

But it's not working.

Maybe check the manual? codeigniter.com/userguide3/database/query_builder.html — jeroen
– jeroen, Commented Apr 16, 2018 at 12:20

B. Desai · Accepted Answer · 2018-04-16 12:22:26Z

2

in where_in, you have to pass array. currently you are passing string. change your code as below:

$id_list = '1,2,3,4,5';
$id_list = explode(",",$id_list);
$this->db->where_in('id', $id_list);
$this->db->update('my_table', $mydata);

answered Apr 16, 2018 at 12:22

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

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

Comments

Pradeep · Accepted Answer · 2018-04-16 12:23:12Z

2

$id_list should be an array() to work with where_in

Here is the code :

$id_list = array(1,2,3,4,5);
$this->db->where_in('id', $id_list);
$this->db->update('my_table', $mydata);

answered Apr 16, 2018 at 12:23

Pradeep

9,70713 gold badges29 silver badges34 bronze badges