1楼的不是说了么?你的mysql_query之前把你的sql语句输出一下,然后到phpmyadmin里面执行下,看能执行不,一般都是你的sql有问题。 $sql1="SELECT * FROM cdb_members where username='$username' and password='$password'"; 改了引号试下
错误一:繁体字都不能正确查询; 问题一:mysql_query("set names gb2312"); //GB2312为中文简体编码格式,用于繁体可能会出现错误,繁体编码用BIG5,如果数据当中既有简体又有繁体,则应用UTF-8格式.改为mysql_query("set names BIG5");或是mysql_query("set names UTF-8");试试看 . 错误二:当查村结果为0时,提示警告: mysql_num_rows():supplied argument is not a valid MYsql 问题二:如LS所说,把你的源码做如下修改进行测试 $conn=mysql_connect ("192.168.1.9", "root", "123"); mysql_query("set names gb2312"); //解决中文乱码问题 mysql_select_db("mydb"); $sqlcf = "select * from bbsvip where username='$username'"; $resultcf = mysql_query($sqlcf); $num_rowscf = mysql_num_rows($resultcf); if($num_rowscf != 0){ $errmsg = "您已提交过申请,请耐心等待审核!"; }else{ mysql_select_db("bbsup"); $sql1="SELECT * FROM cdb_members where username=`$username` and password=`$password`"; echo $sql1; $result = mysql_query($sql1); $num_rows = mysql_num_rows($result); if($num_rows == 1){ mysql_select_db("mydb"); $exec="insert into bbsvip (`username`,`nickname`,`name`,`sex`,`tel`,`birthday`,`qq`,`email`,`addtime`) values ('$username','$nickname','$name','$sex','$tel','$birthday','$qq','$email','$addtime')"; if(mysql_query($exec)){ $errmsg = "您的VIP申请发布成功,请等待管理员审核!"; }else { $errmsg = "发布失败,请通知管理员!"; } }else{ $errmsg = "用户名或密码错误!"; } } 查看页面上的$sql1的值后再判断错在哪.
$sql1="SELECT * FROM cdb_members where username='$username' and password='$password'";
改了引号试下
问题一:mysql_query("set names gb2312"); //GB2312为中文简体编码格式,用于繁体可能会出现错误,繁体编码用BIG5,如果数据当中既有简体又有繁体,则应用UTF-8格式.改为mysql_query("set names BIG5");或是mysql_query("set names UTF-8");试试看 .
错误二:当查村结果为0时,提示警告:
mysql_num_rows():supplied argument is not a valid MYsql
问题二:如LS所说,把你的源码做如下修改进行测试
$conn=mysql_connect ("192.168.1.9", "root", "123");
mysql_query("set names gb2312"); //解决中文乱码问题
mysql_select_db("mydb");
$sqlcf = "select * from bbsvip where username='$username'";
$resultcf = mysql_query($sqlcf);
$num_rowscf = mysql_num_rows($resultcf); if($num_rowscf != 0){
$errmsg = "您已提交过申请,请耐心等待审核!";
}else{
mysql_select_db("bbsup");
$sql1="SELECT * FROM cdb_members where username=`$username` and password=`$password`";
echo $sql1;
$result = mysql_query($sql1);
$num_rows = mysql_num_rows($result);
if($num_rows == 1){
mysql_select_db("mydb");
$exec="insert into bbsvip (`username`,`nickname`,`name`,`sex`,`tel`,`birthday`,`qq`,`email`,`addtime`) values ('$username','$nickname','$name','$sex','$tel','$birthday','$qq','$email','$addtime')";
if(mysql_query($exec)){
$errmsg = "您的VIP申请发布成功,请等待管理员审核!";
}else {
$errmsg = "发布失败,请通知管理员!";
}
}else{
$errmsg = "用户名或密码错误!";
}
}
查看页面上的$sql1的值后再判断错在哪.