如何在Codeigniter中更新多个值 [英] how to update multiple value in 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');
}

这应该为您工作.

这篇关于如何在Codeigniter中更新多个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！