PHP How to implement user mailbox registration activation code detailed

When the user registers the website, usually needs to use the user's own mailbox, the mailbox receives the website mail to carry on the account activation, then can use normally. This paper This article will show you how to use Php+mysql to complete a registered account, send an activation email, verify the activation account, and handle the URL link period. An email with a click link activation is received to activate it.

Register for Mailbox Activation process

1. User Registration
2, insert user data, the account is not activated at this time.
3, the user name password or other identification character encryption constructs the activation identification code (you can also call the activation code).
4, the structure of the activation of the identification code URL sent to the user submitted mailbox.
5, the user login to the mailbox and click on the URL, to activate.
6. Verify the activation ID and activate the account if it is correct.

Create a database table

When we register an account, we generally record our ID, username, password, email or mobile number in the user's table, and there will be a field where the account is activated or not.

User Information table field email is very important, it can be used to verify the user, retrieve the password, and even to the site can be used to collect user information for email marketing, the following is the User Information table T_user table structure:

CREATE TABLE IF not EXISTS ' t_user ' (' id ' int (one) not NULL auto_increment, ' username ' varchar (five) NOT null COMMENT ' user name ', ' Password ' varchar (+) NOT null COMMENT ' password ', ' email ' varchar (+) NOT null COMMENT ' mailbox ', ' token ' varchar (NOT NULL COM ment ' account Activation Code ', ' token_exptime ' int (ten) NOT null COMMENT ' Activation code expiration ', ' status ' tinyint (1) NOT null DEFAULT ' 0 ' COMMENT ' state, 0-Non-excited Live, 1-activated ', ' regtime ' int (ten) not NULL COMMENT ' registration time ', PRIMARY KEY (' id ')) engine=myisam DEFAULT Charset=utf8;

HTML static page

The following is a registration form that allows users to enter registration information, including user names, passwords, and mailboxes.

<form id= "Reg" action= "register.php" method= "POST" >  <p> User name: <input type= "text" class= "input" name= "Username" id= "user" ></p>  <p> Password: <input type= "password" class= "input" name= "password" id= "pass ></p>  <p>e-mail:<input type= "text" class= "input" name= "email" id= "email" ></p>  <p><input type= "Submit" class= "BTN" value= "Submit Registration" ></p></form>

register.php finish writing data and sending mail

First connect the database and include the Mail send class smtp.class.php

Include_once ("connect.php");//Connect Database include_once ("smtp.class.php");//Mail Send class

Front-end verification form we omitted, directly to see the program

$username = Stripslashes (Trim ($_post[' username ')); $query = mysql_query ("Select ID from T_user where username= ' $ Username ' "); $num = Mysql_num_rows ($query); if ($num ==1) {  echo ' username already exists, please change another username ';  Exit;}

We then encrypt the user's password to construct the activation ID:

$password = MD5 (Trim ($_post[' password ')); Encryption Password: ($_post[' email ') Mailbox $regtime = Time (), $token = MD5 ($username. $password. $regtime); Created to activate the id $token_exptime = time () +60*60*24;//expires after 24 hours $sql = "INSERT INTO ' t_user ' (' username ', ' password ', ' email ', ' Token ', ' token_exptime ', ' regtime ') VALUES (' $username ', ' $password ', ' $email ', ' $token ', ' $token _exptime ', ' $regtime ') "; mysql_query ($sql);

In the above code, the $token is a constructed activation identification code, which is composed of the user name, password and the current time and MD5 encryption. $token _exptime is used to set the expiration time of the activation link URL, the user can activate the account during this time period, this example sets the activation valid within 24 hours. Finally, insert these fields into the data table T_user.

When the data is inserted successfully, the calling mail sending class sends the activation information to the user's registered mailbox, noting that the constructed activation identifier is composed of a full URL as the activation link when the user clicks, and the following is the detailed code:

if (mysql_insert_id ()) {//write succeeded, email include_once ("smtp.class.php"); $smtpserver = "smtp.163.com"; SMTP server $smtpserverport = 25; SMTP Server Port $smtpusermail = "hjl416148489_4@163.com"; The user mailbox of the SMTP server $smtpuser = "hjl416148489_4@163.com"; The user account of the SMTP server $smtppass = "hjl7233163"; The user password for the SMTP server $SMTP = new SMTP ($smtpserver, $smtpserverport, True, $smtpuser, $smtppass);  A true in this case is that authentication is used, otherwise it is not used. $emailtype = "HTML";  Letter type, text: text; Web page: HTML $smtpemailto = $email;  $smtpemailfrom = $smtpusermail;  $emailsubject = "user account activation"; $emailbody = "Dear". $username. ":<br/> Thank you for registering a new account at my station. <br/> Please click on the link to activate your account. <br/> <a href= ' http://www.php.cn/demo/active.php?verify= '. $token. "' target= ' _blank ' >http://www.php.cn/demo/active.php?verify=". $token. "</a> <br/> if the above link is not clickable, please copy it into your browser's address bar to access it, the link is valid within 24 hours. <br/> If this activation request is not issued by you, please ignore this email.  <br/> ";  $rs = $smtp->sendmail ($smtpemailto, $smtpemailfrom, $emailsubject, $emailbody, $emailtype); if ($rs = = 1) {$msg = ' Congratulations, registration is successful! <br/> Please login to your mailbox to activate your account in time!  ';  } else {$msg = $rs; } Echo $msg;}

active.php

active.php receives the submitted link information, gets the value of the parameter verify, which is the activation identifier. Compare it with the user information in the data table, if there is a corresponding data set, determine whether it expires, if within the validity period will be the corresponding User table field status Set 1, that is activated, so that the activation function has been completed.

$email enable us to register the mailbox, we use UrlEncode () to encode, the string used in the request portion of the URL, $activation _key is the activation code we generated, we use the server to send an activation email to this email, and this in the mailbox client, will be displayed as a hyperlink, prompting you to click, click, we will send email and key to the activate.php file, that is, to start the verification and activation of the account.

Include_once ("connect.php");//Connect Database $verify = stripslashes (Trim ($_get[' verify ')); $nowtime = time (); $query = Mysql_ Query ("Select Id,token_exptime from T_user where status= ' 0 ' and ' token ' = ' $verify '"); $row = Mysql_fetch_array ($query); if ($row) {  if ($nowtime > $row [' token_exptime ']) {//24hour    $msg = ' Your activation has expired, please log in to your account to resend the activation email. ';  } else{    mysql_query ("Update t_user set Status=1 where id=". $row [' id ']);    if (Mysql_affected_rows ($link)!=1) die (0);    $msg = ' activation succeeded! ';  }} else{  $msg = ' error. ';} Echo $msg;

After the

Activation succeeds, it is useless to find the token field and you can empty it. And the status activation state becomes 1. Now the account is activated, the user at the login, first match the activation is activated, followed by the next steps.