php mysql检测用户名_PHP代码实现检测用户名

/*获得提交数据*/$username1=$_POST['username'];$password=$_POST['password'];$repassword=$_POST['repassword'];IF{。。。没错}else{$conn=mysql_connect($mysql_server_name,$mys...

/* 获得提交数据 */

$username1 = $_POST['username'];

$password = $_POST['password'];

$repassword = $_POST['repassword'];

IF{。。。没错}

else {

$conn=mysql_connect($mysql_server_name, $mysql_username, $mysql_password);

if(!$conn){

echo("数据库连接出错");

exit();

}

else {

mysql_select_db($mysql_dbname,$conn);

//mysql_query("set names gb2312");

//从表中提取信息的sql语句

//$strsql="select * from player where userName='$username'";

// 执行sql查询

//$result=mysql_query($strsql, $conn);

$sql_search=mysql_query("select * from player where username = '$username1'");

$info=mysql_fetch_array($sql_search);

//$rows=mysql_fetch_row($result);

//if(!$result){

//echo("100,database selection error");

// }

//}

$username2 = $info['username'];

//else if($rows[0]=$username.$rows[1]){

if($username2 == $username1){

echo "

echo 'alert("用户名被占用");javascript:history.go(-1);';

echo "";

}

else {

// $strsql="INSERT INTO player(userName, password) VALUES('$userName','$password')";

// mysql_query($strsql, $conn);

$username1=rawurlencode(base64_encode($username1));

$password=rawurlencode(base64_encode($password));

$url ='server.php?username='.$username1.'&psw='.$password.'';

header("Location: $url");

}

}

}

展开