问：我已经尝试过多次，但是仍然没有得到答案。我在数据库中有一个名为close的列，在视图中有一个close按钮，每当我单击关闭按钮时，我希望它将已关闭的列更新为“ 0”（如果已关闭）和“ 1”（如果它仍处于打开状态）。以下是我在控制器中的代码，对不起，我对此仍然陌生。
Public function close(){
$pvar = array();
$pid = $this->uri->segment(1, 0);
$iid = $this->uri->segment(2, 0);
$pageisx = $this->uri->segment(3, 0);
$pagei = 'Purchase Order';
$iuser = $this->users->chkadmin();
$gpost = $this->input->post(NULL, TRUE);
$pvar['pageimenu'] = 'purchasing';
$pvar['htitle'] = 'Purchase: '.$iid;
$this->db->select('*');
$this->db->from('po');
$this->db->where('po.pono', $iid);
$this->db->order_by('po.pono', 'DESC');
$pvar['purchaseorder'] = $this->db->get()->row_array();
if (isset($gpost['close']))
{
if (isset($gpost['locode'])) {
$getlo = $gpost['locode'];
if ($getlo == $this->session->skey) {
foreach ($gpost['close'] as $k => $x) {
$close = 1;
$c['closed'] = $close;
//$close = $this->input->post('1');
$this->db->set('closed', 1 );
$this->db->where('po.id', $k);
$this->db->update('po');
}
redirect(base_url().'purchaseorderlist.php');
}}}
$pvar['css'] = '
<link href="'.base_url().'css/manage.css" rel="stylesheet" type="text/css" />
';
$pvar['pc'] = $this->load->view('purchasing/purchaseorderview', $pvar, TRUE);
$this->load->view('home', $pvar);
}
答：您可以发布您的PO表结构以更好地理解您的上述代码。
