javascript-在php中登录我后如何获取上次登录的管理员时间和日期
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了javascript-在php中登录我后如何获取上次登录的管理员时间和日期,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含7402字,纯文字阅读大概需要11分钟。
内容图文
我在数据库中有5个管理员.所以现在我想让最后一个用户登录日期和时间详细信息.在我之前工作过的人.意味着我登录仪表板后,我想查看以前的USER登录以及注销时间和日期.
我可以获得我(当前用户)的登录日期和时间.但是我不知道如何获得以前的用户(管理员)登录和注销日期/时间的详细信息.
我正在发送我的login.php代码.我在哪里写了当前用户的时间/日期代码.请查看代码并给我建议,我如何才能获得以前的用户登录和注销日期/时间.
谢谢.
<?php include "db.php"; ?>
<?php session_start(); ?>
<?php
if(isset($_POST['login'])){
$username = $_POST['username'];
$password = $_POST['password'];
$username = mysqli_real_escape_string($connection,$username);
$password = mysqli_real_escape_string($connection,$password);
$password = md5($password);
$login_query = "SELECT * FROM users WHERE user_username = '$username'" ;
$result_query = mysqli_query($connection,$login_query);
$count = mysqli_num_rows($result_query);
if(!$count){
die("QUERY FAILED". mysqli_error($connection));
}
while($row= mysqli_fetch_array($result_query)){
$log_user_id = $row['user_id'];
$log_user_username = $row['user_username'];
$log_user_password = $row['user_password'];
$log_user_firstname = $row['user_firstname'];
$log_user_lastname = $row['user_lastname'];
$log_user_role = $row['user_role'];
$log_user_time = $row['time'];
$log_user_ip = $row['ip'];
}
if($username !== $log_user_username && $password !== $log_user_password){
header ("location: ../index.php");
}elseif($username == $log_user_username && $password == $log_user_password){
if($count == 1) {
$_SESSION['username']=$log_user_username;
$_SESSION['firstname']=$log_user_firstname;
$_SESSION['lastname']=$log_user_lastname;
$_SESSION['user_role']=$log_user_role;
$_SESSION['last_login'] = $log_user_time;
$_SESSION['last_login_ip'] = $log_user_ip;
date_default_timezone_set("Asia/Kolkata");
$current_date = date("F d, Y, h:i:s A");
$ip = $_SERVER['REMOTE_ADDR'];
$query = "UPDATE users SET time= NOW() ,ip='$ip' WHERE user_username='$username'";
mysqli_query($connection,$query);
$last_login_date = $_SESSION['last_login'];
$last_login_date2 = date('F d, Y, h:i:s A');
$diffs = abs(strtotime($last_login_date2) - strtotime($last_login_date));
$year = floor($diffs / (365*60*60*24));
$month = floor(($diffs - $year * 365*60*60*24) / (30*60*60*24));
$day = floor(($diffs - $year * 365*60*60*24 - $month*30*60*60*24)/ (60*60*24));
$hour = floor(($diffs - $year * 365*60*60*24 - $month*30*60*60*24 - $day*60*60*24)/ (60*60));
$minute = floor(($diffs - $year * 365*60*60*24 - $month*30*60*60*24 - $day*60*60*24 - $hour*60*60)/ 60);
$second = floor(($diffs - $year * 365*60*60*24 - $month*30*60*60*24 - $day*60*60*24 - $hour*60*60 - $minute*60));
if($year == 0 AND $month == 0 AND $day == 0 AND $hour == 0 AND $minute == 0 AND $second < 30 ) {
$time1 = 'Just now';
} elseif($year == 0 AND $month == 0 AND $day == 0 AND $hour == 0 AND $minute == 0 ) {
$time1 = 'few seconds ago';
} elseif($year == 0 AND $month == 0 AND $day == 0 AND $hour == 0 AND $minute == 1) {
$time1 = '1 minute ago';
} elseif($year == 0 AND $month == 0 AND $day == 0 AND $hour == 0 ) {
$time1 = $minute . ' minutes ago';
} elseif($year == 0 AND $month == 0 AND $day == 0 AND $hour == 1 ) {
$time1 = '1 hour ago';
} elseif($year == 0 AND $month == 0 AND $day == 0 ) {
$time1 = $hour . ' hours ago';
} elseif($year == 0 AND $month == 0 AND $day == 1 ) {
$time1 = 'Yesterday';
} elseif($year == 0 AND $month == 0 ) {
$time1 = $day . ' days ago';
} elseif($year == 0 AND $month == 1 ) {
$time1 = '1 month ago';
} elseif($year == 0) {
$time1 = $month . ' months ago';
} elseif($year == 1 ) {
$time1 = '1 year ago';
} else {
$time1 = $year . ' years ago';
}
}
if($_SESSION['last_login_ip'] != $_SERVER['REMOTE_ADDR']) {
$last_login_ip = "from this IP address (".$_SERVER['REMOTE_ADDR'].")";
}
else {
$last_login_ip = "IP address ".$_SESSION['last_login_ip'];
}
}
header ("location: ../admin");
}else{
header ("location: ../index.php");
}
?>
因此,在仪表板(index.php)登录后,页面确实回显了变量,并且可以查看当前用户的登录日期/时间详细信息,这是我的登录详细信息.
请给我建议,我如何获得以前的用户登录和注销详细信息.
谢谢
notification.php
<span class="pull-right text-muted small"><em></em></span></a>
<?php
date_default_timezone_set("Asia/Kolkata");
$last_login_date = date("F d, Y, h:i:s A");
$last_login_date = $_SESSION['last_login'];
$last_login_date2 = date('F d, Y, h:i:s A');
$diffs = abs(strtotime($last_login_date2) - strtotime($last_login_date));
$year = floor($diffs / (365*60*60*24));
$month = floor(($diffs - $year * 365*60*60*24) / (30*60*60*24));
$day = floor(($diffs - $year * 365*60*60*24 - $month*30*60*60*24)/ (60*60*24));
$hour = floor(($diffs - $year * 365*60*60*24 - $month*30*60*60*24 - $day*60*60*24)/ (60*60));
$minute = floor(($diffs - $year * 365*60*60*24 - $month*30*60*60*24 - $day*60*60*24 - $hour*60*60)/ 60);
$second = floor(($diffs - $year * 365*60*60*24 - $month*30*60*60*24 - $day*60*60*24 - $hour*60*60 - $minute*60));
if($year == 0 AND $month == 0 AND $day == 0 AND $hour == 0 AND $minute == 0 AND $second < 30 ) {
$time1 = 'Just now';
} elseif($year == 0 AND $month == 0 AND $day == 0 AND $hour == 0 AND $minute == 0 ) {
$time1 = 'few seconds ago';
} elseif($year == 0 AND $month == 0 AND $day == 0 AND $hour == 0 AND $minute == 1) {
$time1 = '1 minute ago';
} elseif($year == 0 AND $month == 0 AND $day == 0 AND $hour == 0 ) {
$time1 = $minute . ' minutes ago';
} elseif($year == 0 AND $month == 0 AND $day == 0 AND $hour == 1 ) {
$time1 = '1 hour ago';
} elseif($year == 0 AND $month == 0 AND $day == 0 ) {
$time1 = $hour . ' hours ago';
} elseif($year == 0 AND $month == 0 AND $day == 1 ) {
$time1 = 'Yesterday';
} elseif($year == 0 AND $month == 0 ) {
$time1 = $day . ' days ago';
} elseif($year == 0 AND $month == 1 ) {
$time1 = '1 month ago';
} elseif($year == 0) {
$time1 = $month . ' months ago';
} elseif($year == 1 ) {
$time1 = '1 year ago';
} else {
$time1 = $year . ' years ago';
}
if($_SESSION['last_login_ip'] != $_SERVER['REMOTE_ADDR']) {
$last_login_ip = "From this IP address (".$_SERVER['REMOTE_ADDR'].")";
}
else {
$last_login_ip = "IP address ".$_SESSION['last_login_ip'];
}
?>
<a href="#" class="list-group-item">
<i class="fa fa-user"></i> User Name
<span class="pull-right text-muted small"><em><?php echo $_SESSION['username']; ?></em>
</span>
</a>
<a href="#" class="list-group-item">
<i class="fa fa-sign-in"></i> Last Login Time
<span class="pull-right text-muted small"><em><?php echo $time1; ?></em>
</span>
</a>
<a href="#" class="list-group-item">
<i class="fa fa-sign-out"></i> Last Logout Time
<span class="pull-right text-muted small"><em>27 minutes ago</em>
</span>
</a>
<a href="#" class="list-group-item">
<i class="fa fa-tasks fa-fw"></i> User Ip
<span class="pull-right text-muted small"><em><?php echo $last_login_ip; ?></em>
</span>
</a>
我在这里获取管理员登录日期和时间的详细信息.但是我无法获取以前的访客登录详细信息.在这里登录后,我只能看到我的登录时间/日期详细信息.
所以请帮忙.
解决方法:
我可以给你基本的逻辑.在此您可以设置将用作标志的会话变量.
// start session
session_start();
// if not yet logged in update database
if(!isset($_SESSION['logged']))
{
// update your database here
$query = "UPDATE table
SET LastLogin=now()
WHERE ID='$ID'";
$result = mysql_query($query); // etc...
// if the table was updated
if($result === true)
{
// then create a session var
$_SESSION['logged'] = 1;
}
}
要么
您可以在登录时插入用户ID,日期和时间,并将其作为上次登录的最后一个ID取回.
内容总结
以上是互联网集市为您收集整理的javascript-在php中登录我后如何获取上次登录的管理员时间和日期全部内容,希望文章能够帮你解决javascript-在php中登录我后如何获取上次登录的管理员时间和日期所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。