How to generate a unique alpha numeric login id using PHP and MYSQL

Question

I am new to PHP. I am working on a project of Government Recruitment System. In that I want to provide system generated candidate login id to registerd candidates. I want to generate the unique alpha numeric id like cdt1001 , cdt1002 , cdt1003..... so on. Somebody please help me to do that. Thanks in advance.

Set your `id` in db to `auto-increment` and prefix it with `cdt` — Thamilhan, May 31 '16 at 05:10
visit the below link http://stackoverflow.com/questions/1846202/php-how-to-generate-a-random-unique-alphanumeric-string — Reji kumar, May 31 '16 at 05:12

score 1 · Accepted Answer · answered May 31 '16 at 05:26

If you want id's like cdt1001,cdt1002,cdt1003 then simply set id as cdt default and set the id field as primary key and set to auto increment.

or else if you want to generate random alphanumeric id's then u can use this : Rand function in php :

md5(uniqid(rand(), true))

How to generate a unique alpha numeric login id using PHP and MYSQL

1 Answers1