PHP+jQuery 注册模块开发详解(9)

<?php 
session_start();
header('Content-type:text/html;charset=utf-8');
include_once 'conn/conn.php';

$table = "user";

if(!empty($_GET['name']) && !is_null($_GET['name'])){
          
  //urlencode会对字符串进行转义。所以这里要进行处理
  if(get_magic_quotes_gpc()){
  
    $getname = stripslashes(urldecode($_GET['name']));
  }else{
  
    $getname = urldecode($_GET['name']);
  }

  //urldecode反转url中的中文编码
  $sql = "select * from ".$table." where uname='".$getname."' and activekey='".$_GET['k']."'";

  $num = $conne->getRowsNum($sql);
  if($num>0){
    
    $rs = $conne->getRowsRst($sql);  

    //此时数据库里的字符串是不会带反斜杠的  
    //因此要为下面的SQL语句加上反斜杠
    $rsname = addslashes($rs['uname']);

    $upnum = $conne->uidRst("update ".$table." set active = 1 where uname = '".$rsname."' and activekey = '".$rs['activekey']."'");

    if($upnum>0){
      
      $_SESSION['name'] = urldecode($getname);
      echo "<script>alert('您已成功激活');window.location.href='main.php';</script>";
    }else{
      
      echo "<script>alert('您已经激活过了');window.location.href='main.php';</script>";
    }
  }else{
    
    echo "<script>alert('激活失败');window.location.href='templets/register.html';</script>";
  }
}

?>

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