dongwo6477 2016-05-13 11:24
浏览 6
已采纳

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

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

  • 写回答

1条回答 默认 最新

  • dpnof28482 2016-05-13 11:52
    关注

    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!

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?