Caputre Time in/out

[techgirl]

Is there a way to capture the login/out time for each member on my site? They have to login to use most functions. They don't have to log out.

[alyaly]

You can put in two date/time fields and this should store the user's login/out info.

[surreality]

I take it you want to do something like capture the amount of time a user has stayed logged in? Well, first, like alyaly said, you'll need to make sure your database has the required tables to handle the login/logout date and time info. Then you'll to use PHP to capture the login time and enter it into the database. Something a little like this:

PHP Code:

$login_date = date("Y-m-d h:i:s"); 
$sql = "UPDATE ".$tbl_name." SET lastLogin='".$login_date()"' WHERE userid=username";
$result = mysql_query($sql) or die(mysql_error()); 


You'll have to make changes where necessary, of course, but you get the idea.

[Dawnsday]

Originally Posted by surreality

I take it you want to do something like capture the amount of time a user has stayed logged in? Well, first, like alyaly said, you'll need to make sure your database has the required tables to handle the login/logout date and time info. Then you'll to use PHP to capture the login time and enter it into the database. Something a little like this:

PHP Code:

$login_date = date("Y-m-d h:i:s"); 
$sql = "UPDATE ".$tbl_name." SET lastLogin='".$login_date()"' WHERE userid=username";
$result = mysql_query($sql) or die(mysql_error()); 


You'll have to make changes where necessary, of course, but you get the idea.

Exactly what I've been looking for myself. Thanks a lot for posting the code. I'm going to give this a try and see how well it works for me.

[techgirl]

Originally Posted by surreality

I take it you want to do something like capture the amount of time a user has stayed logged in? Well, first, like alyaly said, you'll need to make sure your database has the required tables to handle the login/logout date and time info. Then you'll to use PHP to capture the login time and enter it into the database. Something a little like this:

PHP Code:

$login_date = date("Y-m-d h:i:s"); 
$sql = "UPDATE ".$tbl_name." SET lastLogin='".$login_date()"' WHERE userid=username";
$result = mysql_query($sql) or die(mysql_error()); 


You'll have to make changes where necessary, of course, but you get the idea.

Got'cha Surreality. I was thinking along these lines but was still too unsure to give it a try on my own.Thanks for the help.

[Jenny Walker]

Personally, I prefer just using a pre-made script or CMS to do things like this for me. I'm no PHP expert, so I can't really change the code much without messing things up. >_<

[Shane Phillips]

Originally Posted by Jenny Walker

Personally, I prefer just using a pre-made script or CMS to do things like this for me. I'm no PHP expert, so I can't really change the code much without messing things up. >_<

CMS should work for you.

Regards,

Shane Phillips