donglongqiao9595
donglongqiao9595
2014-03-05 12:50

PHP和mySql中的管理员登录页面出错

  • php
  • mysql

When i run this code everything seems to be fine... But when I login with the right username and password i get the following: That information is incorrect, try again Click Here I should be taken to the index.php file.

I also have echo the sql query and it gave me this Resource id #4

Can anyone spot the problem here.

Here is the PHP

$manager = preg_replace('#[^A-Za-z0-9]#i','',$_SESSION["username"]);
$password = preg_replace('#[^A-Za-z0-9]#i','',$_SESSION["password"]);

include"db_connection.php"; 

$sql = mysql_query("SELECT id FROM admin WHERE username='$manager' and password='$password' LIMIT 1");


$existCount = mysql_num_rows($sql);
if ($existCount ==1){
    while($row = mysql_fetch_array($sql)){
        $id=$row["id"];
    }

    $_SESSION["id"]=$id;
    $_SESSION["manager"]=$manager;
    $_SESSION["password"]=$password;
    header("location:index.php");
        exit();
    }else{
        echo'That information is incorrect, try again<a href="index.php"> Click Here</a>';
        exit();
    }
}

?>

Here is the HTML:

<html>
<head>
<title> Admin Login Page</title>

<head>
<body>
<div align="center" id="mainWrapper">

<div id="pageContent"><br/>
    <div align="left" style="margin-left:24px;">
        <h2> Please log in To manage the store</h2>
        <form id="form1" name="form1" method="post"   action="admin_login.php">
            User Name: <br/>
            <input name="username" type="text" id="username" size="40"/>
            <br/></br>
            Password: <br/>
            <input name="password" type="password" id="password" size="40">
                <br/>
                <br/>
                <br/>
                <br/>
                <br/>
            <label>
                <input type="submit" name="button" id="button" value="LogIn">
            </label>
        </form>
</body>
</html>
  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

2条回答

为你推荐