Array to String Conversion Error In Codeigniter for multiple update

Question

morning, I would like to multiple update data to data base using explode expression

here my controller :

 $id                 = explode(' ',$this->post('id'));
 $respond            = $this->model->update($id,$data);

my model :

 public function update($id=null,$data=null)
    {
        $this->db->where('id', $id);
        $this->db->update($this->table, $data);
        return true;        
    }

@DilipSolanki i hope you solf my problem again , stackoverflow.com/questions/49727259/… — Gusti Erlangga
– Gusti Erlangga, Commented Apr 9, 2018 at 7:10

Dilip Solanki · Accepted Answer · 2018-04-09 04:58:44Z

0

When your ID get multple data that time try this...

public function update($id=null,$data=null)
{
  for($i=0;$i<count($id);$i++) {
    $this->db->where('id', $id[$i]);
    $this->db->update($this->table, $data);
  }
    return true;        
}

answered Apr 9, 2018 at 4:58

Dilip Solanki

4373 silver badges13 bronze badges

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

1 Comment

Alex Over a year ago

I would like to add, that if it imperative that all the data makes it in or none at all - you should use/wrap this in a transaction.

Collectives™ on Stack Overflow

Array to String Conversion Error In Codeigniter for multiple update

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related