DaniWeb Forum Index > Web Development > PHP

Help with Last Activity Time

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2007

Posts: 71

Reputation: Pro2000 is an unknown quantity at this point

Solved Threads: 1

Pro2000

Offline

Junior Poster in Training

Help with Last Activity Time

Sep 27th, 2007

Peace, I wrote a PHP File Contains a login form, If the user logs in a field will be inserted into the MySQL DataBase, So I want to make an automatic logout after 20 minutes idle.
I wrote:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
session_start();
require("Connecting_Config.php");
$unm=$_SESSION['user_name'];
$current_date=date("i"); //Only Minutes
$gt_lastactivity="select * from logs where Name='$unm'";
$do_gt_lastactivity=mysql_query($gt_lastactivity,$connect);
$arr=mysql_fetch_array($do_gt_lastactivity);
$last_activity_date=$arr['Last_Activity'];
$yyy=$current_date-$last_activity;
if ($yyy>20)
{
          Logout();
}
?>
<?php
session_start();
require("Connecting_Config.php");
$unm=$_SESSION['user_name'];
$current_date=date("i"); //Only Minutes
$gt_lastactivity="select * from logs where Name='$unm'";
$do_gt_lastactivity=mysql_query($gt_lastactivity,$connect);
$arr=mysql_fetch_array($do_gt_lastactivity);
$last_activity_date=$arr['Last_Activity'];
$yyy=$current_date-$last_activity;
if ($yyy>20)
{
          Logout();
}
?>

I tried that and I encountered an error which does a logout to the user if he starts another hour.. Ex: Last_Activity= 59th Minute If he does a refresh in the 1st minute in the next hour it will logout, Who knows how to do that?

The great scientist see his web-site:
http://www.elnaggarzr.com/en
I'm sure that will be good for you!

•

Join Date: Sep 2007

Posts: 270

Reputation: fatihpiristine has a little shameless behaviour in the past

Solved Threads: 16

fatihpiristine fatihpiristine is offline

Offline

Posting Whiz in Training

Re: Help with Last Activity Time

Sep 27th, 2007

try cookies. that might help you. this example from O'Reilly's Learning PHP5 (free: chapter 8)

// The cookie expires one hour from now
setcookie('short-userid','ralph',time( ) + 60*60);
// The cookie expires one day from now
setcookie('longer-userid','ralph',time( ) + 60*60*24);
// The cookie expires at noon on October 1, 2006
setcookie('much-longer-userid','ralph',mktime(12,0,0,10,1,2006));

•

Join Date: Jun 2007

Posts: 71

Reputation: Pro2000 is an unknown quantity at this point

Solved Threads: 1

Pro2000

Offline

Junior Poster in Training

Re: Help with Last Activity Time

Sep 27th, 2007

•

try cookies. that might help you.

Sorry but I know this... I created a menu shows the available users, It gets the names from the mysql database, I need to make it when the user expires 20 minutes it will logout and delete the user name from the available users.

The great scientist see his web-site:
http://www.elnaggarzr.com/en
I'm sure that will be good for you!