如何以特定格式为每个新用户分配唯一ID？ [关闭]

Question

I have a form and I can add new users to the admin panel and I would like to generate unique id for each of them with this format H00001 , H00002, H00003 , and so on.

Answer 1

It just my try . i don't know how far it work and logic is correct or not . experts please correct me if anything wrong

Create the table with auto increment

create table idgenerater(id int not null autoincrement,
                         insert_date datetime default timestamp
                         ); 

Each new user registration insert record in idgenerater and get the last inserted id and store it into your registration table using str_pad like this

str_pad is Pad to the given string to your string

    <?php

    $id='10'; //GOT ID FROM TABLE 

    $ss = str_pad($id,4,0,STR_PAD_LEFT);

    echo "H".$ss;

    ?>

output:

H0010