Member Avatar for kayla_95
kayla_95

so i've been trying to do this multiple times but stil didnt get the answer. i have a column named closed in my database and close button in my view, whenever i click the button close, i want it to update my closed column to '0' if it is closed and '1' if it still open. below is my code in controller, sorry im still new to this.

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);
      }

i use codeigniter btw....thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.