[solved] Get last inserted id of table in prestashop

[sabexel2]

I am using prestashop v1.4, in some custom development i need the last inserted id of the table, how could i get it

 

as simple in php we use

 

mysql_insert_id();

 

how to use it in prestashop?

[vekia]

Exactly the same, open class / module .php libraries where you want to get the last inserted id and use this command - don't forget to create own mysql connection - it may be necessary.

 

If you don't want to create new connection, the other way is to override Db class, create new function which will return the last inserted ID

[PascalVG]

Hi sabexel2,

Not sure if I understand the question, but in Prestashop all objects will get their 'ID" after being saved into the database. As you manipulate the tables through the objects, Isn't it possible to just check the object ID you are working on? If I totally misunderstood, please elaborate a little.

 

Pascal

[sabexel2]

Helllo prestashop fanatic, could you please write the complete code, as my insetertion table is 'ts_mobiles'

[vekia]

but i must know where you exactly want to retrieve the last inserted ID, and how you insert there own rows?

[sabexel2]

$abd = Db::getInstance()->autoExecute(_DB_PREFIX_.'mobiles', array(

 

'id' => '',

'email' => pSQL($email),

'number'=> pSQL($mobile),

'ip_registration_newsletter'=> pSQL($ip)

 

), 'INSERT');

 

here is my insertion code, now i want the inserted id in the table, which i want to use in the next table, for insertion....

[sabexel2]

$abd = Db::getInstance()->autoExecute(_DB_PREFIX_.'mobiles', array(

 

'id' => '',

'email' => pSQL($email),

'number'=> pSQL($mobile),

'ip_registration_newsletter'=> pSQL($ip)

 

), 'INSERT');

 

here is my insertion code, now i want the inserted id in the table, which i want to use in the next table, for insertion....

[sabexel2]

Answer is

 

Db::getInstance()->Insert_ID();

[vekia]

thanks for the information im convinced that it will be really helpfull for other developers, for me it is! :-)

 

i can go ahead and mark this thread as solved

 

regards

[hasniou]

Hello,

How to return id after use Save function of object model in PS 1.6 ?

 

thanks

[hasniou]

the answer to my question if this can help someone is :

Db::getInstance()->Insert_ID();

[LouAdrien]

Hello, I was wondering the same, how to retrieve the created id after using the add method of objectmodel? for sure after add, it is undefined in the object.

 

Using Db::getInstance()->Insert_ID(); seems un-reliable in case of multi-database usage or even concurrent database operations no?

 

[LouAdrien]

Actualy, after checking, the add method rely on  Db::getInstance()->Insert_ID(); to fill the new object id, which in my case, doesn't work. Any suggestion?

Edited May 31, 2015 by LouAdrien (see edit history)

[vekia]

try to get last entry from selected table

SELECT id FROM table ORDER BY id DESC LIMIT 1 

[LouAdrien]

Thanks for this answer, but i was looking for something that would not require another request I don't understand why it doesn't work as it seems to be a big asumption of the objectmodel code. 

 

As a remark, if done with too request, i would rather get the biggest existing ID, increment it manually and force it in the insert, to avoid any issue with concurrent operations happening ( you might get an exception, but at least you see it )

[soduno]

try to get last entry from selected table

SELECT id FROM table ORDER BY id DESC LIMIT 1 

 

Note: Be carefull with usage of last entry in a table (it can mess up). Always use insert ID (this will return the correct result all time)

Edited November 1, 2015 by soduno (see edit history)

[jave.web]

try to get last entry from selected table

SELECT id FROM table ORDER BY id DESC LIMIT 1 

NEVER, EVER DO THAT!

...to retrieve last insert ID!

If you are not locking the whole table for the whole process (which I hope you don't) and are not in complete control at the same time,

this can and often will lead to bloody collisions, and security issues!

At start, it might seem to work, but imagine shop with many users...

Data of one user could end up in other user's data and the other way around... 

 

So **please, I beg you,** never, ever do something like that... not this way...

 

If the abstract 

Db::getInstance()->Insert_ID()

is not working for you => figure out why, do not do piggy magic...