21,886
社区成员
发帖
与我相关
我的任务
分享
$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 "注册失败";
}
}
if($AdminResult){
$temp="<script type='text/javascript'>alert('此用户名已注册,请确认!');history.go(-1);</script>";
echo $temp;
}
if(mysql_num_rows($AdminResult) > 0){
$temp="<script type='text/javascript'>alert('此用户名已注册,请确认!');history.go(-1);</script>";
echo $temp;
}
if(mssql_num_rows($AdminResult))
{
//已经注册
}
else
{
//写入数据
}