回显多个用户详细信息值 [英] Echo multiple user details values
问题描述
我有一个非常简单的登录系统,一旦登录,它就会根据对各自索引"文件的访问权限重定向该用户.
我想做的是在用户登录基本索引文件后显示用户详细信息.现在,我只能显示用户名"
我希望能够显示例如的多个会话回声;
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'];?> | EMPID: <?=$_SESSION['empid'];?> | 名字:<?=$_SESSION['firstname'];?> | 姓氏:<?=$_SESSION['lastname'];?> | </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 = ' ';如果(访问::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 = ' ';如果(访问::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']; ?> |
EMPID: <?=$_SESSION['empid']; ?> |
First Name: <?=$_SESSION['firstname']; ?> |
Last Name: <?=$_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 {} ?>
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 = ' ';
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 = ' ';
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屋!