如何在cakephp中获取最后一个插入行

Question

I am using postgress database and tables are of form m_table1,t_table2 ect., Here i want to get last inserted row.

When i search i got getLastInsertID() or fetch id in desc order solutions. I tried echo $this->ModelName->getInsertID(); and echo $this->ModelName->getLastInsertID(); alsoWhich doesnot works for me.

Because my problem is am not using id as primary key.I am using some code as primary key which is not a number.it will be random text like 'sscd','hhbb'. So i cant even use desc order solution.Is there any other solutions?

I am using cakephp 2.5.1

Answer 1

As you are not using id as primary key. So you must be generating your unique text code before inserting in DB.

So you should use directly that instead of calling getInsertID() / getLastInsertID() .

Hope this helps!