doushizhou4477 2018-06-18 07:39
浏览 46
已采纳

Codeigniter中的多插入

I want to make multiple insert in my database table with a FK, but only enter one line of records, it could be I do not count the $count. Here my code

Model

public function create($table,$data)
    {
    $query = $this->db->insert($table, $data);
     return $this->db->insert_id();
    }

Controller

public function save($id)
    {
    $id_form = $id;
    $id_interversion = $this->model->create('mytable1',$data);
        $Inicio = $_POST['Inicio'];
        $Termino = $_POST['Termino'];
        $id_tecnico = $_POST['id_tecnico'];
        $count = count($_POST['id_tecnico']);
        $data2 =array();
                for ($i=0; $i <$count; $i++) {
                    $data2 = array(
                             'id_tecnico'=>$id_tecnico[$i],
                             'horaInicio'=>$Inicio[$i],
                             'Termino'=>$Termino[$i]
                     );
                 $this->model->create('mytable2',$data2);

                }


}

view

<?php echo form_open("controller/save/{$data->id}"); ?>
      <?php for ($i=0; $i <2; $i++) { ?>
        <input type="text" name="id_tecnico[]"  value="" class="form-control">
        <input type="text" name="Inicio[]"  value="" class="form-control">
        <input type="text" name="Termino[]"  value="" class="form-control">
       <?php } ?>

       <?php echo form_close(); ?>

I hope I explained well greetings

展开全部

  • 写回答

2条回答 默认 最新

  • duanlu6114 2018-06-18 09:36
    关注

    Try with insert_batch like this :

    public function save($id = NULL)
    {
        $id_form = $id;
        //$id_interversion = $this->model->create('mytable1',$data);
        $id_interversion = 12; // a custom id
        $Inicio = $this->input->post('Inicio');
        $Termino = $this->input->post('Termino');
        $id_tecnico = $this->input->post('id_tecnico');
        foreach ($id_tecnico as $key => $item) 
        {
            $insert_data[] = array(
                    'id_interversion' => $id_interversion,
                    'id_tecnico'=> $item,
                    'horaInicio'=> $Inicio[$key],
                    'Termino'=> $Termino[$key]
                  );
        }
        //print_r($insert_data);die;
        $this->db->insert_batch('mytable2',$insert_data);
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)
编辑
预览

报告相同问题?

悬赏问题

  • ¥15 PADS Logic 原理图
  • ¥15 PADS Logic 图标
  • ¥15 电脑和power bi环境都是英文如何将日期层次结构转换成英文
  • ¥20 气象站点数据求取中~
  • ¥15 如何获取APP内弹出的网址链接
  • ¥15 wifi 图标不见了 不知道怎么办 上不了网 变成小地球了