网站是 PHP链接 sql2008 数据库,测试已经和数据库链接成功。但是...在页面上填写数据库中已有用户名点击提交时,不提示 用户已被注册...而是直接跳转到...注册失败... 在页面上填写数据库中没有的用户名点击提交时,不提示 注册成功...而是直接跳转到...注册失败....本人第一次用PHP 很多地方看不懂请各位大侠帮帮小弟....$serverName = "(local)";
$connectionInfo = array("UID"=>"sa","PWD"=>"sa","Database"=>"test");
$conn = sqlsrv_connect( $serverName, $connectionInfo);$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."'";
$AdminResult=mssql_query($Query);
if(mssql_num_rows($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')";
$AdminResult1=mssql_query($sql);
if($AdminResult1==true)
{
echo "<script>alert('恭喜您,注册成功!');window.location.href='index.html';</script>";
}
else
{
echo "<script>alert('注册失败!');window.location.href='index.html';</script>";
}
}
$connectionInfo = array("UID"=>"sa","PWD"=>"sa","Database"=>"test");
$conn = sqlsrv_connect( $serverName, $connectionInfo);$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."'";
$AdminResult=mssql_query($Query);
if(mssql_num_rows($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')";
$AdminResult1=mssql_query($sql);
if($AdminResult1==true)
{
echo "<script>alert('恭喜您,注册成功!');window.location.href='index.html';</script>";
}
else
{
echo "<script>alert('注册失败!');window.location.href='index.html';</script>";
}
}
$stmt = sqlsrv_query($conn,$qsql, array(),array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
$row_count = sqlsrv_num_rows( $stmt );这个就是取有没有记录的
$qsql = "select * from [user] where username='".$username."'";
$stmt = sqlsrv_query($conn,$qsql, array(),array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
$row_count = sqlsrv_num_rows( $stmt ); if($row_count>0){
$temp="<script type='text/javascript'>alert('此用户名已注册,请确认!');history.go(-1);</script>";
echo $temp;
}
else{
$qsql-1 = "INSERT INTO [user](username,password,email,sex,sfz,shouji,mmcxwt,mmcxda,yhly) VALUES('$username','$password','$email',$sex,'$sfz','$shouji','$mmcxwt','$mmcxda','$yh_ly')";
$stmt-1 = sqlsrv_query($conn,$qsql-1, array(),array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
$row_count-1 = sqlsrv_num_rows( $stmt-1 );
if($row_count-1==true){
echo "<script>alert('恭喜您,注册成功!');window.location.href='index.html';</script>"; }
else{
echo "<script>alert('注册失败!');window.location.href='index.html';</script>"; }
}
{
echo "Statement executed.\n";
}
else
{
echo "Error in statement execution.\n";
die( print_r( sqlsrv_errors(), true));
}
这是手册 你看下就明白了
可以度用很多软件,支持Mysql/PHP