How to get auto generated id after insertion?

Question

I inserted records in database with auto generated id, now i want to get that id when i click on submit button that brings me multi file upload page

[this link](https://stackoverflow.com/questions/16440366/how-to-get-last-insert-id-after-insert-query-in-codeigniter-active-record) — danish-khan-I, Aug 02 '19 at 05:38

score 0 · Answer 1 · answered Aug 02 '19 at 05:38

0

Try this

function add_post($post_data){
   $this->db->insert('posts', $post_data);
   $insert_id = $this->db->insert_id();

   return  $insert_id;
}

In case of multiple inserts you could use

$this->db->trans_start();
$this->db->trans_complete();

answered Aug 02 '19 at 05:38

Serghei Leonenco

use `$assignment_id=$this->db->insert_id();` not `$this->db->assignment_id();` – Devsi Odedra Aug 02 '19 at 05:45
I want to pass that id on other page using redirect, is that possible? – Happy Christian Aug 02 '19 at 05:53
Sure, just insert this ‘id’ like a parameter – Serghei Leonenco Aug 02 '19 at 05:55
But better way to use session variables, if you work just in web development – Serghei Leonenco Aug 02 '19 at 05:56
did it like this: `redirect('Welcome/file_upload/assignment_id='.$res);` $res contains that auto generated id – Happy Christian Aug 02 '19 at 05:57
I can not tell you for sure, post you controller, where you you call the method, and check the way how you making a redirection complying to codeignitor pattern – Serghei Leonenco Aug 02 '19 at 06:00

score 0 · Answer 2 · answered Aug 02 '19 at 05:39

0

$conn->insert_id

will give you last insert id w3schools

answered Aug 02 '19 at 05:39

vicky

score 0 · Answer 3 · answered Aug 02 '19 at 05:43

0

$this->db->insert_id();

This will give you last inserted id after inserting record.

answered Aug 02 '19 at 05:43

Abhijit

3 Answers3