Get the last insert id

Question

Hello I am using cakePHP 1.3 and I am unable to retreive the last inserted row's id. I actually am using $this->Model->id to retreive the last inserted id but I am unable to get the id. When tried to check what is return type, it says as bool(false), which means nothing is returned.

Here I am loading a different model in a different controller, so would that be the issue?? But even though I am loading, I get back nothing!!

$this->loadModel('Contact');
$this->Contact->query("insert into contacts(tblContact_firstName,tblContact_lastName,tblContact_company,tblContact_department,tblContact_address,tblContact_country,tblContact_city,tblContact_state,tblContact_zipcode,tblContact_phone1,tblContact_email1) values('$sanitizedFormData[fname]','$sanitizedFormData[lname]','','$sanitizedFormData[company]','$sanitizedFormData[address]','$sanitizedFormData[country]','$sanitizedFormData[city]','$sanitizedFormData[state]','$sanitizedFormData[zip]','$sanitizedFormData[phone]','$sanitizedFormData[email]');");

$this->loadModel('Contact');
$contactId = $this->Contact->id;

And when I printed the $this->Contact array recursively, I found the value of "id" key empty. So that explains why I was receiving an empty value.

Now given my situation, how would I get the last inserted id, specific to the controller Contact?

Answer 1

I think you just want to do:

$this->getLastInsertID();

http://book.cakephp.org/2.0/en/models/additional-methods-and-properties.html#model-getlastinsertid