What is the equivalent to getLastInsertId in Cakephp

Question

If I do getLastInsertId   immediately after a save    it works  but otherwise it does not  This is demonstrated in my controller   function designpage           to create a form Untitled      this- gt Form- gt saveField  name   Untitled Form        echo  this- gt Form- gt getLastInsertId      here it works    function insertformname         echo  this- gt Form- gt getLastInsertId      this doesnt echo at all     Please suggest a way to get the functionality I want

User · Answer

Try using this code in your model class (perhaps in AppModel):

function get_sql_insert_id() {
   $db =& ConnectionManager::getDataSource($this->useDbConfig);
   return $db->lastInsertId();
}

Caveat emptor: MySql's LAST_INSERT_ID() function only works on tables with an AUTO_INCREMENT field (otherwise it only returns 0). If your primary key does not have the AUTO_INCREMENT attribute, that might be the cause of your problems.

User · Answer

In Cake  the last insert id is automatically saved in the id property of the model  So if you just inserted a user via the User model  the last insert id could be accessed via  User- id     id - Value of the primary key ID of   the record that this model is   currently pointing to  Automatically   set after database insertions    Read more about model properties in the  CakePHP API Docs  http   api cakephp org 2 5 class-AppModel html  Edit  I just realized that Model  getLastInsertID   is essentially the same thing as Model- id  After looking at your code more closely  it s hard to tell exactly what you re doing with the different functions and where they exist in the grand scheme of things  This may actually be more of a scope issue  Are you trying to access the last insert id in two different requests    Can you explain the flow of your application and how it relates to your problem

User · Answer

CakePHP has two methods for getting the last inserted id  Model  getLastInsertID   and Model  getInsertID    Actually these methods are identical so it really doesn t matter which method you use   echo  this- gt ModelName- gt getInsertID    echo  this- gt ModelName- gt getLastInsertID      This methods can be found in cake libs model model php on line 2768

User · Answer

I think it works with getLastInsertId   if you use InnoDB Tables in your MySQL Database  You also can use  this- gt Model- gt id

User · Answer

this is best way to find out last inserted id    this- gt ModelName- gt getInsertID      other way is using   this- gt ModelName- gt find  first  array  order   gt  id DESC

User · Answer

Try to use this code  try to set it to a variable so you can use it in other functions       variable    this- gt ModelName- gt getLastInsertId      in PHP native  try this    variable   mysqli insert id

User · Answer

Below are the options   echo  this- gt Registration- gt id   echo  this- gt Registration- gt getInsertID     echo  this- gt Registration- gt getLastInsertId      Here  you can replace Registration with your model name   Thanks

User · Answer

this- gt Model- gt field  id   null   id DESC

User · Answer

You can get last inseted id with many ways Like Model name is User so best way to fetch the last inserted id is    this- gt User- gt id     For User Model   You can also use Model function but below code will return last inserted id of model with given model name for this example it will return User model data   this- gt User- gt getLastInsertId     this- gt User- gt getInsertID

User · Answer

This will return last inserted id of last loaded model   this- gt id    This will return last inserted id of model with given model name    this- gt Model- gt id    This will return last inserted id of the model current model  CakePHP has two methods for getting the last inserted id   Model  getLastInsertID   and Model  getInsertID     echo  this- gt ModelName- gt getInsertID    echo  this- gt ModelName- gt getLastInsertID

User · Answer

In CakePHP you can get it by  Model  getInsertID     Returns the ID of the last record this model inserted  Model  getLastInsertID     Alias to getInsertID

User · Answer

each time you perform an insert operation on any model  cake internally fetchesthe last insert Id and Sets to Model- id attribute   so one can access it directly by  Model- id   no need to query again for lastInsertId

User · Answer

Just use    this- gt Model- gt id

User · Answer

After insertion of data  we can use following code to get recently added record s id        last insert id  this- gt Model- gt id

User · Answer

Use this one  function designpage       to create a form Untitled  this- gt Form- gt saveField  name   Untitled Form    echo  this- gt Form- gt id    here it works

User · Answer

You ll need to do an insert  or update  I believe  in order for getLastInsertId   to return a value   Could you paste more code   If you re calling that function from another controller function  you might also be able to use  this- gt Form- gt id to get the value that you want

User · Answer

This is interesting  I also stumbled upon this issue  What you asked perhaps how to get the last ID of a certain model regardless of it s state  whether it s just been inserted or not  To further understand what getInsertID does  we need to take a look at the source   Link 1  http   api20 cakephp org view source model line-3375  public function getInsertID       return  this- gt  insertID     Yup  that s the only piece of code inside that function  It means that cakephp caches any last inserted ID  instead of retrieve it from the database  That s why you get nothing if you use that function when you haven t done any record creation on the model   I made a small function to get the last ID of a certain table  but please note that this should not be used as a replacement of getLastID   or getLastInsertID    since it has an entirely different purpose   Add the function lastID   to the AppModel as shown below so that it can be used system wide  It has it s limit  which can t be used on model with composite primary key    class AppModel extends Model     public function lastID          data    this- gt find  first          array           order    gt  array  this- gt primaryKey     DESC             fields    gt  array  this- gt primaryKey                      return  data  this- gt name   this- gt primaryKey           Original Source   Class Model

User · Answer

When you use save    the last insert ID is set to the model   s  id property  So   if   this- gt Model- gt save          printf  Last insert ID was  s    this- gt Model- gt id

User · Answer

There are several methods to get last inserted primary key id while using save method   this- gt loadModel  Model     this- gt Model- gt save  this- gt data     This will return last inserted id of the model current model   this- gt Model- gt getLastInsertId     this- gt Model- gt  getInsertID      This will return last inserted id of model with given model name   this- gt Model- gt id    This will return last inserted id of last loaded model   this- gt id

User · Answer

Actually you are using the getLastInsertId or getInsertId in a wrong manner  getLastInsertId   is meant to work only after save   method  It will even not work after a manual insert  as cake engine is storing the mysql insert id under  this-  insertID inside the save method which can be retrieved via the getLastInsertId or getInsertId  Now in your case    this- gt Model- gt id   OR   this- gt Model- gt find  first  array  order   gt  id DESC       Will do

User · Answer

Machinedispatch        this- gt Machinedispatch- gt find  first  array  order   gt array  Machinedispatch id DESC        Simplest way of finding last inserted row  For me getLastInsertId   this not works

User · Answer

Each time a save method is called on a model  cake internally calls Model  getLastInsertId   and stores the result into model class attribute id  so after calling save   it is not necessary to call Model  getLastInsertId   or inserId    as tha value can be directly accessed like this   id    this- gt id    within a model  id    this- gt   this- gt modelName - gt id    in a controller

[cakephp] What is the equivalent to getLastInsertId() in Cakephp?

Examples related to cakephp