getLastInsertId() in Cakephp

Question

Hi, In my controller

     function designpage() 
    {
       //to create a form Untitled
 $this->Form->saveField('name','Untitled Form');
     echo $this->Form->getLastInsertId();//here it works

    }

        function insertformname()
      { 

          echo $this->Form->getLastInsertId(); //this doesnt echo at all



      }

Please suggest me..

Answer 1

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->Form->id to get the value that you want.

Answer 2

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/class/model

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?

Answer 3

thanks for this tag "getLastInsertId();" i was looking for it :)

use it in this way:

$this->Form->save($this->data);

echo $this->Form->getLastInsertId(); //this will echo saved row id man

Answer 4

Is there any way to get the last insert id without doing a save/update? Model->id is null...

Answer 5

$this->Model->field('id', null, 'id DESC')

Answer 6

use just,

$this->id;

Answer 7

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.