在ci中使用复选框进行多次删除 - multiple delete with checkbox in ci

multiple delete with checkbox in ci

本文关键字：删除复选框 ci | 更新日期: 2023-09-27

我知道已经有人问过了，但是我无法解决这个问题。下面是我的控制模块

public function ahome()
{
    $this->load->model('model');
    $data['user'] = $this->model->selall('user');
    $this->load->view('ahome', $data);
    if ($this->input->post('del'))
    {
        $did = $this->input->post('chk');
        // print_r($did);
        for ($i = 0; $i < count($did); $i++)
        {
            $multi = $did[$i];
            print_r($multi);
            $this->model->delall("user", $multi);
            // redirect("control/ahome");
        }
    }
}

这是我的模型模块

 public function delall($tb,$wh)
 {
     $this->db->query("delete from $tb where uid in('$wh')");
 }

现在的问题是它只能删除单行而不能删除多行

在您的查询字符串中，尝试删除$wh变量周围的引号。

public function delall($tb,$wh)
{
  $this->db->query("delete from $tb where uid in ($wh)");
}

这应该能让它工作;但是，您应该使用CodeIgniter的查询绑定。像这样:

public function delall($tb,$wh)
{
  $this->db->query("delete from $tb where uid in (?)", array($wh));
}

试试这个，控制器,

public function ahome()
{
    $this->load->model('model');
    $data['user'] = $this->model->selall('user');
    $this->load->view('ahome', $data);
    if ($this->input->post('del'))
    {
        $did = $this->input->post('chk');
        // print_r($did);
        foreach ($did as $d_id)
        {
            $this->model->delall("user", $d_id);
            // redirect("control/ahome");
        }
    }
}

模型:

public function delall($tb,$wh)
 {
     $this->db->where('id',$wh);
     $this->db->delete($tb);
     return true;
 }