<?php
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"php 开头\");</SCRIPT> ";
@header('Content-type: text/html;charset=UTF-8');
$id = $_POST['ID'];
$name = $_POST['name'];
$password = $_POST['password'];
$idCardNo = $_POST['idCardNo'];
$age = $_POST['age'];
$birthday = $_POST['birthday'];
$email = $_POST['email'];if ($id != "")//用户输入数据了
{
echo "<SCRIPT LANGUAGE=\"javascript\"> alert($id);</SCRIPT> ";
//连接数据库
$sqlHost="10.10.168.77";
$sqlUser="sa";
$sqlPassword="111";
$conn_id=@mssql_connect($sqlHost,$sqlUser,$sqlPassword) or die ("Can't connect $sqlHost");
$database = "userRegister";
@mssql_select_db($database) or die ("Can't select the database:$database");
$query="select count(*) as counts from userInfo where id='$id'";
$result=mssql_query($query,$conn_id);
$row=mssql_fetch_array($result); if ($row['counts'])//已经有了这个ID的记录
{
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"ID已经注册过!\");</SCRIPT> ";
//header("userRegister.php");
echo "<script>document.location.href='userRegister.php';</script>";
}
$query="select count(*) as counts from userInfo where name='$name'";
$result=mssql_query($query,$conn_id);
$row=mssql_fetch_array($result);
if ($row['counts'])//已经有了这个姓名的记录
{
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"用户名已经注册过!\");</SCRIPT> ";
//header("userRegister.php");
echo "<script>document.location.href='userRegister.php';</script>";
}
$query="select count(*) as counts from userInfo where idCardNo='$idCardNo'";
$result=mssql_query($query,$conn_id);
$row=mssql_fetch_array($result);
if ($row['counts'])//已经有了这个身份证的记录
{
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"身份证号已经注册过!\");</SCRIPT> ";
//header("userRegister.php");
echo "<script>document.location.href='userRegister.php';</script>";
}
$query="select count(*) as counts from userInfo where email='$email'";
$result=mssql_query($query,$conn_id);
$row=mssql_fetch_array($result);
if ($row['counts'])//已经有了这个电子邮箱的记录
{
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"电子邮箱已经注册过!\");</SCRIPT> ";
//header("userRegister.php");
echo "<script>document.location.href='userRegister.php';</script>";
}
$query = "INSERT INTO userInfo (ID, name, password, idCardNo, age, birthday, email) VALUES ('$id', '$name', '$password', '$idCardNo', '$age', '$birthday', '$email')";
$result=mssql_query($query,$conn_id);
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"又查询一遍\");</SCRIPT> ";
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"..............\");</SCRIPT> ";
echo "<script>document.location.href='userRegister.php';</script>";
}
?>这段程序里,if ($row['counts'])//已经有了这个ID的记录 后,发现有重复的ID。本该不执行$query = "INSERT INTO userInfo,但是我运行的结果是,运行了插入语句,但是却没有运行插入语句下面的echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"又查询一遍\");</SCRIPT> ";。感觉很诡异,哪位老大给我指出哪里出的问题?
谢谢
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"php 开头\");</SCRIPT> ";
@header('Content-type: text/html;charset=UTF-8');
$id = $_POST['ID'];
$name = $_POST['name'];
$password = $_POST['password'];
$idCardNo = $_POST['idCardNo'];
$age = $_POST['age'];
$birthday = $_POST['birthday'];
$email = $_POST['email'];if ($id != "")//用户输入数据了
{
echo "<SCRIPT LANGUAGE=\"javascript\"> alert($id);</SCRIPT> ";
//连接数据库
$sqlHost="10.10.168.77";
$sqlUser="sa";
$sqlPassword="111";
$conn_id=@mssql_connect($sqlHost,$sqlUser,$sqlPassword) or die ("Can't connect $sqlHost");
$database = "userRegister";
@mssql_select_db($database) or die ("Can't select the database:$database");
$query="select count(*) as counts from userInfo where id='$id'";
$result=mssql_query($query,$conn_id);
$row=mssql_fetch_array($result); if ($row['counts'])//已经有了这个ID的记录
{
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"ID已经注册过!\");</SCRIPT> ";
//header("userRegister.php");
echo "<script>document.location.href='userRegister.php';</script>";
}
$query="select count(*) as counts from userInfo where name='$name'";
$result=mssql_query($query,$conn_id);
$row=mssql_fetch_array($result);
if ($row['counts'])//已经有了这个姓名的记录
{
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"用户名已经注册过!\");</SCRIPT> ";
//header("userRegister.php");
echo "<script>document.location.href='userRegister.php';</script>";
}
$query="select count(*) as counts from userInfo where idCardNo='$idCardNo'";
$result=mssql_query($query,$conn_id);
$row=mssql_fetch_array($result);
if ($row['counts'])//已经有了这个身份证的记录
{
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"身份证号已经注册过!\");</SCRIPT> ";
//header("userRegister.php");
echo "<script>document.location.href='userRegister.php';</script>";
}
$query="select count(*) as counts from userInfo where email='$email'";
$result=mssql_query($query,$conn_id);
$row=mssql_fetch_array($result);
if ($row['counts'])//已经有了这个电子邮箱的记录
{
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"电子邮箱已经注册过!\");</SCRIPT> ";
//header("userRegister.php");
echo "<script>document.location.href='userRegister.php';</script>";
}
$query = "INSERT INTO userInfo (ID, name, password, idCardNo, age, birthday, email) VALUES ('$id', '$name', '$password', '$idCardNo', '$age', '$birthday', '$email')";
$result=mssql_query($query,$conn_id);
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"又查询一遍\");</SCRIPT> ";
echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"..............\");</SCRIPT> ";
echo "<script>document.location.href='userRegister.php';</script>";
}
?>这段程序里,if ($row['counts'])//已经有了这个ID的记录 后,发现有重复的ID。本该不执行$query = "INSERT INTO userInfo,但是我运行的结果是,运行了插入语句,但是却没有运行插入语句下面的echo "<SCRIPT LANGUAGE=\"javascript\"> alert(\"又查询一遍\");</SCRIPT> ";。感觉很诡异,哪位老大给我指出哪里出的问题?
谢谢
解决方案 »
- 关于php中文正则的问题
- 统计sql语句
- PHP执行oracle查询出错,麻烦大家帮看看……
- PHP的session_start()和require_once起冲突了怎么办?
- 我的IE是中文的:IE6.0(SP2)版本,但$_SERVER["HTTP_ACCEPT_LANGUAGE"]却等于en-gb(按道理应该为zh-cn才对)??感觉很奇怪,请问各位大侠
- 怎样require上一级目录下的文件?
- 为什么我的PHP留言程序,老是会读不到留言的内容呢?
- 怪现象,请教高手
- 请问有支持函数、类索引的php编辑器吗?好像turbo php曾经有过,但是功能不是很强大,不能像VC6那样完美呀!
- JSON 中文UNICODE编码问题,请指点
- 页面跳转后,原来的页面的打印信息是不是就不能在新的页面里显示了?
- 有人用过开源的PHP报表吗?
你可以到ff上去看,错误控制台里应该会提示js错误.
是程序里有页面跳转,echo " <script>document.location.href='userRegister.php'; </script>"; 客户端跳转到另一个页面去了,所以显示不出从服务器echo过来的东东。