CODEWITHSUNDEEP
phpmysqlcakephp
Shashikala
Shashikala

Reputation: 457

How to get last inserted Row in 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

Upvotes: 1

Views: 815

Answers (1)

Parixit
Parixit

Reputation: 3855

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!

Upvotes: 4

Related Questions