How to pull out the id of the last record or find out with what id the user will be created, Yii2?

Question

Yii

Good afternoon! Please tell me how to pull the last record from the database in Yii2?
There are users in which id is generated, and when creating a user, I need to already know what id he will have, since he does not upload files differently.
Here you need to pull out the last id and add a unit.
Perhaps someone will suggest a simpler solution.
I would be very grateful for your help!

Answer 1

$id = Yii::$app->db->getLastInsertID();
Returns the ID of the last inserted record

Answer 2

Something like this: But you solve the problem incorrectly.

Here you need to pull out the last id and add a unit.
Perhaps someone will suggest a simpler solution.

What if another 100,500 users register at that time?
Add a user, get his ID and only after that link any files or upload them to temporary storage.

Answer 3

Good evening.
We created a user and got an id (the easiest option):

if($model->save()){
   return $model->id;
}

Answer 4

If you need to get the record identifier before saving it to the database, then you should refuse the auto-increment of the identifier (as far as I understand it is used by you now) and do the calculation of the identifier on the application side, or first save the user and then receive it identifier.