我试图创建一个自动注销系统,将自动退出系统时,页面是不活动的,我是一个新手,当我添加代码到我的登录页面我得到这些警告
Warning: mysql_query() expects parameter 1 to be string, resource given in C:'xampp'htdocs'how are things'admin panel'login.php on line 80
Warning: mysql_num_rows() expects parameter 1 to be resource, null given in C:'xampp'htdocs'how are things'admin panel'login.php on line 81
第80行和第81行代码分别如下
if($no_rows > 0){
while($resGetAdmin = mysql_fetch_assoc($rs_user))
这是我的代码我添加
$rs_user= mysql_query($check_login);
$no_rows = mysql_num_rows($rs_user);
if($no_rows > 0){
while($resGetAdmin = mysql_fetch_assoc($rs_user)){
$selQuery="select * from login where user_id=".$resGetAdmin['user_id'] ." AND loginDate ='$current_date'";
$rgetData= mysql_query($selQuery);
$num_login = getSqlNumber($selQuery);
if($num_login==0) {
$insQuery= "insert into login (user_id,loginTime,loginDate,count) values (".$resGetAdmin['user_id'].",'$current_time','$current_date',1)";
$login_user= mysql_query($insQuery);
$insert_id=mysql_insert_id();
$_SESSION['loginTime']=$current_time;
}else{
$count = mysql_result($rgetData,0,’count’);
$count = $count+1;
$updateQuery= "update login set loginTime='$current_time' ,loginDate='$current_date' , count ='$count' where user_id=".$resGetAdmin['user_id'] ." AND loginDate='$current_date'";
$login_user= mysql_query($updateQuery) or mysql_error();
$_SESSION['loginTime']=$current_time;
}
$_SESSION['user_id']=$resGetAdmin['user_id'];
header("Location: index.php");
exit;
}
}
这是我在添加上面的代码之前的原始登录页面
<?php
if(isset($_POST['submit'])){
$username = $_POST['username'];
$password =($_POST['password']);
$hash_password = md5($password);
$hash_password1 = sha1($hash_password);
$hash_password2 = crypt($hash_password1,"st");
$hash_password3 = hash("sha512",$hash_password2);
$guess = $_POST['captcha'];
$real = (isset($_SESSION['real'])) ? $_SESSION['real'] : "";
if (empty($guess))
{
die("Please enter the correct CAPTCHA.<br>");
}
if (!empty($guess) && $guess !== $real)
{
die("Please enter the correct CAPTCHA.<br>");
}
if(empty($username) or empty($password)){
echo "<p>fields empty !</p>";
}
else {
$check_login = mysql_query("SELECT id, type FROM users WHERE username='$username' AND password='$hash_password3'");
if(mysql_num_rows($check_login) == 1) {
$run = mysql_fetch_array($check_login);
$user_id = $run['id'];
$type = $run['type'];
if($type == 'd'){
echo "<p> Your Account is deactivated byt the site admin!</p>";
} else {
$_SESSION['user_id'] = $user_id;
header('location: index.php');
}
} else {
echo "<p> User Name or Password incorrect!</p>";
} }
}
?>
我将整个代码粘贴到登录页面上,但我留下了timeout.php页面,提前感谢大家
不需要通过编写自己的代码来执行此注销。每个会话可以配置为只持续一定的时间。
我打赌是:
第80行:
$rs_user= mysql_query($check_login);
$check_login is NOT一个包含查询的字符串
$rs_user 返回false,因为查询失败。
(我猜$check_login是另一个查询的结果集)
*警告:mysql_query()期望参数1是字符串,资源在C:'xampp'htdocs'how are things'admin panel'login.php on line 80*
第81行:
$no_rows = mysql_num_rows($rs_user);
警告:mysql_num_rows()期望参数1是资源,null在C:'xampp'htdocs'how are things'admin panel'login.php在第81行
(mysql说NULL是给定的,这是因为$rs_user返回false(参见上面的第80行解释)