last generate id manual query in cakephp

Question

I have apply manual query in cakephp and not get last generate id

My query is this

$areas = $this->Area->query("insert into  areas (Area_ID,Parent_Area_ID,Area) values ('','".$Parent_Area_ID."','".$Area_name."')");

How i get last id ?

I'm smelling SQL injection vulnerabilities... ps, please always mention your exact CakePHP version! — ndm, Aug 04 '14 at 13:10
Why are you not using a model as wrapper for this? This would make it so much cleaner and easier to work with... — mark, Aug 04 '14 at 14:06
It seems highly likely that `Area_ID` is the primary key - in which case you're using query for no benefit and at the cost of exposing yourself to SQL injection and losing Cake's default ORM functions - why aren't you calling save on a model? If you're using CakePHP, _use_ CakePHP. — AD7six, Aug 04 '14 at 14:57

score 0 · Answer 1 · edited May 23 '17 at 12:04

0

Try this

echo $this->Area->getLastInsertID();

If this doesn't work check out this answer from a similar question

edited May 23 '17 at 12:04

Community

answered Aug 04 '14 at 11:26

Pooshonk

score 0 · Accepted Answer · edited Aug 05 '14 at 05:00

0

Try this code:

$this->Area->getInsertID();

edited Aug 05 '14 at 05:00

joe

answered Aug 05 '14 at 04:41

Indrajeet Singh

2 Answers2