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

Question

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.

Answer 1

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