PHP+jQuery 注册模块开发

/*
******* 环境: Apache2.2.8 + PHP5.2.6 + MySQL5.0.51b + jQuery-1.8.3.min.js *******
******* 其他组件：Zend_mail( Zend_framework 1.11.11 )
******* Date：2014-09-25
******* Author：小dee
******* Blog：http://www.cnblogs.com/dee0912/
*/

1 <?php
2 //php.ini开启了php_mbstring.dll扩展
3 $str="博客园小dee";
4  
5 echo (strlen($str)+mb_strlen($str,'utf-8'))/2;

1 <!-- 用户名 -->        
2 <div class="ipt fipt">
3     <input type="text" name="uname" id="uname" value="" placeholder="输入用户名"  autocomplete="off" />
4     <!--提示文字-->
5     <span id="unamechk"></span>
6 </div>

 1 $(function(){
 2     
 3     //说明文字
 4     function notice(showMsg,noticeMsg){            
 5         showMsg.html(noticeMsg).attr("class","notice");
 6     }
 7     //显示错误信息
 8     function error(showMsg,errorMsg){    
 9         showMsg.html(errorMsg).attr("class","error");
10     }    
11     //显示正确信息
12     function success(showMsg,successMsg){    
13         showMsg.html(successMsg)                
14                        .css("height","20px")
15                        .attr("class","success");
16     }
17 
18     //计算字符长度
19     function countLen(value){
20     
21         var len = 0; 
22         for (var i = 0; i < value.length; i++) { 
23             if (value[i].match(/[^\x00-\xff]/ig) != null) 
24             len += 2; 
25             else 
26             len += 1; 
27         } 
28         return len;
29     }                     
30 
31     //......
32 )};

 1 //检测用户名长度
 2 function unameLen(value){
 3     
 4         var showMsg = $("#unamechk");
 5 
 6         /* (strlen($str)+mb_strlen($str))/2 可得出限制字符长度的上限,
 7         *  例如:$str为7个汉字:"博客园记录生活",利用上面的语句可得出14,
 8         *  同样,14个英文,利用上面的语句同样能得出字符长度为14
 9         */
10         if(countLen(value) > 14){
11                         
12             var errorMsg = '用户名长度不能超过14个英文或7个汉字';
13             error(showMsg,errorMsg);        
14         }else if(countLen(value) == 0){
15         
16             var noticeMsg = '用户名不能为空';
17             notice(showMsg,noticeMsg);
18         }else{
19 
20             var successMsg = '长度符合要求';
21             success(showMsg,successMsg);
22         }
23 
24         return countLen(value);
25     }
26 
27     //用户名
28     unameLen($("#uname").val());
29     
30     $("#uname").focus(function(){
31     
32                     var noticeMsg = '中英文均可，最长为14个英文或7个汉字';
33                     notice($("#unamechk"),noticeMsg);
34                 })
35                .click(function(){
36                     
37                     var noticeMsg = '中英文均可，最长为14个英文或7个汉字';
38                     notice($("#unamechk"),noticeMsg);
39                 })
40                .keyup(function(){
41     
42                     unameLen(this.value);
43                 }).keydown(function(){
44                 
45                     //把焦点移至邮箱栏目
46                     if(event.keyCode == 13){
47                         
48                         $("#uemail").focus();
49                     }
50                 })
51                 .blur(function(){
52                 
53                     if($("#uname").val()!="" && unameLen(this.value)<=14 && unameLen(this.value)>0){
54                         //检测中
55                         $("#unamechk").html("检测中...").attr("class","loading");
56                         //ajax查询用户名是否被注册
57                         $.post("./../chkname.php",{
58                         
59                             //要传递的数据
60                             uname : $("#uname").val()
61                         },function(data,textStatus){
62                             
63                             if(data == 0){
64                             
65                                 var successMsg = '恭喜，该用户名可以注册';
66                                 $("#unamechk").html(successMsg).attr("class","success");
67 
68                                 //设置参数
69                                 nameval = true;
70                             }else if(data == 1){
71                             
72                                 var errorMsg = '该用户名已被注册';
73                                 error($("#unamechk"),errorMsg);
74                             }else{
75                             
76                                 var errorMsg = '查询出错,请联系网站管理员';
77                                 error($("#unamechk"),errorMsg);
78                             }
79                         });
80                     }else if(unameLen(this.value)>14){
81                     
82                         var errorMsg = '用户名长度不能超过14个英文或7个汉字';
83                         error($("#unamechk"),errorMsg);
84                     }else{
85                     
86                         var errorMsg = '用户名不能为空';
87                         error($("#unamechk"),errorMsg);
88                     }
89 });
90 
91 //加载后即获得焦点
92 $("#uname").focus();

 1 <?php
 2 
 3     header("charset=utf-8");
 4 
 5     require_once("conn/conn.php");
 6 
 7     if(isset($_POST['uname']) && $_POST['uname']!=""){
 8     
 9         $uname = trim(addslashes($_POST['uname']));
10     }
11 
12     $sql = "select uname from user where uname='".$uname."'";
13     
14     if($conne->getRowsNum($sql) == 1){
15     
16         $state = 1;
17     }else if($conne->getRowsNum($sql) == 0){
18     
19         $state = 0;
20     }else{
21 
22         echo $conne->msg_error();
23     }
24 
25     echo $state;

1 <!-- email -->            
2 <div class="ipt">
3     <input type="text" name="uemail" id="uemail" value="" placeholder="常用邮箱地址" />
4     <span id="uemailchk"></span>
5     <ul class="autoul"></ul>
6 </div>    

//邮箱下拉js单独引用emailup.js
$("#uemail").focus(function(){
    
                    var noticeMsg = '用来登陆网站，接收到激活邮件才能完成注册';
                    notice($("#uemailchk"),noticeMsg);
                })
                .click(function(){
    
                    var noticeMsg = '用来登陆网站，接收到激活邮件才能完成注册';
                    notice($("#uemailchk"),noticeMsg);
                })
                .blur(function(){
                
                    if(this.value!="" && this.value.match(/^[\w-]+(\.[\w-]+)*@[\w-]+(\.[\w-]+)+$/)!=null){
                    
                        //检测是否被注册
                        $("#uemailchk").html("检测中...").attr("class","loading");
                        //ajax查询用户名是否被注册
                        $.post("./../chkemail.php",{
                        
                            //要传递的数据
                            uemail : $("#uemail").val()
                        },function(data,textStatus){
                            
                            if(data == 0){
                            
                                var successMsg = '恭喜，该邮箱可以注册';
                                $("#uemailchk").html(successMsg).attr("class","success");

                                emailval = true;
                            }else if(data == 1){
                            
                                var errorMsg = '该邮箱已被注册';
                                error($("#uemailchk"),errorMsg);
                            }else{
                            
                                var errorMsg = '查询出错,请联系网站管理员';
                                error($("#uemailchk"),errorMsg);
                            }
                        });
                    }else if(this.value == ""){
                    
                        var errorMsg = '邮箱不能为空';
                        error($("#uemailchk"),errorMsg);
                    }else{
                    
                        var errorMsg = '请填写正确的邮箱地址';
                        $("#uemailchk").html(errorMsg).attr("class","error");
                    }
});

1 <div class="ipt">
2     <input type="password" name="upwd" id="upwd" value="" placeholder="设置密码" />
3     <div class="upwdpic">
4        <span id="upwdchk"></span>
5        <img id="pictie" />
6     </div>
7 </div>

  1 function noticeEasy(){
  2     
  3         //密码全部为相同字符或者为123456,用于keyup时的notice
  4         var noticeMsg = '密码太简单，请尝试数字、字母和下划线的组合';
  5         return notice($("#upwdchk"),noticeMsg);
  6     }
  7 
  8     function errorEasy(){
  9     
 10         //密码全部为相同字符或者为123456,用于blur时的error
 11         var errorMsg = '密码太简单，请尝试数字、字母和下划线的组合';
 12         return error($("#upwdchk"),errorMsg);
 13     }
 14     
 15     //检测密码长度函数
 16     //检测密码长度
 17     function upwdLen(value,func){
 18     
 19         var showMsg = $("#upwdchk");
 20 
 21         if(countLen(value) > 16){
 22                         
 23             var errorMsg = '密码不能超过16个字符';
 24             error(showMsg,errorMsg);
 25             
 26             $("#pictie").hide();
 27         }else if(countLen(value) < 6){
 28         
 29             //使用notice更加友好
 30             var noticeMsg = '密码不能少于6个字符';
 31             notice(showMsg,noticeMsg);
 32 
 33             $("#pictie").hide();
 34         }else if(countLen(value) == 0){
 35         
 36             //使用notice更加友好
 37             var noticeMsg = '密码不能为空';
 38             notice(showMsg,noticeMsg);
 39 
 40             $("#pictie").hide();
 41         }else{
 42         
 43             upwdStrong(value,func);//如果长度不成问题,则调用检测密码强弱
 44         }
 45 
 46         return countLen(value);//返回字符长度
 47     }
 48 
 49     //检测密码强弱
 50     function upwdStrong(value,func){
 51     
 52         var showMsg = $("#upwdchk");
 53 
 54         if(value.match(/^(.)\1*$/)!=null || value.match(/^123456$/)){
 55         
 56             //密码全部为相同字符或者为123456，调用函数noticeEasy或errorEasy
 57             func;
 58         }else if(value.match(/^[A-Za-z]+$/)!=null || value.match(/^\d+$/)!=null || value.match(/^[^A-Za-z0-9]+$/)!=null){
 59 
 60             //全部为相同类型的字符为弱
 61             var successMsg = '弱：试试字母、数字、符号混搭';
 62             success(showMsg,successMsg);
 63 
 64             //插入强弱条
 65             $("#pictie").show().attr("src","images/weak.jpg");
 66 
 67             pwdval = true;
 68 
 69         }else if(value.match(/^[^A-Za-z]+$/)!=null || value.match(/^[^0-9]+$/)!=null || value.match(/^[a-zA-Z0-9]+$/)!=null){
 70         
 71             //任意两种不同类型字符组合为中强( 数字+符号,字母+符号,数字+字母 )
 72             var successMsg = '中强：试试字母、数字、符号混搭';
 73             success(showMsg,successMsg);
 74 
 75             $("#pictie").show().attr("src","images/normal.jpg");
 76 
 77             pwdval = true;
 78         }else{
 79         
 80             //数字、字母和符号混合
 81             var successMsg = '强：请牢记您的密码';
 82             success(showMsg,successMsg);
 83 
 84             $("#pictie").show().attr("src","images/strong.jpg");
 85 
 86             pwdval = true;
 87         }
 88     }
 89     
 90     $upper = $("<div id=\"upper\">大写锁定已打开</div>");
 91     
 92     $("#upwd").focus(function(){
 93     
 94                     var noticeMsg = '6到16个字符，区分大小写';
 95                     notice($("#upwdchk"),noticeMsg);
 96 
 97                     $("#pictie").hide();
 98             })
 99              .click(function(){
100             
101                     var noticeMsg = '6到16个字符，区分大小写';
102                     notice($("#upwdchk"),noticeMsg);
103 
104                     $("#pictie").hide();
105             }).keydown(function(){
106             
107                     //把焦点移至邮箱栏目
108                     if(event.keyCode == 13){
109                         
110                         $("#rupwd").focus();
111                     }
112             })
113              .keyup(function(){
114              
115                     //判断大写是否开启
116                     //输入密码的长度
117                     var len = this.value.length;                    
118                     if(len!=0){
119 
120                         //当输入的最新以为含有大写字母时说明开启了大写锁定
121                         if(this.value[len-1].match(/[A-Z]/)!=null){
122                         
123                             //给出提示
124                             $upper.insertAfter($(".upwdpic"));
125                         }else{
126                         
127                             //移除提示
128                             $upper.remove();
129                         }
130                     }else{
131                     
132                         //当密码框为空时移除提示
133                         if($upper){
134                         
135                             $upper.remove();
136                         }
137                     }//判断大写开启结束
138             
139                     //判断长度及强弱
140                     upwdLen(this.value,noticeEasy());    
141              })
142              //keyup事件结束
143                .blur(function(){
144                
145                     upwdLen(this.value,errorEasy());
146                     //upwdLen函数中部分提示使用notice是为了keyup事件中不出现红色提示,而blur事件中则需使用error标红
147                     if(this.value == ""){
148                     
149                         var errorMsg = '密码不能为空';
150                         error($("#upwdchk"),errorMsg);
151 
152                         $("#pictie").hide();
153                     }else if(countLen(this.value)<6){
154                     
155                         var errorMsg = '密码不能少于6个字符';
156                         error($("#upwdchk"),errorMsg);
157 
158                         $("#pictie").hide();
159                     }
160 });

<div class="ipt">
    <input type="password" name="rupwd" id="rupwd" value="" placeholder="确认密码" />
    <span id="rupwdchk"></span>
</div>

 1 $("#rupwd").focus(function(){
 2     
 3                     var noticeMsg = '再次输入你设置的密码';
 4                     notice($("#rupwdchk"),noticeMsg);
 5             })
 6                .click(function(){
 7             
 8                     var noticeMsg = '再次输入你设置的密码';
 9                     notice($("#rupwdchk"),noticeMsg);
10             }).keydown(function(){
11             
12                     //把焦点移至邮箱栏目
13                     if(event.keyCode == 13){
14                         
15                         $("#yzm").focus();
16                     }
17             })
18                 .blur(function(){
19             
20                     if(this.value == $("#upwd").val() && this.value!=""){
21                     
22                         success($("#rupwdchk"),"");
23 
24                         rpwdval = true;
25                     }else if(this.value == ""){
26                     
27                         $("#rupwdchk").html("");
28                     }else{
29                     
30                         var errorMsg = '两次输入的密码不一致';
31                         error($("#rupwdchk"),errorMsg);
32                     }
33 });

1 <div class="ipt iptend">
2     <input type='text' id='yzm' name='yzm' placeholder="验证码">
3     <img id='yzmpic' src='' style="cursor:pointer"> <!-- 验证码图片 -->
4     <a style="cursor:pointer" id='changea'>
5         <img id="refpic" src="images/ref.jpg" alt="验证码"> <!-- 验证码刷新按钮图片 -->
6     </a>
7     <span id='yzmchk'></span>
8     <input type='hidden' id='yzmHiddenNum' name='yzmHiddenNum' value=''> <!-- 隐藏域，内容是验证码输出的数字，用户输入的字符与其进行对比 -->
9 </div>

  1 //验证码按钮
  2 $("#refpic").hover(function(){
  3         
  4             $(this).attr("src","images/refhover.jpg");
  5         },function(){
  6         
  7             $(this).attr("src","images/ref.jpg");
  8         }).mousedown(function(){
  9         
 10             $(this).attr("src","images/refclick.jpg");
 11         }).mouseup(function(){
 12         
 13             $(this).attr("src","images/ref.jpg");
 14         });
 15         
 16         //生成验证码函数
 17         function showval() {
 18 
 19             num = '';
 20             for (i = 0; i < 4; i++) {
 21 
 22                 tmp = Math.ceil(Math.random() * 15);//Math.ceil上取整；Math.random取0-1之间的随机数
 23                 if (tmp > 9) {
 24                     switch (tmp) {
 25                         case(10):
 26                             num += 'a';
 27                             break;
 28                         case(11):
 29                             num += 'b';
 30                             break;
 31                         case(12):
 32                             num += 'c';
 33                             break;
 34                         case(13):
 35                             num += 'd';
 36                             break;
 37                         case(14):
 38                             num += 'e';
 39                             break;
 40                         case(15):
 41                             num += 'f';
 42                             break;
 43                     }
 44                 } else {
 45                     num += tmp;
 46                 }
 47 
 48                 $('#yzmpic').attr("src","../valcode.php?num="+num);
 49             }
 50             $('#yzmHiddenNum').val(num);
 51         }
 52 
 53         //生成验证码以及刷新验证码
 54         showval();
 55         $('#yzmpic').click(function(){
 56         
 57             showval();
 58         });
 59         $('#changea').click(function(){
 60         
 61             showval();
 62         });
 63 
 64         //验证码检验
 65         function yzmchk(){
 66         
 67             if($("#yzm").val() == ""){
 68             
 69                 var errorMsg = '验证码不能为空';
 70                 error($("#yzmchk"),errorMsg);
 71             }else if($("#yzm").val().toLowerCase()!=$("#yzmHiddenNum").val()){
 72             
 73                 //不区分大小写
 74                 var errorMsg = '请输入正确的验证码';
 75                 error($("#yzmchk"),errorMsg);
 76             }else{
 77             
 78                 success($("#yzmchk"),"");
 79 
 80                 yzmval = true;
 81             }
 82         }
 83 
 84         //验证码的blur事件
 85         $("#yzm").focus(function(){
 86         
 87             var noticeMsg = '不区分大小写';
 88             notice($("#yzmchk"),noticeMsg);
 89         }).click(function(){
 90         
 91             var noticeMsg = '不区分大小写';
 92             notice($("yzmdchk"),noticeMsg);
 93         }).keydown(function(){
 94             
 95             //提交
 96             if(event.keyCode == 13){                
 97                 
 98                 //先检验后提交
 99                 yzmchk();
100                 formsub();
101             }
102         }).blur(function(){
103         
104             yzmchk();
105 });

 1 <?php 
 2 
 3     header("content-type:image/png");
 4     $num = $_GET['num'];
 5     $imagewidth = 150;
 6     $imageheight = 54;
 7     
 8     //创建图像
 9     $numimage = imagecreate($imagewidth, $imageheight);
10     
11     //为图像分配颜色
12     imagecolorallocate($numimage, 240,240,240); 
13 
14     //字体大小
15     $font_size = 33;
16     
17     //字体名称
18     $fontname = 'arial.ttf';
19     
20     //循环生成图片文字
21     for($i = 0;$i<strlen($num);$i++){
22         
23         //获取文字左上角x坐标
24         $x = mt_rand(20,20) + $imagewidth*$i/5;
25         
26         //获取文字左上角y坐标
27         $y = mt_rand(40, $imageheight);
28         
29         //为文字分配颜色
30         $color = imagecolorallocate($numimage, mt_rand(0,150),  mt_rand(0,150),  mt_rand(0,150));
31         
32         //写入文字
33         imagettftext($numimage,$font_size,0,$x,$y,$color,$fontname,$num[$i]);
34     }
35     
36     //生成干扰码
37     for($i = 0;$i<2200;$i++){
38         $randcolor = imagecolorallocate($numimage, rand(200,255), rand(200,255), rand(200,255));
39         imagesetpixel($numimage, rand()%180, rand()%90, $randcolor);
40     }
41     
42     //输出图片
43     imagepng($numimage);
44     imagedestroy($numimage);
45 ?>

<span class="fuwu">
        <input type="checkbox" name="agree" id="agree" checked="checked">
        <label for="agree">我同意  <a href="#">" 服务条款  "</a> 和  <a href="#">" 网络游戏用户隐私权保护和个人信息利用政策 "</a>
        </label>
</span>

 1 if($("#agree").prop("checked") == true){
 2     
 3         fuwuval = true;
 4     }
 5 
 6 $("#agree").click(function(){
 7     
 8         if($("#agree").prop("checked") == true){
 9 
10             fuwuval = true;
11             $("#sub").css("background","#69b3f2");
12         }else{
13         
14             $("#sub").css({"background":"#f2f2f2","cursor":"default"});
15         }    
16 });

<button type="button" id="sub">立即注册</button>

var nameval,emailval,pwdval,rpwdval,yzmval,fuwuval = 0;

 1 function formsub(){
 2     
 3         if(nameval != true || emailval!=true || pwdval!=true || rpwdval!=true || yzmval!=true || fuwuval!=true){
 4         
 5             //当邮箱有下拉菜单时点击提交按钮时不会自动收回菜单，因为下面的return false，所以在return false之前判断下拉菜单是否弹出
 6             if(nameval != true && $("#unamechk").val()!=""){
 7             
 8                 var errorMsg = '请输入用户名';
 9                 error($("#namechk"),errorMsg);
10             }
11 
12             if($(".autoul").show()){
13             
14                 $(".autoul").hide();
15             }
16 
17             //以下是不会自动获得焦点的栏目如果为空时，点击注册按钮给出错误提示
18             if($("#uemail").val() == ""){
19             
20                 var errorMsg = '邮箱不能为空';
21                 error($("#uemailchk"),errorMsg);        
22             }
23 
24             if($("#upwd").val() == ""){
25             
26                 var errorMsg = '密码不能为空';
27                 error($("#upwdchk"),errorMsg);        
28             }
29 
30             if($("#rupwd").val() == ""){
31             
32                 var errorMsg = '请再次输入你的密码';
33                 error($("#rupwdchk"),errorMsg);        
34             }
35 
36             if($("#yzm").val() == ""){
37             
38                 var errorMsg = '验证码不能为空';
39                 error($("#yzmchk"),errorMsg);        
40             }
41 
42         }else{
43         
44             $("#register-form").submit();
45         }
46     }
47 
48     $("#sub").click(function(){
49         
50         formsub();
51 });

 1 <?php 
 2 
 3     include_once 'conn/conn.php';
 4     include_once 'Zend/Mail/Transport/Smtp.php';
 5     include_once 'Zend/Mail.php';
 6     
 7     //激活key,生成的随机数
 8     $key = md5(rand());
 9     
10     //先写入数据库，再发邮件
11     //写入数据库
12     //判断是否开启magic_quotes_gpc
13     if(get_magic_quotes_gpc()){
14     
15         $postuname = $_POST['uname'];
16         $postupwd = $_POST['upwd'];
17         $postuemail = $_POST['uemail'];
18     }else{
19         
20         $postuname = addslashes($_POST['uname']);
21         $postupwd = addslashes($_POST['upwd']);
22         $postuemail = addslashes($_POST['uemail']);
23     }
24 
25     function check_input($value){
26     
27         // 如果不是数字则加引号
28         if (!is_numeric($value)){
29         
30             $value = mysql_real_escape_string($value);
31         }
32         return $value;
33     }
34     
35     $postuname = check_input($postuname);
36     $postupwd = check_input($postupwd);
37     $postuemail = check_input($postuemail);
38 
39     $sql = "insert into user(uname,upwd,uemail,activekey)values('".trim($postuname)."','".md5(trim($postupwd))."','".trim($postuemail)."','".$key."')";
40 
41     $num = $conne->uidRst($sql);
42     if($num == 1){
43         
44         //插入成功时发送邮件
45         //用户激活链接
46         $url = 'http://'.$_SERVER['HTTP_HOST'].'/php/myLogin/activation.php';
47         //urlencode函数转换url中的中文编码
48         //带反斜杠
49         $url.= '?name='.urlencode(trim($postuname)).'&k='.$key;
50         //定义登录使用的邮箱
51         $envelope = 'dee1566@126.com';
52         
53         //激活邮件的主题和正文
54         $subject = '激活您的帐号';
55         $mailbody = '注册成功，<a href="'.$url.'" target="_blank">请点击此处激活帐号</a>';
56         
57         //发送邮件
58         //SMTP验证参数
59         $config = array(
60                 
61                 'auth'=>'login',
62                 'port' => 25,
63                 'username'=>'dee1566@126.com',
64                 'password'=>'你的密码'
65                 );
66         
67         //实例化验证的对象,使用gmail smtp服务器
68         $transport = new Zend_Mail_Transport_Smtp('smtp.126.com',$config);
69         $mail = new Zend_Mail('utf-8');
70         
71         $mail->addTo($_POST['uemail'],'获取用户注册激活链接');
72         $mail->setFrom($envelope,'发件人');
73         $mail->setSubject($subject);
74         $mail->setBodyHtml($mailbody);
75         $mail->send($transport);
76 
77         echo "<script>self.location=\"templets/register_back.html\";</script>";
78 
79     }else{
80     
81         echo "<script>self.location=\"templets/register_back.html?error=1\";</script>";
82     }
83 ?>

 1 <?php 
 2 session_start();
 3 header('Content-type:text/html;charset=utf-8');
 4 include_once 'conn/conn.php';
 5 
 6 $table = "user";
 7 
 8 if(!empty($_GET['name']) && !is_null($_GET['name'])){
 9                     
10     //urlencode会对字符串进行转义。所以这里要进行处理
11     if(get_magic_quotes_gpc()){
12     
13         $getname = stripslashes(urldecode($_GET['name']));
14     }else{
15     
16         $getname = urldecode($_GET['name']);
17     }
18 
19     //urldecode反转url中的中文编码
20     $sql = "select * from ".$table." where uname='".$getname."' and activekey='".$_GET['k']."'";
21 
22     $num = $conne->getRowsNum($sql);
23     if($num>0){
24         
25         $rs = $conne->getRowsRst($sql);    
26 
27         //此时数据库里的字符串是不会带反斜杠的    
28         //因此要为下面的SQL语句加上反斜杠
29         $rsname = addslashes($rs['uname']);
30 
31         $upnum = $conne->uidRst("update ".$table." set active = 1 where uname = '".$rsname."' and activekey = '".$rs['activekey']."'");
32 
33         if($upnum>0){
34             
35             $_SESSION['name'] = urldecode($getname);
36             echo "<script>alert('您已成功激活');window.location.href='main.php';</script>";
37         }else{
38             
39             echo "<script>alert('您已经激活过了');window.location.href='main.php';</script>";
40         }
41     }else{
42         
43         echo "<script>alert('激活失败');window.location.href='templets/register.html';</script>";
44     }
45 }
46 
47 ?>

1 create table user (id int primary key auto_increment,
2 uname varchar(14) not null default '',
3 upwd char(32) not null default '',
4 uemail varchar(50) not null default '',
5 active tinyint(4) default '0',
6 activekey char(32) not null defalut '')engine=innodb default charset=utf8