你好，我有一个问题，当登录和资源#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);