21,893
社区成员




echo "$result";
echo "$sql";
,在数据连接失败后面也加多这两个输出<?
session_start();
header('Content-Type:text/html;charset=GB2312');//避免输出乱码
include('../inc/inc.php');//包含数据库基本配置信息
$datetime=date('Y-m-d');//获得系统时间
$url=$_SERVER['HTTP_REFERER'];//跳转页面
//检查域名是否存在
$sql="select * from member where account='$_POST[username]';";
$result=mysql_query($sql);
if($_POST['postcode']!=$_SESSION["code"])
{
echo "<SCRIPT LANGUAGE='Javascript'>";
echo "alert('您输入的验证码错误,请重新输入!');";
echo "location.href='$url'";
echo "</SCRIPT>";
}elseif(mysql_num_rows($result)>0){
//页面跳转
echo "<SCRIPT LANGUAGE='Javascript'>";
echo "alert('您输入的用户名错误!');";
echo "location.href='$url'";
echo "</SCRIPT>";
}elseif($_POST['userpwd']!=$_POST['reuserpwd']){
echo "<SCRIPT LANGUAGE='Javascript'>";
echo "alert('您输入的两次密码不正确!');";
echo "location.href='$url'";
echo "</SCRIPT>";
}elseif($_POST['username']==""||$_POST['userpwd']==""||$_POST['reuserpwd']==""||$_POST['email']==""){
echo "<SCRIPT LANGUAGE='Javascript'>";
echo "alert('带*号的选项必须填写!');";
echo "location.href='$url'";
echo "</SCRIPT>";
}else
{
$sql="INSERT INTO member (
typeid,
account,
psw,
email,
question,
answer,
sex,
name,
birthday,
address,
qq,
companyaddr,
companybusiness,
companytel,
companyfax,
companyweb,
date,
institutions,
education,
post,
pic,
expertise
) VALUES (
'".$_POST['typeid']."',
'".$_POST['username']."',
'".$_POST['userpwd']."',
'".$_POST['email']."',
'".$_POST['question']."',
'".$_POST['answer']."',
'".$_POST['sex']."',
'".$_POST['name']."',
'".$_POST['birthday']."',
'".$_POST['address']."',
'".$_POST['qq']."',
'".$_POST['companyaddr']."',
'".$_POST['companybusiness']."',
'".$_POST['companytel']."',
'".$_POST['companyfax']."',
'".$_POST['companyweb']."',
'$datetime',
'".$_POST['institutions']."',
'".$_POST['education']."',
'".$_POST['post']."',
'".$_POST['head']."',
'".$_POST['expertise']."'
)";
//$result=mysql_query($sql);
if($result){
//页面跳转
$url="../login.php";
echo "<SCRIPT LANGUAGE='Javascript'>";
echo "alert('注册成功!请点确定返回登陆界面!');";
echo "location.href='$url'";
echo "</SCRIPT>";
}
else{
echo "数据连接失败!";
}
}
?>
$sql="select * from member where account='$_POST[username]'";
$result=mysql_query($sql);
$num = mysql_num_rows($result);
if($num>0){
//页面跳转
$url= "../login.php ";
echo " <SCRIPT LANGUAGE= 'Javascript '> ";
echo "alert( '注册成功!请点确定返回登陆界面! '); ";
echo "location.href= '$url ' ";
echo " </SCRIPT> ";
}
else{
echo "数据连接失败! ";
$sql="select * from member where account='$_POST[username]';";
$result=mysql_query($sql);
$result=mysql_query($mysql);
//$num = mysql_affected_rows($result);
$rs=mysql_fetch_array($result); //shuzu
$num=$rs[0]; //记录总数
if($num>0){
//页面跳转
//$url= "../login.php ";
echo " <SCRIPT LANGUAGE= 'Javascript '> ";
echo "alert( '注册成功!请点确定返回登陆界面! '); ";
echo "location.href= '$url ' ";
echo " </SCRIPT> ";
}
else{
echo "数据连接失败! ";
}
$result=mysql_query($sql);
$num = mysql_affected_rows($result);
if($num>0){
//页面跳转
$url= "../login.php ";
echo " <SCRIPT LANGUAGE= 'Javascript '> ";
echo "alert( '注册成功!请点确定返回登陆界面! '); ";
echo "location.href= '$url ' ";
echo " </SCRIPT> ";
}
else{
echo "数据连接失败! ";