duanlin1933 2014-04-10 14:50
浏览 40
已采纳

在codeigniter中,是否可以从bach插入中获取最后插入的ID?

Is there any way to get last inserted IDs from batch inserts in codeigniter ?

This might seem silly but I wonder if there is any help available.

  • 写回答

2条回答 默认 最新

  • dongqiang2358 2014-04-10 15:14
    关注

    You're gonna need to run the inserts in a loop, that's the only way to get each of the IDs. To lessen the strain on the server, you can do this inside of a transaction.

    $ids = array();
    
    $this->db->trans_start();
    
    foreach($data as $val){
        $this->db->insert('yourTable', array(
            'field1' => $val['foo'],
            'field2' => $val['bar']
        ));
    
        $ids[] = $this->db->insert_id();
    }
    
    $this->db->trans_complete();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?