I am doing a signup form with an INSERT SQL query using PDO. After this INSERT, I want to extract the userid (auto incrementing, primary key) that was just created, and INSERT it into another table (a "confirmation code" table)
但我如何確保此用戶 ID 不是第二個用戶的用戶 ID，該用戶 ID 比第一個用戶晚 1/1000 秒注冊?
But how can I make sure that this userid is not that of a second user who registered 1/1000th of a second later that the first user?
我應該找到某種方法來鎖定桌子嗎?我應該使用事務嗎?
Should I find some way of locking the table? Should I use transactions?
lastInsertId() returns the identifier of the last row inserted on that connection, so concurrent users (with different connections to the database) will not interfere.
