How safe is Php PDO function: lastInsertId? -


i have little confusion php pdo function: lastinsertid. if understand correctly, returns last auto-incremental id inserted in database.

i use function when execute query inserts user in database when creating functionality of registering user.

my question have hundred people registering on site @ 1 point example. , may 1 user hit 'register' button millisecond after user. there chance function lastinsertid return id of user register momentarily earlier?

may trying ask server handle 1 request @ time , go through php file 1 @ time?

please let me know this.

thank you.

perfectly safe. there no race condition. returns last inserted id pdo object made insert.


Comments

Post a Comment

Popular posts from this blog

Java sticky instances of class com.mysql.jdbc.Field aggregating -

i noticed (via jmap+jhat) app leaking storing many instances com.mysql.jdbc.field  class - double checked code make sure closing preparedstatements, find few missing didn't change outcome. - preparedstatement created , closed right away - several others created @ start , reused many times - using org.apache.tomcat.jdbc.pool.datasource connection pool what can cause type of behavior? are closing of preparedstatements / result sets using: preparedstatement stmt (possible assignment here); try { // work prepared statement resultset rs; try { while (rs.next()) ... // process results } { rs.close(); } } { stmt.close(); } so guarantee result sets closed when finished (regardless of exceptions) , statements closed (regardless of exceptions)? there other ways write that, idea same. if you're doing of properly, unless have many references it's taking inordinate amount of memory, it's ok , nothing needs done it.
Read more