Codeigniter 2.1 - returns identifiers after insertion

Here is an effective method:

Since your records have result identifiers, I'm going to assume that they also automatically increase the number.

If so, you do it and still use insert_batch.

Here is what you do:

1. You take the number of elements that you insert:

$count = count($data);

2. Run the batch insert:

$this->db->insert_batch($table, $data);

3 . Get the first inserted batch id:

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

4. Add a counter (minus 1) to your insert ID to get the last record ID.

$last_id = $first_id + ($count-1);

! , , .

:

, , ; InnoDB , , .

insert_batch () returns only the first identifier of your batch. use the insert () function for the loop to get all identifiers.

public function insert_slike($id, $slike, $folder, $polje, $tabela)
{
    $slike = explode(',', $slike);
    $data = array();
    $ids = array();
    foreach ($slike as $slk) {
        $this->img_upload_resize($slk, $folder);
        $data = array(
             $polje => $id,
             'path' => $slk
             );
        $this->db->insert($tabela, $data);
        $ids[]=$this->db->insert_id();
    }
}