PHP邮件发送验证功能

feiyang10086

PHP邮件发送验证功能

第一步：建立数据库

把下面数据库复制粘贴在一个记事本，然后在PHPMyAdmin创建一个新的数据库并导入下面数据。

1. – 表的结构 `registered_members`
   
2. –
   
3. CREATE TABLE `registered_members` (
   
4. `id` int(4) NOT NULL auto_increment,
   
5. `name` varchar(65) NOT NULL default ”,
   
6. `email` varchar(65) NOT NULL default ”,
   
7. `password` varchar(65) NOT NULL default ”,
   
8. `country` varchar(65) NOT NULL default ”,
   
9. PRIMARY KEY  (`id`)
   
10. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    
11. 
    
12. –
    
13. – 导出表中的数据 `registered_members`
    
14. –
    
15. – ——————————————————–
    
16. –
    
17. – 表的结构 `temp_members_db`
    
18. –
    
19. 
    
20. CREATE TABLE `temp_members_db` (
    
21. `confirm_code` varchar(65) NOT NULL default ”,
    
22. `name` varchar(65) NOT NULL default ”,
    
23. `email` varchar(65) NOT NULL default ”,
    
24. `password` varchar(15) NOT NULL default ”,
    
25. `country` varchar(65) NOT NULL default ”
    
26. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

复制代码

–
– 导出表中的数据 `temp_members_db`
–

第二步：建立数据库连接

请把下面代码复制到你的文本编编译器里面，并命名：config.php

1. <?php
   
2. 
   
3. $host=”Hostname”; // Host name
   
4. $username=”Username”; // Mysql username
   
5. $password=”Password”; // Mysql password
   
6. $db_name=”DB name”; // Database name
   
7. 
   
8. //Connect to server and select database.
   
9. mysql_connect(“$host”, “$username”, “$password”)or die(“cannot connect to server”);
   
10. mysql_select_db(“$db_name”)or die(“cannot select DB”);
    
11. 
    
12. ?>

复制代码

第三步：注册页面
请把下面代码复制到你的文本编辑器里面，并命名：signup.php

1. <table border=”0″ cellspacing=”0″ cellpadding=”0″ width=”350″ align=”center”>
   
2. <tbody>
   
3. <tr>
   
4. <td><form action=”signup_ac.php” method=”post”>
   
5. <table border=”0″ cellspacing=”4″ cellpadding=”0″ width=”100%”>
   
6. <tbody>
   
7. <tr>
   
8. <td colspan=”3″><strong>注册</strong></td>
   
9. </tr>
   
10. <tr>
    
11. <td width=”76″>用户名</td>
    
12. <td width=”3″>:</td>
    
13. <td width=”305″><input id=”name” name=”name” size=”30″ type=”text” /></td>
    
14. </tr>
    
15. <tr>
    
16. <td>邮箱</td>
    
17. <td>:</td>
    
18. <td><input id=”email” name=”email” size=”30″ type=”text” /></td>
    
19. </tr>
    
20. <tr>
    
21. <td>密码</td>
    
22. <td>:</td>
    
23. <td><input id=”password” name=”password” size=”30″ type=”password” /></td>
    
24. </tr>
    
25. <tr>
    
26. <td>国家</td>
    
27. <td>:</td>
    
28. <td><input id=”country” name=”country” size=”30″ type=”text” /></td>
    
29. </tr>
    
30. <tr>
    
31. <td></td>
    
32. <td></td>
    
33. <td><input name=”Submit” type=”submit” value=”注册” />
    
34. <input name=”Reset” type=”reset” value=”重设” /></td>
    
35. </tr>
    
36. </tbody>
    
37. </table>
    
38. </form></td>
    
39. </tr>
    
40. </tbody>
    
41. </table>

复制代码

第四步：数据插入到数据和邮件发送

请把下面代码复制到你的文本编辑器里面，并命名：signup_ac.php

1. <?php
   
2. include(‘config.php’);
   
3. 
   
4. // table name
   
5. $tbl_name=temp_members_db;
   
6. 
   
7. // Random confirmation code
   
8. $confirm_code=md5(uniqid(rand()));
   
9. 
   
10. // values sent from form
    
11. $name=$_POST['name'];
    
12. $email=$_POST['email'];
    
13. $country=$_POST['country'];
    
14. 
    
15. // Insert data into database
    
16. $sql=”INSERT INTO $tbl_name(confirm_code, name, email, password, country)VALUES(‘$confirm_code’, ‘$name’, ‘$email’, ‘$password’, ‘$country’)”;
    
17. $result=mysql_query($sql);
    
18. 
    
19. // if suceesfully inserted data into database, send confirmation link to email
    
20. if($result){
    
21. 
    
22. // —————- SEND MAIL FORM —————-
    
23. 
    
24. // send e-mail to …
    
25. $to=$email;
    
26. 
    
27. // Your subject
    
28. $subject=”Your confirmation link here”;
    
29. 
    
30. // From
    
31. $header=”from: your name <your email>”;
    
32. 
    
33. // Your message
    
34. $message=”Your Comfirmation link \r\n”;
    
35. $message.=”Click on this link to activate your account \r\n”;
    
36. $message.=”http://www.yourweb.com/confirmation.php?passkey=$confirm_code”;
    
37. 
    
38. // send email
    
39. $sentmail = mail($to,$subject,$message,$header);
    
40. 
    
41. }
    
42. 
    
43. // if not found
    
44. else {
    
45. echo “Not found your email in our database”;
    
46. }
    
47. 
    
48. // if your email succesfully sent
    
49. if($sentmail){
    
50. echo “Your Confirmation link Has Been Sent To Your Email Address.”;
    
51. }
    
52. else {
    
53. echo “Cannot send Confirmation link to your e-mail address”;
    
54. }
    
55. 
    
56. ?>

复制代码

第五步：验证

请把下面代码复制到你的文本编辑器里面，并命名：confirmation.php

1. <?php
   
2. include(‘config.php’);
   
3. 
   
4. // Passkey that got from link
   
5. $passkey=$_GET['passkey'];
   
6. 
   
7. $tbl_name1=”temp_members_db”;
   
8. 
   
9. // Retrieve data from table where row that match this passkey
   
10. $sql1=”SELECT * FROM $tbl_name1 WHERE confirm_code =’$passkey’”;
    
11. $result1=mysql_query($sql1);
    
12. 
    
13. // If successfully queried
    
14. if($result1){
    
15. 
    
16. // Count how many row has this passkey
    
17. $count=mysql_num_rows($result1);
    
18. 
    
19. // if found this passkey in our database, retrieve data from table “temp_members_db”
    
20. if($count==1){
    
21. 
    
22. $rows=mysql_fetch_array($result1);
    
23. $name=$rows['name'];
    
24. $email=$rows['email'];
    
25. $password=$rows['password'];
    
26. $country=$rows['country'];
    
27. 
    
28. $tbl_name2=”registered_members”;
    
29. 
    
30. // Insert data that retrieves from “temp_members_db” into table “registered_members”
    
31. $sql2=”INSERT INTO $tbl_name2(name, email, password, country)VALUES(‘$name’, ‘$email’, ‘$password’, ‘$country’)”;
    
32. $result2=mysql_query($sql2);
    
33. }
    
34. 
    
35. // if not found passkey, display message “Wrong Confirmation code”
    
36. else {
    
37. echo “Wrong Confirmation code”;
    
38. }
    
39. 
    
40. // if successfully moved data from table”temp_members_db” to table “registered_members” displays message “Your account has been activated” and don’t forget to delete confirmation code from table “temp_members_db”
    
41. if($result2){
    
42. 
    
43. echo “Your account has been activated”;
    
44. 
    
45. // Delete information of this user from table “temp_members_db” that has this passkey
    
46. $sql3=”DELETE FROM $tbl_name1 WHERE confirm_code = ‘$passkey’”;
    
47. $result3=mysql_query($sql3);
    
48. 
    
49. }
    
50. 
    
51. }
    
52. ?>

复制代码

注意：

如果没有邮箱服务器的，会出现如下面提示之类的东西：

1. Warning: mail() [function.mail]: Failed to connect to mailserver at “localhost” port 25, verify your “SMTP” and “smtp_port” setting in php.ini or use ini_set() inE:\wamp\www\mailverification\signup_ac.php on line 39
   
2. Cannot send Confirmation link to your e-mail address

复制代码

不用慌，这说明你的数据已经被写进数据库了。

你可以用以下方法去通过验证：

先复制这个URL到你的浏览器：http://www.你的网站.com/confirmation.php?passkey=

然后到你的数据库里面把confirm_code复制粘贴在passkey=后面，并回车，会出现提示的：Your account has been activated!

恭喜你了!你的邮件验证系统就完成了！如果有什么问题的，欢迎随时留言，回以最快的速度解决你的问题。由于时间关系，英文就不做翻译了。

原文出处：http://blog.jiexi-it.com/?p=72

Asp菜菜

楼主 好强大