做了一个用户注册的页面....是用PHP+mssql2005 现在有一个问题就是,就是当我在用户页无论输入 数据库中有的和没有的用户数据...提交时 都提示 '此用户名已注册,请确认!' 请高手帮忙解决
$conn=mssql_connect('127.0.0.1','sa','sa');
mssql_select_db('fangwei',$conn);
$username=$_POST["us"];
$password=$_POST["password1"];
$email=$_POST["email"];
$sex=$_POST["xb_one"];
$sfz=$_POST["sfz1"];
$shouji=$_POST["shouji"];
$mmcxwt=$_POST["select"];
$mmcxda=$_POST["mmcxda"];
$laiyuan=$yh_ly; //query语句
$Query="select * from [user] where username='".$username."'";
echo $Query;
$AdminResult=mssql_query($Query);
if($AdminResult){
$temp="<script type='text/javascript'>alert('此用户名已注册,请确认!');history.go(-1);</script>";
echo $temp;
}
else{
$sql="INSERT INTO [user](username,password,email,sex,sfz,shouji,mmcxwt,mmcxda,yhly) VALUES('$username','$password','$email',$sex,'$sfz','$shouji','$mmcxwt','$mmcxda','$yh_ly')";
echo $sql;
$AdminResult1=mssql_query($sql);
if($AdminResult1==true)
{ echo "成功";
}
else
{
echo "注册失败";
}
}
$conn=mssql_connect('127.0.0.1','sa','sa');
mssql_select_db('fangwei',$conn);
$username=$_POST["us"];
$password=$_POST["password1"];
$email=$_POST["email"];
$sex=$_POST["xb_one"];
$sfz=$_POST["sfz1"];
$shouji=$_POST["shouji"];
$mmcxwt=$_POST["select"];
$mmcxda=$_POST["mmcxda"];
$laiyuan=$yh_ly; //query语句
$Query="select * from [user] where username='".$username."'";
echo $Query;
$AdminResult=mssql_query($Query);
if($AdminResult){
$temp="<script type='text/javascript'>alert('此用户名已注册,请确认!');history.go(-1);</script>";
echo $temp;
}
else{
$sql="INSERT INTO [user](username,password,email,sex,sfz,shouji,mmcxwt,mmcxda,yhly) VALUES('$username','$password','$email',$sex,'$sfz','$shouji','$mmcxwt','$mmcxda','$yh_ly')";
echo $sql;
$AdminResult1=mssql_query($sql);
if($AdminResult1==true)
{ echo "成功";
}
else
{
echo "注册失败";
}
}
{
//已经注册
}
else
{
//写入数据
}
---------------------------------------------------
mssql_query的返回值:
Returns a MS SQL result resource on success, TRUE if no rows were returned, or FALSE on error.
if($AdminResult){
$temp="<script type='text/javascript'>alert('此用户名已注册,请确认!');history.go(-1);</script>";
echo $temp;
}
将if的条件改一下if(mysql_num_rows($AdminResult) > 0){
$temp="<script type='text/javascript'>alert('此用户名已注册,请确认!');history.go(-1);</script>";
echo $temp;
}