提示如下
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\Debug\php\phphuanjing\htdocs\agoodic\admin\index.php on line 145以下是我的代码,主要前两个都对,
$bumen=$_POST['menu1'];
$names=$_POST['textfield'];
$pwd=$_POST['textfield2'];
if ($bumen==0){
$sql="select * from tabadmin where sname='$names' and pws='$pwd'";
$result=mysql_query($sql,$conn);
$row=mysql_num_rows($result); if ($row > 0){
$_SESSION['names']=$names;
$_SESSION['pass']=$pwd;
echo "<script>alert('登录成功!');location.href='admin_index.php'</script>";
}else{
//echo $sql;
echo "<script>alert('登失败!');location.href='index.php';</script>";
}
}elseif ($bumen==1){
$sql="select * from tabforign where sellername='$names' and Pws='$pwd'";
$result=mysql_query($sql,$conn);
$row=mysql_num_rows($result);
if($row>0){
$_SESSION['names']=$names;
$_SESSION['pass']=$pwd;
echo "<script>alert('登录成功!');location.href='admin_trade.php'</script>";
}else{
echo "<script>alert('登失败!');location.href='index.php';</script>";
}
}elseif($bumen==2){
$sql="select * from tabpurchase where sname='$names' and pwd='$pwd'";
$result=mysql_query($sql,$conn); ---这是是145行 出错不知道为什么,代码都一样啊
$row=mysql_num_rows($result);
if($row>0){
$_SESSION['names']=$names;
$_SESSION['pass']=$pwd;
echo "<script>alert('登录成功!');location.href='admin_purchase.php'</script>";
}else{
echo "<script>alert('登失败!');location.href='index.php';</script>";
}
}求救啊
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\Debug\php\phphuanjing\htdocs\agoodic\admin\index.php on line 145以下是我的代码,主要前两个都对,
$bumen=$_POST['menu1'];
$names=$_POST['textfield'];
$pwd=$_POST['textfield2'];
if ($bumen==0){
$sql="select * from tabadmin where sname='$names' and pws='$pwd'";
$result=mysql_query($sql,$conn);
$row=mysql_num_rows($result); if ($row > 0){
$_SESSION['names']=$names;
$_SESSION['pass']=$pwd;
echo "<script>alert('登录成功!');location.href='admin_index.php'</script>";
}else{
//echo $sql;
echo "<script>alert('登失败!');location.href='index.php';</script>";
}
}elseif ($bumen==1){
$sql="select * from tabforign where sellername='$names' and Pws='$pwd'";
$result=mysql_query($sql,$conn);
$row=mysql_num_rows($result);
if($row>0){
$_SESSION['names']=$names;
$_SESSION['pass']=$pwd;
echo "<script>alert('登录成功!');location.href='admin_trade.php'</script>";
}else{
echo "<script>alert('登失败!');location.href='index.php';</script>";
}
}elseif($bumen==2){
$sql="select * from tabpurchase where sname='$names' and pwd='$pwd'";
$result=mysql_query($sql,$conn); ---这是是145行 出错不知道为什么,代码都一样啊
$row=mysql_num_rows($result);
if($row>0){
$_SESSION['names']=$names;
$_SESSION['pass']=$pwd;
echo "<script>alert('登录成功!');location.href='admin_purchase.php'</script>";
}else{
echo "<script>alert('登失败!');location.href='index.php';</script>";
}
}求救啊
2:sql语句中包含特殊符号,不能安全执行sql。
建议LZ print_r一下$conn,如果没有问题就对你的sql语句执行下mysql_real_escape_string