php手动增加会员号码

Question

i've got hundreds of people joining my website and create an membership id for them. i just created a new column in the database called user_no.

• whats the mysql query for incrementing the membership no.
• is it possible to start with AE then numbers ie: AE0001, AE0002, .... and it starts with 4 number not AE1, AE2..

mysql query:

UPDATE user SET user_no=..??

and on PHP side, how do i increment it? if there is a new member join in.

$db->query("INSERT INTO user (user_no) VALUES(AE'$user_no')");

Answer 1

Why not use an autoincrement field and append AE to it? Autoincrement will be carried out by MySQL so you don't have to worry about it in PHP : http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html

And to display your user key in the format of AE0001 you can do

$id = 'AE' . str_pad($autoincrementid, 5, "0", STR_PAD_LEFT);

http://php.net/manual/en/function.str-pad.php