function save_detail($id,$rows) //Query for saving the company details { $this->db->where('user_id', $id); $this->db->delete('sec_companyaccess'); foreach ($rows as $row) { $rdata = explode('|', $row); $data['user_id'] = $id; $data['company_id'] = $rdata[3]; $this->db->insert('sec_companyaccess', $data); } } function save($data,$item,$details) //Save user query { if ($item=='') //Add new user { $this->db->trans_start(); $data['password'] = md5($this->input->post('password')); $data['status'] = 1; $this->db->insert('sec_users', $data); $item = $this->db->insert_id(); $this->save_detail($item,$details); $this->db->trans_complete(); } else //Update/Modify user { $this->db->trans_start(); $this->db->where('user_id', $item); $this->db->update('sec_users', $data); $this->save_detail($item,$details); $this->db->trans_complete(); } return $item; }