Regarding storing last activity

mpsn · November 17, 2011

Hi, when a user logs out, I want to store the last activity in for the user. I have a db table users:

userID userName userPassword lastSession lastActivity

===== ======= ========== ======== =======

1 bob password 2011-08-09 About.html

2 dre passwords 2011-09-23 Home.php

here is logout script:

===============

<?php
//run this script only if the logout button has been clicked
if(array_key_exists('logout', $_POST)) {
        require("connect.inc");
$username=$_POST["username"];
$updateLastSessionQuery=mysql_query("UPDATE users SET lastSession=NOW() WHERE userName='$username'");

// end session and redirect
//empty the $_SESSION array
    $_SESSION = array();

    session_destroy();
header("Location: xmlShredderLogin.php");  
    exit;
}//END IF for when logout submitted
?>

here is Index.php:

=============

<?php
session_start();
if(isset($_SESSION["isAuthenticated"])) {
require("logout.inc.php");
$username=$_POST["username"];
//print $username."<br />";
print '
<html>
	<head><title>Home</title></head>
	<body>
		<form id="logoutForm" name="logoutForm" method="post" action="">
			<input name="logout" type="submit" id="logout" value="Log out" />
			<input type="hidden" name="usernameHidden" value='; print$username; print '/>
		</form>';
			mysql_connect("localhost","root");
			mysql_select_db("someDB");
			$getUserInfoQuery=mysql_query("SELECT lastSession,lastActivity FROM users WHERE userName='$userName'");
			$getUserInfo=mysql_fetch_assoc($getUserInfoQuery);
			print "Last session: ".$getUserInfo["lastSession"]."<br />";
			print "Last activity: ".$getUserInfo["lastActivity"]."<br />";

Let's say the last page the user is on is Index.php, so what do I use to track the last page they are on?? I can't user a form b/c if I have to type in the last activity, that's nonsense! So far I have only figured out how to store the current time in last session (but this doesn't work either).

I just want to track the last page and then have a switch such as:

switch(type)

case 1:

$lastActivity="About.html";

case 2:

$lastActivity="somethingelse.php";

Any help much appreciated!

MasterACE14 · November 17, 2011

$_SERVER['PHP_SELF'] gets you the current file being accessed.

Sign In

Regarding storing last activity

Recommended Posts

mpsn

Link to comment

Share on other sites

MasterACE14

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information