doushizhou4477 2018-06-18 15: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 17: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 python使用pulp线性优化时报错
  • ¥15 开源或低价数据中台哪个最好
  • ¥15 arduino编程出现字符串疑似覆盖现象
  • ¥15 我的b站在没有碰到屏幕的情况下偶尔会自动跳出进度条,就像在屏幕上点了一下一样,但我并没有点。而且视频进度并没有变。这可能是什么原因造成的?
  • ¥30 STK matlab python仿真
  • ¥15 关于IMageEnView 图标定位问题
  • ¥20 求解答(matlab)
  • ¥30 ffmpeg库使用过程中遇到的问题
  • ¥15 pyqt5 中python如何通过Qtwebchannel主动发消息给web前端
  • ¥15 关于HTML中title获取xml内容的问题