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.
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
If you want to do on server side (php), you can use the library which i have created. Please check this link
https://www.phpclasses.org/package/9822-PHP-Generate-unique-identifier-strings.html