表单:http://www.yangcer.cn/eteam/register.php
执行文件:http://www.yangcer.cn/eteam/register_ac.php(代码如下)
<?php
session_start();
include_once('inc/db.inc.php');$user_name = $_POST['user_name'];
$user_pwd1 = $_POST['user_pwd1'];
$user_pwd2 = $_POST['user_pwd2'];
$user_qq = $_POST['user_qq'];
$user_sex = $_POST['user_sex'];
$user_gc = $_POST['user_gc'];
$user_like = $_POST['user_like'];$sql3 = "select user_id from yzx.myuser where user_name='$user_name'";
$db->query($sql3);
if($db->affected_rows()>0){
echo '<script language="javascript">
alert("注册失败,用户名已经存在!");
history.go(-1);
</script>';
exit();
}if(!isset($user_name) && !isset($user_pwd1) && !isset($user_pwd2)){
echo '<script language="javascript">
alert("信息填写不完整!");
history.go(-1);
</script>';
exit();
}
if($user_pwd1 <> $user_pwd2){
echo '<script language="javascript">
alert("两次密码输入不一致!");
history.go(-1);
</script>'; }$user_pwd = md5($user_pwd1);
$sql = "INSERT INTO yzx.myuser(user_id,user_name,user_pwd,user_qq,reg_date,user_sex,user_gc,user_like)VALUES(NULL,'$user_name','$user_pwd','$user_qq',now(),'$user_sex','$user_gc','$user_like')";
$db->query($sql);
if($db->affected_rows>0){
$_SESSION['valid_user'] = $user_name;
echo '<script language="javascript">
alert("恭喜您,注册成功!");
history.go(-2);
</script>';
}
?>在提交表单的时候页面空白,没有写进数据库,没有反应(数据库链接没有错误),请教高手!
执行文件:http://www.yangcer.cn/eteam/register_ac.php(代码如下)
<?php
session_start();
include_once('inc/db.inc.php');$user_name = $_POST['user_name'];
$user_pwd1 = $_POST['user_pwd1'];
$user_pwd2 = $_POST['user_pwd2'];
$user_qq = $_POST['user_qq'];
$user_sex = $_POST['user_sex'];
$user_gc = $_POST['user_gc'];
$user_like = $_POST['user_like'];$sql3 = "select user_id from yzx.myuser where user_name='$user_name'";
$db->query($sql3);
if($db->affected_rows()>0){
echo '<script language="javascript">
alert("注册失败,用户名已经存在!");
history.go(-1);
</script>';
exit();
}if(!isset($user_name) && !isset($user_pwd1) && !isset($user_pwd2)){
echo '<script language="javascript">
alert("信息填写不完整!");
history.go(-1);
</script>';
exit();
}
if($user_pwd1 <> $user_pwd2){
echo '<script language="javascript">
alert("两次密码输入不一致!");
history.go(-1);
</script>'; }$user_pwd = md5($user_pwd1);
$sql = "INSERT INTO yzx.myuser(user_id,user_name,user_pwd,user_qq,reg_date,user_sex,user_gc,user_like)VALUES(NULL,'$user_name','$user_pwd','$user_qq',now(),'$user_sex','$user_gc','$user_like')";
$db->query($sql);
if($db->affected_rows>0){
$_SESSION['valid_user'] = $user_name;
echo '<script language="javascript">
alert("恭喜您,注册成功!");
history.go(-2);
</script>';
}
?>在提交表单的时候页面空白,没有写进数据库,没有反应(数据库链接没有错误),请教高手!
这个函数是怎么写的?select的时候函数是mysql_num_rows(),insert/update/delete的时候函数是
mysql_affected_rows(),你这个函数里面作了区分没有?
还有建议先做判空和密码有效性检查,在做重名检查。if(!isset($user_name) && !isset($user_pwd1) && !isset($user_pwd2)){
echo ' <script language="javascript">
alert("信息填写不完整!");
history.go(-1);
</script>';
exit();
}
if($user_pwd1 <> $user_pwd2){
echo ' <script language="javascript">
alert("两次密码输入不一致!");
history.go(-1);
</script>'; }
$sql3 = "select user_id from yzx.myuser where user_name='$user_name'";
$db->query($sql3);
if($db->affected_rows()>0){
echo ' <script language="javascript">
alert("注册失败,用户名已经存在!");
history.go(-1);
</script>';
exit();
}
$user_pwd = md5($user_pwd1);
$sql = "INSERT INTO yzx.myuser(user_id,user_name,user_pwd,user_qq,reg_date,user_sex,user_gc,user_like)VALUES(NULL,'$user_name','$user_pwd','$user_qq',now(),'$user_sex','$user_gc','$user_like')";
$db->query($sql);
if($db->affected_rows>0){
$_SESSION['valid_user'] = $user_name;
echo ' <script language="javascript">
alert("恭喜您,注册成功!");
history.go(-2);
</script>';
}
?>
1:确认数据有收到
2:确认数据连接正确
3:确认sql语句正确
至于成功执行后的js提示看执行的条件是否满足