你好,我有一个问题,当登录和资源#5 id错误返回。1. 当我从localhost:80登录时,我登录正常,没有错误。2. 当我从localhost/index.php登录时,由于某些原因,它给出了一个资源id #5。
为什么会发生这种情况,我应该如何修复它?代码如下:
require("connectuser.php");
require("activeuser.php");
session_start();
$makesure = stripslashes($_POST['username']);
$makesure16 = stripslashes($_POST['password']);
$applications = mysql_real_escape_string($makesure);
$mytabletop = mysql_real_escape_string($makesure16);
$encryptpassword = md5($makesure16);
$sqlstatement = "SELECT * FROM user WHERE emailaddress = '$makesure' AND password = '$encryptpassword'";
$whatever = mysql_query($sqlstatement) or die("Unable to Sign In");
$appstore = mysql_num_rows($whatever) or die($whatever);
简短回答:
去掉
后面的or die...
部分$appstore = mysql_num_rows($whatever) or die($whatever);
长答案:Here.
die
函数不能占用mysql资源$whatever
。尝试将错误信息更改为$appstore = mysql_num_rows($whatever) or die(mysql_error());
编辑:
$appstore = mysql_num_rows($whatever);
if($appstore === FALSE) die(mysql_error);