在编码器中从另一个函数向数据库插入变量值

Question

我需要一些帮助。

这是我的控制器

function result_selected_abc_data(){
$this->auth->restrict();
$this->load->model('usermodel');
$this->load->model('productmodel');
$level=$this->session->userdata('level');
$this->load->library('form_validation');
$this->form_validation->set_rules('date1','Tanggal  Di Masukkan','trim|required');
$this->form_validation->set_rules('date2','Tanggal Belum Di Masukkan','trim|required');
$this->form_validation->set_error_delimiters('<span style="color:#FF0000;">','</span>');
if($this->form_validation->run() == false){
$data['parent']=$this->usermodel->get_data_parent_menu($level);
$data['first_child'] = $this->usermodel->get_data_first_child_menu($level);
$data['second_child'] = $this->usermodel->get_data_second_child_menu($level);
$data['third_child'] = $this->usermodel->get_data_third_child_menu($level);
$data['fourth_child'] = $this->usermodel->get_data_fourth_child_menu($level);
$data['fifth_child'] = $this->usermodel->get_data_fifth_child_menu($level);
$data['sixth_child'] = $this->usermodel->get_data_sixth_child_menu($level);
$data['seventh_child'] = $this->usermodel->get_data_seventh_child_menu($level);
$this->template->display('ABC_select_date',$data);
}else{
$data['selected_date']= array(
          'date1' => $this->input->post('date1'),
          'date2' => $this->input->post('date2')
          );
$date1=$this->input->post('date1');
$date2=$this->input->post('date2');
$data['ABC_report_result']= $this->productmodel->get_ABC_data_based_on_date($date1,$date2);
$this->template->display('ABC_select_data_result',$data);
    }
}

我想在另一个函数中插入$data['ABC_report_result']值到数据库中，比如save abc():

function save_abc(){
 **what should I make in here so I can get $data['ABC_report_result'] value and save it to database?**
}

我该怎么做?谢谢你的帮助。

Answer 1

在你的控制器

function save_abc(){
$ArrData = array(
     'database_column'=>'value',
     'database_column2'=>'value2',
);
$this->your_model->your_function($ArrData);
}

在你的模型

public function your_function($data=''){
        $this->db->insert('your_table',$data);
    }

<<p> 更新解决方案/strong>你可以做一件事在你的视图文件中保存$date值在隐藏字段并创建一个按钮保存数据调用动作save_abc()现在你可以做

function save_abc(){
   $this->load->model('productmodel');
   $date1=$this->input->post('date1'); //data from hidden field
   $date2=$this->input->post('date2'); //data from hidden field
   $result = $this->productmodel->get_ABC_data_based_on_date($date1,$date2);
  $this->your_model->your_save_function($result);
}

Answer 2

在CodeIgniter你的输入对象是全局可访问的!因此，如果您需要您的save_abc中的数据，为什么您不尝试在您的目标函数中插入您的input->post()方法?

Answer 3

try this:

function result_selected_abc_data()
{
    $this->auth->restrict();
    $this->load->model('usermodel');
    $this->load->model('productmodel');
    $level=$this->session->userdata('level');
    $this->load->library('form_validation');
    $this->form_validation->set_rules('date1','Tanggal  Di Masukkan','trim|required');
    $this->form_validation->set_rules('date2','Tanggal Belum Di Masukkan','trim|required');
    $this->form_validation->set_error_delimiters('<span style="color:#FF0000;">','</span>');
    if($this->form_validation->run() == false){
        $data['parent']=$this->usermodel->get_data_parent_menu($level);
        $data['first_child'] = $this->usermodel->get_data_first_child_menu($level);
        $data['second_child'] = $this->usermodel->get_data_second_child_menu($level);
        $data['third_child'] = $this->usermodel->get_data_third_child_menu($level);
        $data['fourth_child'] = $this->usermodel->get_data_fourth_child_menu($level);
        $data['fifth_child'] = $this->usermodel->get_data_fifth_child_menu($level);
        $data['sixth_child'] = $this->usermodel->get_data_sixth_child_menu($level);
        $data['seventh_child'] = $this->usermodel->get_data_seventh_child_menu($level);
        $this->template->display('ABC_select_date',$data);
    }
    else
    {
        $data['selected_date']= array(
                  'date1' => $this->input->post('date1'),
                  'date2' => $this->input->post('date2')
                  );
        $date1=$this->input->post('date1');
        $date2=$this->input->post('date2');
        $data['ABC_report_result']= $this->productmodel->get_ABC_data_based_on_date($date1,$date2);
        $this->productmodel->save_abc_data($data['ABC_report_result']);
        $this->template->display('ABC_select_data_result',$data);
    }
}