search

panique / mini

Just an extremely simple naked PHP application, useful for small projects and quick prototypes. Some might call it a micro framework :)
1.35k stars 479 forks source link

Fetch identity after insert #244

Closed vindominguez closed 6 years ago

vindominguez commented 6 years ago

How can I retrieve the auto increment id after insert?

panique commented 6 years ago

There a good logic for this case, check out this article: https://stackoverflow.com/questions/10680943/pdo-get-the-last-id-inserted

This gets the last id that has been inserted by the current PDO connnection, so even when you are inserting 1000 things in the same second, it will always get you the correct id!

vindominguez commented 6 years ago

Thanks!