Home > Article > Backend Development > Sample code for php activation and verification using email after registration
By using the email verification activation method, you can effectively prevent access by malicious Spam and registration robots. It is very simple to write the steps for email verification and activation after registration in php. I believe you can learn it in a few minutes.
A total of two pages are required, register.php and verify.php
1. User RegistrationForm register.php
The code is as follows:
<html> <body> <form action="register.php" method="post" name="register"> 用户名:<input type="text" name="username" /> 密码:<input type="password" name="password" /> 电子邮件:<input type="text" name="email" /> <input type="submit" value="注册" /> </form> </body> </html>
2. Create user data form Users
The code is as follows:
CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL auto_increment, `status` varchar(20) NOT NULL, `username` varchar(20) NOT NULL, `password` varchar(20) NOT NULL, `email` varchar(20) NOT NULL, `activationkey` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`), UNIQUE KEY `email` (`email`), UNIQUE KEY `activationkey` (`activationkey`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
3. Create verification code and store user registration information in the data table
We use status' verify' to indicate a user who has not yet been activated.
The code is as follows:
$activationKey = mt_rand() . mt_rand() . mt_rand() . mt_rand() . mt_rand(); $username = mysql_real_escape_string($_POST[username]); $password = mysql_real_escape_string($_POST[password]); $email = mysql_real_escape_string($_POST[email]); $sql="INSERT INTO users (username, password, email, activationkey, status) VALUES ('$username', '$password', '$email', '$activationKey', 'verify')";
4. Send verification code
The code is as follows:
echo "An email has been sent to $_POST[email] with an activation key. Please check your mail to complete registration."; ##Send activation Email $to = $_POST[email]; $subject = " YOURWEBSITE.com Registration"; $message = "Welcome to our website!\r\rYou, or someone using your email address, has completed registration at YOURWEBSITE.com. You can complete registration by clicking the following link:\rhttp://www.YOURWEBSITE.com/verify.php?$activationKey\r\rIf this is an error, ignore this email and you will be removed from our mailing list.\r\rRegards,\ YOURWEBSITE.com Team"; $headers = 'From: noreply@ YOURWEBSITE.com' . "\r\n" . 'Reply-To: noreply@ YOURWEBSITE.com' . "\r\n" . 'X-Mailer: PHP/' . phpversion(); mail($to, $subject, $message, $headers);
5. Verify activation code verify.php
If the verification codes are the same, activate the user.
The code is as follows:
$queryString = $_SERVER['QUERY_STRING']; $query = "SELECT * FROM users"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ if ($queryString == $row["activationkey"]){ echo "Congratulations!" . $row["username"] . " is now the proud new owner of a YOURWEBSITE.com account."; $sql="UPDATE users SET activationkey = '', status='activated' WHERE (id = $row[id])"; if (!mysql_query($sql)) { die('Error: ' . mysql_error()); } // 到这里,用户已经完全激活了账号,你可以将页面跳转到登陆后的界面了 } } // end of while
The above is the detailed content of Sample code for php activation and verification using email after registration. For more information, please follow other related articles on the PHP Chinese website!