回显多个用户详细信息值 [英] Echo multiple user details values

查看：44
本文介绍了回显多个用户详细信息值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我有一个非常简单的登录系统，一旦登录，它就会根据对各自索引"文件的访问权限重定向该用户.

我想做的是在用户登录基本索引文件后显示用户详细信息.现在，我只能显示用户名"

我希望能够显示例如的多个会话回声；

empid名姓

等等……

这是我的数据库架构

区域公司日期_激活date_deactivated电子邮件空的名全名团体IDis_adminis_deleted姓last_login_iplast_login_timestamp经理手机号码密码记录地位用户名

我在哪里

这就是索引文件输出的全部内容

用户名:SuperAdmin |EMPID: |名字: |姓氏: |

index.php

 <?php if ( $pinAPP->can_access() ) { ?><!-- 新员工--><中心><div class="面板"><div><b>用户名:<?= $_SESSION['username'];?>&nbsp;|&nbsp;EMPID: <?=$_SESSION['empid'];?>&nbsp;|&nbsp;名字:<?=$_SESSION['firstname'];?>&nbsp;|&nbsp;姓氏:<?=$_SESSION['lastname'];?>&nbsp;|&nbsp;</b><br><br><p>您将在下方找到有关入职流程所需的所有必要信息.</p><br><br>

<?php } else {} ?>

访问

is_logged() )返回假；$u = 新用户();$db = 新 DB();$db->query("UPDATE `".DBPREFIX ."users` SET `last_login_timestamp` = '".time() ."' WHERE `id`='". $u->info()->ID ."'");}///////////最终公共函数 is_logged( $require_admin_access = false ) {如果 (!isset($_SESSION[LOGINSESSION]))返回假；self::$auth = true;如果( $require_admin_access ){$u = 新用户();如果 ( ! $u->is_admin() )新重定向(DEFAULT_RETURN_URL)；}返回 self::$auth;}//////////最终私有函数 not_logged() {$url = 新网址；if ( $url->this() != URL.'/' )新重定向(URL)；}最终公共函数注销( $goto = false ){如果(！MULTI_LOGIN && MULTI_LOGIN_RESET_TIMER){$u = 新用户();$db = 新 DB();$db->query("UPDATE `". DBPREFIX ."users` SET `last_login_timestamp` = '". (time() - SESSION_LIFETIME) ."' WHERE `id`='". $u->info()-> id ."'");}未设置($_SESSION[登录])；$goto = ( $goto ) ?$goto : 网址;新重定向($goto)；}最终公共函数登录( $id, $url = false, $username,$empid,$firstname,$lastname ) {$_SESSION[登录] = $id;$_SESSION['username'] = $username;$_SESSION['empid'] = $empid;$_SESSION['firstname'] = $firstname;$_SESSION['lastname'] = $lastname;如果( $url )新重定向(urldecode($url))；别的新重定向(URL)；}//final public function login( $id, $url = false, $username ) {//$_SESSION[登录] = $id;//$_SESSION['username'] = $username;////如果 ( $url )//新重定向(urldecode($url));//     别的//新重定向(URL);//}最终的公共函数 require_login() {如果 ( !self::is_logged(true) )self::not_logged();}}

模型/登录

<?php$error = '&nbsp;';如果(访问::is_logged(真))new Redirect('../admin/?page=index');如果 ( isset($_POST['用户名']) ) {$sql = 新数据库();$ip = $sql->secure($_SERVER['REMOTE_ADDR']);$user = $sql->secure($_POST['username']);$pass = md5($_POST['密码']);$u = $sql->sqls("SELECT `id`,`username`, `fullname`, `status`, `is_admin`, `last_login_ip`, `last_login_timestamp` FROM `". DBPREFIX ."users` WHERE `username`='$user' AND `password`='$pass'");如果(！$u)$error = '登录信息错误！请再试一次...';elseif ( $u->status == 0 && $u->is_admin <1 )$error = '账户未激活！';elseif ( $u->status == 2 && $u->is_admin <1 )$error = '账户被锁定！';elseif ( $u->status == 3 && $u->is_admin <1 )$error = '账户已停用！';elseif ( !MULTI_LOGIN && $u->last_login_ip != $ip && ($u->last_login_timestamp + SESSION_LIFETIME) > time() )$error = str_replace('{%IP%}', $u->last_login_ip, MULTI_LOGIN_MESSAGE);别的 {$u = $sql->sqls("SELECT `id`,`username`,`empid`,`firstname`,`lastname` `fullname`, `status`, `is_admin`, `last_login_ip`, `last_login_timestamp`FROM `". DBPREFIX ."users` WHERE `username`='$user' AND `password`='$pass'");$sql->query("UPDATE `". DBPREFIX ."users` SET `last_login_ip` = '". $ip ."', `last_login_timestamp` = '".time() ."' WHERE `username`='$用户'");Access::login(md5($u->username), $_REQUEST['return_url'], $_POST['username'], $_POST['empid'],$_POST['firstname'],$_POST['姓']);//$sql->query("UPDATE `".DBPREFIX ."users` SET `last_login_ip` = '". $ip ."', `last_login_timestamp` = '".time() ."' WHERE `username`='$用户'");//Access::login(md5($u->username), $_REQUEST['return_url'], $_POST['username']);//$userRow = $sql->sqls("SELECT * FROM `".DBPREFIX ."users` WHERE `username`='$user'");//访问::登录(md5($u->用户名), $_REQUEST['return_url'],$userRow);}}$this->add_option('error', $error);

我在哪里

我的 index.php 文件

 <?php include('header.php');?><?php require_once('../admin/pinAPP.php');$pinAPP = new pinAPP( 'newhire', false, false, true );?><?php if ( $pinAPP->can_access() ) { ?><!-- 新员工--><中心><div class="面板"><div><b>欢迎{<?= $_SESSION['username'];?>}{<?= $_SESSION['firstname'];?>},<?= $_SESSION['姓氏'];?></b><br><br><p>您将在下方找到有关入职流程所需的所有必要信息.</p><br><br>

<?php } else {} ?><!-- --><?php include('footer.php');?>

我的访问类

is_logged() )返回假；$u = 新用户();$db = 新 DB();$db->query("UPDATE `".DBPREFIX ."users` SET `last_login_timestamp` = '".time() ."' WHERE `id`='". $u->info()->ID ."'");}///////////最终公共函数 is_logged( $require_admin_access = false ) {如果 (!isset($_SESSION[LOGINSESSION]))返回假；self::$auth = true;如果( $require_admin_access ){$u = 新用户();如果 ( ! $u->is_admin() )新重定向(DEFAULT_RETURN_URL)；}返回 self::$auth;}//////////最终私有函数 not_logged() {$url = 新网址；if ( $url->this() != URL.'/' )新重定向(URL)；}最终公共函数注销( $goto = false ){如果(！MULTI_LOGIN && MULTI_LOGIN_RESET_TIMER){$u = 新用户();$db = 新数据库()；$db->query("UPDATE `". DBPREFIX ."users` SET `last_login_timestamp` = '". (time() - SESSION_LIFETIME) ."' WHERE `id`='". $u->info()-> id ."'");}未设置($_SESSION[登录])；$goto = ( $goto ) ?$goto : 网址;新重定向($goto)；}最终公共函数登录( $id, $url = false, $username ){$_SESSION[登录] = $id;$_SESSION['username'] = $username;如果( $url )新重定向(urldecode($url))；别的新重定向(URL)；}最终的公共函数 require_login() {如果 ( !self::is_logged(true) )self::not_logged();}}

获取用户详细信息的登录文件.

<?php$error = '&nbsp;';如果(访问::is_logged(真))new Redirect('../admin/?page=index');如果 ( isset($_POST['用户名']) ) {$sql = 新数据库();$ip = $sql->secure($_SERVER['REMOTE_ADDR']);$user = $sql->secure($_POST['username']);$pass = md5($_POST['密码']);$u = $sql->sqls("SELECT `id`,`username`, `fullname`, `status`, `is_admin`, `last_login_ip`, `last_login_timestamp` FROM `". DBPREFIX ."users` WHERE `username`='$user' AND `password`='$pass'");如果(！$u)$error = '登录信息错误！请再试一次...';elseif ( $u->status == 0 && $u->is_admin <1 )$error = '账户未激活！';elseif ( $u->status == 2 && $u->is_admin <1 )$error = '账户被锁定！';elseif ( $u->status == 3 && $u->is_admin <1 )$error = '账户已停用！';elseif ( !MULTI_LOGIN && $u->last_login_ip != $ip && ($u->last_login_timestamp + SESSION_LIFETIME) > time() )$error = str_replace('{%IP%}', $u->last_login_ip, MULTI_LOGIN_MESSAGE);别的 {$sql->query("UPDATE `". DBPREFIX ."users` SET `last_login_ip` = '". $ip ."', `last_login_timestamp` = '".time() ."' WHERE `username`='$用户'");Access::login(md5($u->username), $_REQUEST['return_url'], $_POST['username'], $_POST['fullname']);}}$this->add_option('error', $error);

感谢您的宝贵时间，并感谢您的帮助.

-李维

解决方案

第一个变化.获取用户详细信息的登录文件.

改变我给的行

$u = $sql->sqls("SELECT `id`,`username`,`empid`,`firstname`,`lastname` `fullname`, `status`, `is_admin`, `last_login_ip`, `last_login_timestamp`FROM `". DBPREFIX ."users` WHERE `username`='$user' AND `password`='$pass'");别的 {$sql->query("UPDATE `". DBPREFIX ."users` SET `last_login_ip` = '". $ip ."', `last_login_timestamp` = '".time() ."' WHERE `username`='$用户'");Access::login(md5($u->username), $_REQUEST['return_url'], $_POST['username'],$u->empid,$u->firstname,$u->姓);}

我的访问类

 final public function login( $id, $url = false, $username,$empid,$firstname,$lastname ) {$_SESSION[登录] = $id;$_SESSION['username'] = $username;$_SESSION['empid'] = $empid;$_SESSION['firstname'] = $firstname;$_SESSION['lastname'] = $lastname;如果( $url )新重定向(urldecode($url))；别的新重定向(URL)；}

现在你可以回应这个

 $_SESSION['用户名']$_SESSION['empid']$_SESSION['名字']$_SESSION['姓氏']

确保每当您调用登录方法时，此参数都应该在那里.

I have a pretty simple login system that will once logged in it will redirect that user based off of a access permission to their respective 'index' file.

What I would like to do is display the user details after they have logged in on the basic index file. Right now, I can only show the 'username'

I would like to be able to display multiple session echos of for example;

empid
firstname
lastname

so on and so forth...

Here is my DB Schema

Area
Company
date_activated
date_deactivated
email
empid
FirstName
FullName
groups
id
is_admin
is_deleted
LastName
last_login_ip
last_login_timestamp
manager
MobileNumber
password
record
status
username

WHERE I AM

This is all that is outputted from the index file 

Username: SuperAdmin |  EMPID:  |  First Name:  |  Last Name:  |

index.php

      <?php require_once('../admin/pinAPP.php'); $pinAPP = new pinAPP( 'newhire', false, false, true ); ?>
<?php if ( $pinAPP->can_access() ) { ?><!-- New hire -->
    <center>
        <div class="panel">
                    <div>

                            <b> Username:   <?=  $_SESSION['username']; ?>&nbsp;|&nbsp; 
                                EMPID:      <?=$_SESSION['empid']; ?>&nbsp;|&nbsp;
                                First Name: <?=$_SESSION['firstname']; ?>&nbsp;|&nbsp;
                                Last Name:  <?=$_SESSION['lastname']; ?>&nbsp;|&nbsp;
                            </b>
                        <br>
                        <br>
                            <p>Below you will find all the necessary information on needed for onboarding process.</p>                  
                        <br> 
                        <br>
                    </div>
<?php } else {} ?>

Access

<?php
    class Access {
        private static $auth = false;

        final public function __construct() {
            if ( ! $this->is_logged() )
                return false;

            $u = new User();
            $db = new DB();

            $db->query("UPDATE `". DBPREFIX ."users` SET `last_login_timestamp` = '". time() ."' WHERE `id`='". $u->info()->id ."'");
        }
    ///////////
        final public function is_logged( $require_admin_access = false ) {
            if ( ! isset($_SESSION[LOGINSESSION]) )
                return false;

            self::$auth = true;

            if ( $require_admin_access ) {
                $u = new User();
                if ( ! $u->is_admin() )
                    new Redirect(DEFAULT_RETURN_URL);
            }

            return self::$auth;
        }
    //////////
        final private function not_logged() {
            $url = new URL;
            if ( $url->this() != URL.'/' )
                new Redirect(URL);
        }

        final public function logout( $goto = false ) {
            if ( ! MULTI_LOGIN && MULTI_LOGIN_RESET_TIMER ) {
                $u = new User();
                $db = new DB();

                $db->query("UPDATE `". DBPREFIX ."users` SET `last_login_timestamp` = '". (time() - SESSION_LIFETIME) ."' WHERE `id`='". $u->info()->id ."'");
            }

            unset($_SESSION[LOGINSESSION]);

            $goto = ( $goto ) ? $goto : URL;
            new Redirect($goto);
        }

final public function login( $id, $url = false, $username,$empid,$firstname,$lastname ) {
            $_SESSION[LOGINSESSION] = $id;
            $_SESSION['username'] = $username;
            $_SESSION['empid'] = $empid;
            $_SESSION['firstname'] = $firstname;
            $_SESSION['lastname'] = $lastname;

            if ( $url )
                new Redirect(urldecode($url));
            else
                new Redirect(URL);
        }


//final public function login( $id, $url = false, $username ) {
 //       $_SESSION[LOGINSESSION] = $id;
 //       $_SESSION['username'] = $username;
//
 //       if ( $url )
  //          new Redirect(urldecode($url));
  //      else
  //          new Redirect(URL);
  //  }



        final public function require_login() {
            if ( ! self::is_logged(true) )
                self::not_logged();
        }
    }

Model/login

<!-- model/login -->
<?php
$error = '&nbsp;';

if ( Access::is_logged(true) )
    new Redirect('../admin/?page=index');

if ( isset($_POST['username']) ) {
    $sql = new DB();
    $ip = $sql->secure($_SERVER['REMOTE_ADDR']);

    $user = $sql->secure($_POST['username']);
    $pass = md5($_POST['password']);

    $u = $sql->sqls("SELECT `id`,`username`, `fullname`, `status`, `is_admin`, `last_login_ip`, `last_login_timestamp` FROM `". DBPREFIX ."users` WHERE `username`='$user' AND `password`='$pass'");

    if ( ! $u )
        $error = 'The login information is wrong! Please try again...';

    elseif ( $u->status == 0 && $u->is_admin < 1 )
        $error = 'The account is not activated!';

    elseif ( $u->status == 2 && $u->is_admin < 1 )
        $error = 'The account is LOCKED!';

    elseif ( $u->status == 3 && $u->is_admin < 1 )
        $error = 'The account is Deactivated!';

    elseif ( ! MULTI_LOGIN && $u->last_login_ip != $ip && ($u->last_login_timestamp + SESSION_LIFETIME) > time() )
        $error = str_replace('{%IP%}', $u->last_login_ip, MULTI_LOGIN_MESSAGE);

    else {
$u = $sql->sqls("SELECT `id`,`username`,`empid`,`firstname`,`lastname` `fullname`, `status`, `is_admin`, `last_login_ip`, `last_login_timestamp` FROM `". DBPREFIX ."users` WHERE `username`='$user' AND `password`='$pass'");
$sql->query("UPDATE `". DBPREFIX ."users` SET `last_login_ip` = '". $ip ."', `last_login_timestamp` = '". time() ."' WHERE `username`='$user'");
Access::login(md5($u->username), $_REQUEST['return_url'], $_POST['username'], $_POST['empid'],$_POST['firstname'],$_POST['lastname']);

//$sql->query("UPDATE `". DBPREFIX ."users` SET `last_login_ip` = '". $ip ."', `last_login_timestamp` = '". time() ."' WHERE `username`='$user'");
//Access::login(md5($u->username), $_REQUEST['return_url'], $_POST['username']);

//$userRow = $sql->sqls("SELECT * FROM `". DBPREFIX ."users` WHERE `username`='$user'");
//Access::login(md5($u->username), $_REQUEST['return_url'],$userRow);
    }
}

$this->add_option('error', $error);

WHERE I WAS

my index.php file

    <?php include('header.php'); ?>

 <?php require_once('../admin/pinAPP.php'); $pinAPP = new pinAPP( 'newhire', false, false, true ); ?>
<?php if ( $pinAPP->can_access() ) { ?><!-- New hire -->
    <center>
        <div class="panel">
                    <div>

                            <b>Welcome {<?= $_SESSION['username']; ?>}{<?= $_SESSION['firstname']; ?>},<?= $_SESSION['lastname']; ?></b>
                        <br>
                        <br>
                            <p>Below you will find all the necessary information on needed for onboarding process.</p>                  
                        <br> 
                        <br>
                    </div>
<?php } else {} ?>

<!-- -->

<?php include('footer.php'); ?>

my Access Class

<?php
    class Access {
        private static $auth = false;

        final public function __construct() {
            if ( ! $this->is_logged() )
                return false;

            $u = new User();
            $db = new DB();

            $db->query("UPDATE `". DBPREFIX ."users` SET `last_login_timestamp` = '". time() ."' WHERE `id`='". $u->info()->id ."'");
        }
    ///////////
        final public function is_logged( $require_admin_access = false ) {
            if ( ! isset($_SESSION[LOGINSESSION]) )
                return false;

            self::$auth = true;

            if ( $require_admin_access ) {
                $u = new User();
                if ( ! $u->is_admin() )
                    new Redirect(DEFAULT_RETURN_URL);
            }

            return self::$auth;
        }
    //////////
        final private function not_logged() {
            $url = new URL;
            if ( $url->this() != URL.'/' )
                new Redirect(URL);
        }

        final public function logout( $goto = false ) {
            if ( ! MULTI_LOGIN && MULTI_LOGIN_RESET_TIMER ) {
                $u = new User();
                $db = new DB();

                $db->query("UPDATE `". DBPREFIX ."users` SET `last_login_timestamp` = '". (time() - SESSION_LIFETIME) ."' WHERE `id`='". $u->info()->id ."'");
            }

            unset($_SESSION[LOGINSESSION]);

            $goto = ( $goto ) ? $goto : URL;
            new Redirect($goto);
        }

final public function login( $id, $url = false, $username ) {
        $_SESSION[LOGINSESSION] = $id;
        $_SESSION['username'] = $username;

        if ( $url )
            new Redirect(urldecode($url));
        else
            new Redirect(URL);
    }

        final public function require_login() {
            if ( ! self::is_logged(true) )
                self::not_logged();
        }
    }

my login file that gets users details.

<!-- model/login -->
<?php
$error = '&nbsp;';

if ( Access::is_logged(true) )
    new Redirect('../admin/?page=index');

if ( isset($_POST['username']) ) {
    $sql = new DB();
    $ip = $sql->secure($_SERVER['REMOTE_ADDR']);

    $user = $sql->secure($_POST['username']);
    $pass = md5($_POST['password']);

    $u = $sql->sqls("SELECT `id`,`username`, `fullname`, `status`, `is_admin`, `last_login_ip`, `last_login_timestamp` FROM `". DBPREFIX ."users` WHERE `username`='$user' AND `password`='$pass'");

    if ( ! $u )
        $error = 'The login information is wrong! Please try again...';

    elseif ( $u->status == 0 && $u->is_admin < 1 )
        $error = 'The account is not activated!';

    elseif ( $u->status == 2 && $u->is_admin < 1 )
        $error = 'The account is LOCKED!';

    elseif ( $u->status == 3 && $u->is_admin < 1 )
        $error = 'The account is Deactivated!';

    elseif ( ! MULTI_LOGIN && $u->last_login_ip != $ip && ($u->last_login_timestamp + SESSION_LIFETIME) > time() )
        $error = str_replace('{%IP%}', $u->last_login_ip, MULTI_LOGIN_MESSAGE);

    else {
$sql->query("UPDATE `". DBPREFIX ."users` SET `last_login_ip` = '". $ip ."', `last_login_timestamp` = '". time() ."' WHERE `username`='$user'");
Access::login(md5($u->username), $_REQUEST['return_url'], $_POST['username'], $_POST['fullname']);


    }
}

$this->add_option('error', $error);

Thank you for your time, and appreciate any help.

-Levi

解决方案

First change in this. my login file that gets users details.

change lines what i have given 

<!-- model/login -->

$u = $sql->sqls("SELECT `id`,`username`,`empid`,`firstname`,`lastname` `fullname`, `status`, `is_admin`, `last_login_ip`, `last_login_timestamp` FROM `". DBPREFIX ."users` WHERE `username`='$user' AND `password`='$pass'");

else {
$sql->query("UPDATE `". DBPREFIX ."users` SET `last_login_ip` = '". $ip ."', `last_login_timestamp` = '". time() ."' WHERE `username`='$user'");
Access::login(md5($u->username), $_REQUEST['return_url'], $_POST['username'],$u->empid,$u->firstname,$u->lastname);

    }

my Access Class

  final public function login( $id, $url = false, $username,$empid,$firstname,$lastname ) {
            $_SESSION[LOGINSESSION] = $id;
            $_SESSION['username'] = $username;
            $_SESSION['empid'] = $empid;
            $_SESSION['firstname'] = $firstname;
            $_SESSION['lastname'] = $lastname;

            if ( $url )
                new Redirect(urldecode($url));
            else
                new Redirect(URL);
        }

Now you can echo with this

 $_SESSION['username'] 
 $_SESSION['empid'] 
 $_SESSION['firstname'] 
 $_SESSION['lastname']

be sure whenever you are calling login method this parameter should be there.

这篇关于回显多个用户详细信息值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
PHP最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆