donh61500 2017-08-08 08:03
浏览 70
已采纳

基于PHP MySQL角色的登录重定向问题

I already have a Login system for Admins in my system. But now I need to add multiple pages that should be accessible only to "Super Admins" . I need to redirect them differently. I am stuck somewhere. need help to figure it out.

Below is the code:

Login.php is hold the main logic

<?php

/**
 * Class login
 * handles the user's login and logout process
 */
class Login
{
    /**
     * @var object The database connection
     */
    private $db_connection = null;
    /**
     * @var array Collection of error messages
     */
    public $errors = array();
    /**
     * @var array Collection of success / neutral messages
     */
    public $messages = array();

    /**
     * the function "__construct()" automatically starts whenever an object of this class is created,
     * you know, when you do "$login = new Login();"
     */
    public function __construct()
    {
        // create/read session, absolutely necessary
        session_start();

        // check the possible login actions:
        // if user tried to log out (happen when user clicks logout button)
        if (isset($_GET["logout"])) {
            $this->doLogout();
        }
        // login via post data (if user just submitted a login form)
        elseif (isset($_POST["login"])) {
            $this->dologinWithPostData();
        }
    }

    /**
     * log in with post data
     */
    private function dologinWithPostData()
    {
        // check login form contents
        if (empty($_POST['user_name'])) {
            $this->errors[] = "Username field was empty.";
        } elseif (empty($_POST['user_password'])) {
            $this->errors[] = "Password field was empty.";
        } elseif (!empty($_POST['user_name']) && !empty($_POST['user_password'])) {

            // create a database connection, using the constants from config/db.php (which we loaded in index.php)
            $this->db_connection = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);

            // change character set to utf8 and check it
            if (!$this->db_connection->set_charset("utf8")) {
                $this->errors[] = $this->db_connection->error;
            }

            // if no connection errors (= working database connection)
            if (!$this->db_connection->connect_errno) {

                // escape the POST stuff
                $user_name = $this->db_connection->real_escape_string($_POST['user_name']);

                // database query, getting all the info of the selected user (allows login via email address in the
                // username field)
                //$sql = "SELECT user_name, user_email, user_password_hash
                //        FROM users1
                //        WHERE user_name = '" . $user_name . "' OR user_email = '" . $user_name . "';";
                $sql = "SELECT * FROM users
                        WHERE username = '" . $user_name . "' OR uemail = '" . $user_name . "';";
                $result_of_login_check = $this->db_connection->query($sql);

                // if this user exists
                if ($result_of_login_check->num_rows == 1) {

                    // get result row (as an object)
                    $result_row = $result_of_login_check->fetch_object();

                    // using PHP 5.5's password_verify() function to check if the provided password fits
                    // the hash of that user's password
                    //if (password_verify($_POST['user_password'], $result_row->user_password_hash)) {
                    if ($_POST['user_password'] == $result_row->password) {
                        // write user data into PHP SESSION (a file on your server)
                        $_SESSION['user_name'] = $result_row->username;
                        $_SESSION['user_email'] = $result_row->uemail;
                        $_SESSION['user_login_status'] = 1;
                        $_SESSion['user_role'] = $result_row->role;

                    } else {
                        $this->errors[] = "Wrong password. Try again.";
                    }
                } else {
                    $this->errors[] = "This user does not exist.";
                }
            } else {
                $this->errors[] = "Database connection problem.";
            }
        }
    }

    /**
     * perform the logout
     */
    public function doLogout()
    {
        // delete the session of the user
        $_SESSION = array();
        session_destroy();
        // return a little feeedback message
        $this->messages[] = "You have been logged out.";

    }

    /**
     * simply return the current state of the user's login
     * @return boolean user's login status
     */
    public function isUserLoggedIn()
    {
        if (isset($_SESSION['user_login_status']) AND $_SESSION['user_login_status'] == 1) {

            return true;
        }
        // default return
        return false;
    }
    // Check if user is a Super Admin
    public function isSuperUser()
    {
        if (isset($_SESSION['user_role']) AND $_SESSION['user_role'] == "admin"){

            return true;
        }
        // default return
        return false;
    }
}

index.php has the redirection information

<?php

/**
 * A simple, clean and secure PHP Login Script / MINIMAL VERSION
 *
 * Uses PHP SESSIONS, modern password-hashing and salting and gives the basic functions a proper login system needs.
 *
 * @author Panique
 * @link https://github.com/panique/php-login-minimal/
 * @license http://opensource.org/licenses/MIT MIT License
 */

// checking for minimum PHP version
if (version_compare(PHP_VERSION, '5.3.7', '<')) {
    exit("Sorry, Simple PHP Login does not run on a PHP version smaller than 5.3.7 !");
} else if (version_compare(PHP_VERSION, '5.5.0', '<')) {
    // if you are using PHP 5.3 or PHP 5.4 you have to include the password_api_compatibility_library.php
    // (this library adds the PHP 5.5 password hashing functions to older versions of PHP)
    require_once("libraries/password_compatibility_library.php");
}

// include the configs / constants for the database connection
require_once("config/db.php");

// load the login class
require_once("classes/Login.php");

// create a login object. when this object is created, it will do all login/logout stuff automatically
// so this single line handles the entire login process. in consequence, you can simply ...
$login = new Login();

// ... ask if we are logged in here:
if ($login->isUserLoggedIn() == true) {

    // the user is logged in. you can do whatever you want here.
    // for demonstration purposes, we simply show the "you are logged in" view.
    if ($login->isSuperUser() == true) {
        include("views/su_logged_in.php");

    }else{
        include("views/logged_in.php");
    }



} else {
    // the user is not logged in. you can do whatever you want here.
    // for demonstration purposes, we simply show the "you are not logged in" view.
    include("views/not_logged_in.php");
}

?>

My user table is as following:

  | Uid  | uname  |  name | uemail |  password |  role |

I do not ha seperate table for roles. I did check that for the Super admin the role column has admin string value.

I need the Super Admins to see be redirected to su_logged_in.php. I tried palying with $_SESSION but I guess doing something wrong. I would be grateful for any help. Thank you very much in advance.

  • 写回答

1条回答 默认 最新

  • 普通网友 2017-08-08 08:18
    关注

    may be glitch in your login.php

     public function isSuperUser()
        {
            // here you are comparing $_SESSION['user_role'] == "admin", 
            // question arise here how you are saving user_role in user table , a user role ID or user role string like  "admin"
            // if its string , then your code is clean
            // if it role ID then, compare with super user role ID like below comment
            // if (isset($_SESSION['user_role']) AND $_SESSION['user_role'] == 1){
            if (isset($_SESSION['user_role']) AND trim($_SESSION['user_role']) == "admin"){
    
                return true;
            }
            // default return
            return false;
        }
    

    on more error in your login.php,

    if ($_POST['user_password'] == $result_row->password) {
                            // write user data into PHP SESSION (a file on your server)
                            $_SESSION['user_name'] = $result_row->username;
                            $_SESSION['user_email'] = $result_row->uemail;
                            $_SESSION['user_login_status'] = 1;
                            $_SESSION['user_role'] = $result_row->role; // here was SESSION case issue
    
                        }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 机器学习能否像多层线性模型一样处理嵌套数据
  • ¥20 西门子S7-Graph,S7-300,梯形图
  • ¥50 用易语言http 访问不了网页
  • ¥50 safari浏览器fetch提交数据后数据丢失问题
  • ¥15 matlab不知道怎么改,求解答!!
  • ¥15 永磁直线电机的电流环pi调不出来
  • ¥15 用stata实现聚类的代码
  • ¥15 请问paddlehub能支持移动端开发吗?在Android studio上该如何部署?
  • ¥20 docker里部署springboot项目,访问不到扬声器
  • ¥15 netty整合springboot之后自动重连失效