mysql_num_rows($result)总是等于0，为什么？解决方案
日期：2014-05-17 浏览次数：20454 次
mysql_num_rows($result)总是等于0，为什么？急急
<?php
session_start();
$db=mysql_connect("localhost","root","205513")or die("unable to connect");
mysql_select_db("guanliku",$db)or die(mysql_error($db));
mysql_query("set names gb2312");
$name=(isset($_POST['name']))?trim($_POST['name']):'';
$password=(isset($_POST['passwrod']))?trim($_POST['password']):'';
$redirect=(isset($_REQUEST['redirect']))?$_REQUEST['redirect']:'tobiao.php';
if(isset($_POST['submit'])&&$_POST['submit']=='Login'){
$query='select access_level from cms_users
where '.'name="'.mysql_real_escape_string($name,$db).'"and
'.'password=PASSWORD("'.mysql_real_escape_string($password,$db).'")';
$result=mysql_query($query,$db)or die(mysql_error($db));
if(mysql_num_rows($result)>0){
$_SESSION['name']=$name;
$_SESSION['logged']=1;
header('Refresh: 5; URL='.$redirect);
echo '<p>'.$name.'你将进入你自己的主页！</p>';
echo '<p><a href="'.$redirect.'">click here</a></p>';
}
else{
$error='<p><strong> 不合法的用户名'.
'密码!</strong> 请 <a href="register.php">点击'.'注册</a> 如果你还没有注册</p>';
}
mysql_free_result($result);
}
?>
<html>
<head>
<title>login</title>
</head>
<body>
<?php
if(isset($error)){
echo $error;
}
?>
<form action="login.php" method="post">
<table>
<tr>
<td><label for="name">姓名:</label></td>
<td><input type="text" name="name" value="<?php echo $name;?>" maxlength="20" size="20"></td>
</tr><tr>
<td><label for="password">密码:</label></td>
<td><input type="password" name="password" value="<?php echo $password;?>" maxlength="20" size="20"></td>
</tr><tr>
<td></td>
<td>
<input type="hidden" name="redirect" value="<?php echo $redirect?>">
<input type="submit" name="submit" value="Login">
</td>
</tr>
</table>
</form>
</body>
</html>
------解决方案--------------------
echo $query;
将$query的结果放到数据查询工具运行下,看看结果是不是0.
------解决方案--------------------
$password=(isset($_POST['passwrod']))?trim($_POST['password']):'';
$password=(isset($_POST['password']))?trim($_POST['password']):'';
还是字母打错了。
<?php
session_start();
$db=mysql_connect("localhost","root","205513")or die("unable to connect");
mysql_select_db("guanliku",$db)or die(mysql_error($db));
mysql_query("set names gb2312");
$name=(isset($_POST['name']))?trim($_POST['name']):'';
$password=(isset($_POST['passwrod']))?trim($_POST['password']):'';
$redirect=(isset($_REQUEST['redirect']))?$_REQUEST['redirect']:'tobiao.php';
if(isset($_POST['submit'])&&$_POST['submit']=='Login'){
$query='select access_level from cms_users
where '.'name="'.mysql_real_escape_string($name,$db).'"and
'.'password=PASSWORD("'.mysql_real_escape_string($password,$db).'")';
$result=mysql_query($query,$db)or die(mysql_error($db));
if(mysql_num_rows($result)>0){
$_SESSION['name']=$name;
$_SESSION['logged']=1;
header('Refresh: 5; URL='.$redirect);
echo '<p>'.$name.'你将进入你自己的主页！</p>';
echo '<p><a href="'.$redirect.'">click here</a></p>';
}
else{
$error='<p><strong> 不合法的用户名'.
'密码!</strong> 请 <a href="register.php">点击'.'注册</a> 如果你还没有注册</p>';
}
mysql_free_result($result);
}
?>
<html>
<head>
<title>login</title>
</head>
<body>
<?php
if(isset($error)){
echo $error;
}
?>
<form action="login.php" method="post">
<table>
<tr>
<td><label for="name">姓名:</label></td>
<td><input type="text" name="name" value="<?php echo $name;?>" maxlength="20" size="20"></td>
</tr><tr>
<td><label for="password">密码:</label></td>
<td><input type="password" name="password" value="<?php echo $password;?>" maxlength="20" size="20"></td>
</tr><tr>
<td></td>
<td>
<input type="hidden" name="redirect" value="<?php echo $redirect?>">
<input type="submit" name="submit" value="Login">
</td>
</tr>
</table>
</form>
</body>
</html>
------解决方案--------------------
echo $query;
将$query的结果放到数据查询工具运行下,看看结果是不是0.
------解决方案--------------------
$password=(isset($_POST['passwrod']))?trim($_POST['password']):'';
$password=(isset($_POST['password']))?trim($_POST['password']):'';
还是字母打错了。
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
