author: Anonymous date: 2009-02-24 08:56:44
title: Re: Update user last login time

//updates last login time
$USER_ID = $_SESSION[ 'USER_ID' ];
$last_login = gmdate("Y-m-d");
$sql = "UPDATE somedb.users SET last_login = '$last_login' WHERE id = '$USER_ID'";
$result = @mysql_query($sql,$connection) or die(mysql_error());

author: bvladimirov
site: http://bvladimirov.bulboard.com/
date: 2009-02-24 08:58:26
title: Re: Update user last login time

<?
include('incs/db_connect.php');
$logintime = date("mdy H:m:s");
$query = "SELECT * from users where (name = '$name' and password = password('$mypassword'))";
$result = mysqlquery($db_name,$query) ;
if(!empty($result)) {
if (mysql_numrows($result) == 0)
{ 
print "Bad username password.";
} else {
$name = mysql_result($result,0,"name");
$password = mysql_result($result,0,"password");
$password = md5($password);

// Update the last time the user logged in...
// 
$query = "UPDATE users set lastlogin = '$logintime' where name = '$name'";
$result = mysqlquery($db_name,$query) ;
if(!empty($result)) {
//
}else {
// echo mysql_error() . "<br>\n";
}
header("Location: ./phpscriptname.php");
}
//
}else {
// echo mysql_error() . "<br>\n";
} 
?>