I want to get the ID of a row which i just inserted. May i know how to do it

Question

Here is a code where i'm inserting some values to table row. in the next line i want the id of that row. may i know how can i get that. Below is the code.

$data = array(
'i_course_id' => $post_data['course_id'],
'i_cousem_id' => $crs_semister,
'i_event' => $post_data['event'],
'i_event_year' => $year,
'i_stu_crs_random_id' => $studentData['random_id'],
'i_no_scan' => 1
);
$this->db->insert('i_stud_crs', $data);

It's hard to tell which database abstraction/tooling layer you are using here? — Progrock, Aug 23 '16 at 11:05

score 2 · Answer 1 · answered Aug 23 '16 at 11:10

2

You should get last inserted id with $this->db->insert_id() just after the $this->db->insert('i_stud_crs', $data);

answered Aug 23 '16 at 11:10

ignasi

443
4
8

score 2 · Answer 2 · answered Aug 23 '16 at 11:13

2

You can get the last inserted id as:

    $this->db->insert('i_stud_crs', $data);
    $insert_id = $this->db->insert_id();

$insert_id holds the last inserted id.

answered Aug 23 '16 at 11:13

niriza

21
7

score 1 · Answer 3 · answered Aug 23 '16 at 11:13

Use below code

$data = array(
    'i_course_id' => $post_data['course_id'],
    'i_cousem_id' => $crs_semister,
    'i_event' => $post_data['event'],
    'i_event_year' => $year,
    'i_stu_crs_random_id' => $studentData['random_id'],
    'i_no_scan' => 1
    );
    $this->db->insert('i_stud_crs', $data);
    $id = $this->db->insert_id();

I want to get the ID of a row which i just inserted. May i know how to do it

3 Answers3