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

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 ge开发者_运维知识库tting 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?

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.

Use only this syntax

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

return $last_id; 

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.

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

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()'];

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

// 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;

try this:

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

instead of

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

Try this

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

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';

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

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;