<?php require_once("mywebmanage/conn.php");?><? $username=$_POST['username']; $email1=$_POST['email1']; $acctiveme=$_POST['acctiveme']; $password=md5($_POST['password']); $yanzheng=$_POST['yanzheng']; $question=$_POST['question']; $answer=$_POST['answer']; $rs=mysql_query("select * from member where username='$username'");
if(mysql_num_rows($rs)>0)
if(mysql_num_rows($array)>0) 可改成 if(is_array($array))int mysql_num_rows ( resource result ) //接收的是mysql查询返回的结果
array mysql_fetch_array ( resource result [, int result_type] ) //返回的是数组明显不对了
数据库连接
性病医院
杭州保洁公司
合肥月嫂
中老年摄影
$username=$_POST['username'];
$email1=$_POST['email1'];
$acctiveme=$_POST['acctiveme'];
$password=md5($_POST['password']);
$yanzheng=$_POST['yanzheng'];
$question=$_POST['question'];
$answer=$_POST['answer']; $rs=mysql_query("select * from member where username='$username'");
if(mysql_num_rows($rs)>0)
{
echo "<script>alert('用户名已经存在,请重新注册');history.go(-1);</script>";
}
else
{
$sql="insert into member(username,password,sex,email1,question,key) VALUES ('$username','$password','$acctiveme','$email1','$question','$answer')";
echo $sql;
$_SESSION['username']=$username;
mysql_query($sql);
echo "<script>alert('恭喜您,注册成功!');location.href='reg.php';</script>";
}
?>提交注册成功了,可是数据里没有数据
“supplied argument is not a valid MySQL result resource”
mysql_num_rows() 返回结果集中行的数目。此命令仅对 SELECT 语句有效。要取得被 INSERT,UPDATE 或者 DELETE 查询所影响到的行的数目,用 mysql_affected_rows()。
mysql_num_rows($rs) 嘛~~~~~~
那你的$username=$_POST['username'];
$email1=$_POST['email1'];
$acctiveme=$_POST['acctiveme'];
$password=md5($_POST['password']);
$yanzheng=$_POST['yanzheng'];
$question=$_POST['question'];
$answer=$_POST['answer'];
就要放在
require_once("mywebmanage/conn.php");前面
看下输出的sql语句是什么
$sql="insert into member(username,password,sex,email1,question,key) VALUES ('$username','$password','$acctiveme','$email1','$question','$answer')";
echo $sql;
$_SESSION['username']=$username;
mysql_query($sql);
echo "<script>alert('恭喜您,注册成功!');location.href='reg.php';</script>";改为
$sql="insert into member(username,password,sex,email1,question,key) VALUES ('$username','$password','$acctiveme','$email1','$question','$answer')";
mysql_query($sql) or die(mysql_error());
if(mysql_affected_rows()) {
$_SESSION['username']=$username;
echo "<script>alert('恭喜您,注册成功!');location.href='reg.php';</script>";
}