从单个表单提交将数据插入到多个表中

Question

我有下面提到的表格。并获得以下输出。帮助我使用 foreach 循环获得如下输出。array('notification') = array('pos_id' => 'kiran','post_usr' => 'kumar','comment' => 'kaleti');array('project') = array('Project_name' => 'india','Proejct_lang' => 'hyderabad');这是控制器代码。// controllerpublic function form_submit() {   $total_data = $this->input->post();   print_r($total_data);  //output :Array ( [notification|pos_id] => kiran [notification|post_usr] => kumar [notification|comment] => kaleti [project|Project_name] => india [project|Proejct_lang] => hyderabad )  foreach ( $total_data as $key => $value ) {     $arr = explode("|",$key);     echo $arr[0]."--".$arr[1]."--".$value."<br />";   }}

Answer 1

这是控制器代码，您将从中获取数据VIEW作为您将在controller.

// Controller

$data_array1 = array(

    'table_field_name_here' => $this->input->post('pos_id'),

    'table_field_name_here' => $this->input->post('post_usr'),

    'table_field_name_here' => $this->input->post('comment'),

);

$data_array2 = array(

    'table_field_name_here' => $this->input->post('Project_name'),

    'table_field_name_here' => $this->input->post('Proejct_lang'),

);  

$table_1 = 'table_name';

$table_2 = 'table_name';

$record_id_1 = $this->Common_model->insert_into_table($table_1, $data_array1);

$record_id_2 = $this->Common_model->insert_into_table($table_2, $data_array2);

if($record_id_1 && $record_id_2){

    // success ...!

}else{

    // fail ...!    

}

model您将从控制器调用的函数。

// Model

function insert_into_table($table, $data) {

    // echo "<pre>asdf";print_r($data);exit;

    $insert = $this->db->insert($table, $data);

    $insert_id = $this->db->insert_id();

    if ($insert) {

        return $insert_id;

    } else {

        return false;

    }

}

希望您能了解使用模型将数据插入到两个表中是多么简单。