$this->db->insert_id() not working in mysql codeigniter

Question

I am just trying to get the latest auto generated key from the mysql table from codeiginitor. But it is not working some how. I have tried this code
$this->db->insert_id()
as well as
$this->db->mysql_insert_id()
I am getting the following error
Severity: Notice Message: Undefined property: CI_DB_mysql_driver::$insert_id
is the insert_id function not supported for mysql? How can we make it work?

Does the normal [mysql_insert_id()](http://ro.php.net/manual/de/function.mysql-insert-id.php) work for you? — sqwk, Aug 04 '11 at 13:35
It would help to see where you are running the query before this. — Chris Schmitz, Aug 04 '11 at 14:11
@sqwk I am able to get Insert id on normal PHP only after installing MySQLi. I assume mysql_insert_id will work only with MySQLi. I wonder how can we make CodeIgnitor to make use of MySQLi — Ananth Duari, Aug 04 '11 at 14:50
@Chris I have run the query in mysql command line client as well as PHP program using MYSQLi. But it is not working with CodeIgnitor connection. — Ananth Duari, Aug 04 '11 at 14:51
No, let us see all your code, where you're doing the query in codeigniter and then trying to retrieve the insert ID — jondavidjohn, Aug 04 '11 at 14:55
Post your insert code, $this->db->insert_id() will only work if you are using the $this->db->insert method. Until you post your code nobody can help you! — mattumotu, Aug 05 '11 at 09:53

score 12 · Answer 1 · answered Aug 04 '11 at 14:58

12

CodeIgniter's insert_id() will only return an ID of an insert(). Unless you are executing something like $this->db->insert('table', $data); before calling the function it will not be able to return an ID.

answered Aug 04 '11 at 14:58

Chris Schmitz

8,097
6
31
41

1

I got it working with the following changes.
1. I changed the dbdriver in config.php from mysql to mysqli
2. using the following code
$this->db->mysql_insert_id(); – Ananth Duari Aug 04 '11 at 15:01
obviously the insertion id we are talking is after insert some values using insert statement. – Ananth Duari Aug 04 '11 at 15:02
You never posted the code so I wasn't sure if you were using an Active Record `insert()`. – Chris Schmitz Aug 04 '11 at 15:59

score 6 · Answer 2 · edited May 22 '15 at 05:10

6

Use only this syntax

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

return $last_id;

edited May 22 '15 at 05:10

Saty

22,443
7
33
51

answered Mar 05 '14 at 12:38

user3337174

149
1
7

score 5 · Accepted Answer · answered Aug 08 '11 at 14:25

5

This is the code I tried to insert the data and get the insert id,

$this->db->insert('table_name',$data); $id = $this->db->mysql_insert_id();

It is not working for me. I have used DB Driver as "mysql". Then I have installed "mysqli" and changed the DB driver name in database.php like,
$db['default']['dbdriver'] = 'mysqli';
Now it is working fine for me.

answered Aug 08 '11 at 14:25

Ananth Duari

2,859
11
35
42

2

$this->db->insert(table_name, $data); return $this->db->insert_id(); – SteveTz Oct 26 '16 at 23:11

korvus · Answer 4 · 2019-03-26T10:02:58.297

2

I had the same problem, and found a solution with this link: http://kedyr.wordpress.com/2012/10/03/codeigniter-insert_id/

The solution is not properly a solution, because it's just a way to get around by using the native sql, with the codeigniter method "Query" and dealing with the native sql callback.

    $this->db->insert('references', $data);
    $query = $this->db->query('SELECT LAST_INSERT_ID()');
    $row = $query->row_array();
    $LastIdInserted = $row['LAST_INSERT_ID()'];

edited Mar 26 '19 at 10:02

answered Oct 28 '14 at 15:57

korvus

334
4
5

1

In a multiuser environment, this solution is a mess! – meYnot Nov 16 '17 at 12:42

score 2 · Answer 5 · answered Nov 07 '16 at 11:56

2

Please check if your table don't have auto increment, primary field then $this->db->insert_id(); will not return anything.

answered Nov 07 '16 at 11:56

tanveer javaid

121
8

In my case this method helped me and resolved the issue. – Vignesh Chinnaiyan Oct 24 '17 at 06:25

score 1 · Answer 6 · edited Mar 20 '13 at 12:56

1

assuming you are using active record pattern this should work
$this->db->insert_id()

edited Mar 20 '13 at 12:56

Dennis Jaheruddin

21,208
8
66
122

answered Mar 20 '13 at 12:27

user1542

49
1
9

score 1 · Answer 7 · edited May 14 '15 at 12:51

1

try this:

$id = $this->db->insert_id()

instead of

$id = $this->db->mysql_insert_id();

edited May 14 '15 at 12:51

Alex

16,739
1
28
51

answered May 14 '15 at 08:44

RAJEEV

11
1

score 1 · Answer 8 · answered May 19 '18 at 05:59

1

// Store data into array
$data=array('name'=>'Rudra','email'=>'test@gmail.com');

//Insert Data Query
$this->db->insert('tableName',$data);

// Storing id into varialbe
$id = $this->db->insert_id();
return $id;

answered May 19 '18 at 05:59

Rudra

535
4
16

score 0 · Answer 9 · answered Nov 07 '16 at 12:02

0

Try this

$this->db->insert('table_name',$data);
$id = $this->db->mysql_insert_id();

answered Nov 07 '16 at 12:02

Faizan Khattak

862
8
22

score 0 · Answer 10 · answered Jan 27 '18 at 23:23

Your code will work if you have a code like this :

var $table = 'your table name'
$this->db->insert($this->table,$data1);
        return $this->db->insert_id();

CodeIgniter's insert_id() will only return an ID of an insert(), as mention before, and also you dont forget to settings the DB driver name in database.php like

$db['default']['dbdriver'] = 'mysqli';

score 0 · Answer 11 · answered Oct 03 '20 at 08:33

0

// insert data
$data=array("name"=>"vijay");
$this->db->insert("table_name",$data);
$insert_id= $this->db->insert_id();

answered Oct 03 '20 at 08:33

vijayabalan

91
1
3

3

It better to add some description in the answer – Akhilesh Mishra Oct 03 '20 at 09:13

score -2 · Answer 12 · edited May 19 '18 at 05:12

-2

If you are using ajax to insert data, then print the output you will get the id in response, or if you are using core codeigniter method then use below code.

$last_id = $this->db->insert_id();
return $last_id;

edited May 19 '18 at 05:12

Karlo Kokkak

3,674
4
18
33

answered May 19 '18 at 04:24

Amol kamble

1
1

$this->db->insert_id() not working in mysql codeigniter

12 Answers12

Linked