如何在Codeigniter中更新多个值

本文介绍了如何在Codeigniter中更新多个值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我输入的数据将填充不同的值，我进行了多次更新

I have input data that I will fill with different values, I do multiple updates

但是我有一个错误，即:

but I have an error which is:

字段列表"中的未知列数组" UPDATE service SET charge_order = WHERE数组 id_service ='1'

Unknown column 'Array' in 'field list' UPDATE service SET charges_order = WHERE array id_service = '1'

如何克服这个问题?

示例img

查看

<?php $no = 1; foreach ($invoice as $m) { ?> <tbody id="tbody"> <form class="form-signin" method="post" action="<?php echo base_url();?>backend/report/update/<?php echo $m->id_service; ?>"> <tr class="deleted"> <td><input type="text" class="form-control" name="charges_order[]" value="<?php echo $m->charges_order;?>"></td> </tr> </form> </tbody> <div class="box-footer"> <button type="submit" class="btn bg-blue btns-flat margin">Simpan</button> </div> <?php } ?>

控制器

public function update($id_service) { foreach ($this->input->post('charges_order') as $data) { $data = array( 'charges_order' => $this->input->post('charges_order') ); // echo '<pre>', print_r($data); $this->M_report->update($id_service, $data); redirect('backend/report'); } }

型号

public function update($id_service, $data) { $this->db->where('id_service', $id_service); $this->db->update('service', $data); }

推荐答案

将您的控制器更改为此-

Change your controller to this-

public function update($id_service){ $charges_order = json_encode($this->input->post('charges_order')); $data = array( 'charges_order' => $charges_order ); $this->M_report->update($id_service, $data); redirect('backend/report'); }

这应该为您工作.