doushi2845 2018-12-24 09:23
浏览 31
已采纳

在codeigniter中更新/替换没有表单的数据

Please help how to update data in a database table without input form. I want to make the value on table become "0". I have created a controller:

function reset(){
    $data = array(
        'nomor_antrian' => '0',
        'jumlah_pengantri'  => '0'
    );

    $this->db->replace('antrian', $data);
}

The model :

function reset($id) {
        $data = array(
            'nomor_antrian'=>'0',
            'jumlah_pengantri'=>'0'
        );
        $this->db->set($data);
        $this->db->where('nomor_loket', $id);
        $this->db->update('antrian');
    }

and this is the link button in the view section :

<a href="<?php echo base_url('home/reset'); ?>">Reset</a>

Thanks before.

  • 写回答

1条回答 默认 最新

  • duanjian5059 2018-12-24 10:09
    关注

    You have to send $id to update record

    Model code

    function reset($id){
        $data = array(
            'nomor_antrian' => '0',
            'jumlah_pengantri' => '0'
        );
        $this->db->set($data);
        $this->db->where('nomor_loket', $id);
        $this->db->update('antrian');
    }
    

    Reset link will be as follow

    <a href="<?php echo base_url('home/reset/'.$id); ?>">Reset</a> //$id is a parameter 
    

    Pass parameter to reset() function

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?