Home > Article > Backend Development > Sample code for php activation and verification using email after registration

Sample code for php activation and verification using email after registration

怪我咯Original: 2017-07-07 10:24:181405browse

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 (&#39;$username&#39;, &#39;$password&#39;, &#39;$email&#39;, &#39;$activationKey&#39;, &#39;verify&#39;)";

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 = &#39;From: noreply@ YOURWEBSITE.com&#39; . "\r\n" .  
     &#39;Reply-To: noreply@ YOURWEBSITE.com&#39; . "\r\n" .  
     &#39;X-Mailer: PHP/&#39; . 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[&#39;QUERY_STRING&#39;];
 $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 = &#39;&#39;, status=&#39;activated&#39; WHERE (id = $row[id])";         
        if (!mysql_query($sql)) {
           die(&#39;Error: &#39; . 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!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：PHP example code for verifying email using regular expressionsNext article：PHP example code for verifying email using regular expressions

See more

Sample code for php activation and verification using email after registration

Related articles