I want to count when user login

ahchim

I want to count the each user login when they login successful, I have already add the field of 'count' in my DB, but i don't know how to use the count function when the user login, anyone can help me to solve?

Here the code of the login page, please help me. 🙁

<?php require_once('Connections/libcn.php'); ?>
<?php
// *** Validate request to login to this site.
session_start();

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($accesscheck)) {
  $GLOBALS['PrevUrl'] = $accesscheck;
  session_register('PrevUrl');
}

if (isset($_POST['login'])) {
  $loginUsername=$_POST['login'];
  $password=$_POST['password'];
  $MM_fldUserAuthorization = "level";
  $MM_redirectLoginSuccess = "main.php";
  $MM_redirectLoginFailed = "accessdenied.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_libcn, $libcn);

  $LoginRS__query=sprintf("SELECT logid, password, level, count FROM data WHERE logid='%s' AND password='%s'",
  get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); 

  $LoginRS = mysql_query($LoginRS__query, $libcn) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
	$loginStrGroup  = mysql_result($LoginRS,0,'level');
    $count = $count+1;

//declare two session variables and assign them
$GLOBALS['MM_Username'] = $loginUsername;
$GLOBALS['MM_UserGroup'] = $loginStrGroup;


//register the session variables
session_register("MM_Username");
session_register("MM_UserGroup");

if (isset($_SESSION['PrevUrl']) && false) {
  $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
}
header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>

Roger_Ramjet

$query = "UPDATE data SET count = count+1 WHERE logid = $loginUserName";

ahchim

Sorry, I have add your code but it doesn't work.
Where should I add?

Roger_Ramjet

It is a basic update query to increment the count by one in the count column. If it does not work as I have written it, that would be because the column or table name is wrong. Substitute the names you have.

You add it after you have verified the user login - where you have your $count=$count+1

  $LoginRS = mysql_query($LoginRS__query, $libcn) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
	$loginStrGroup  = mysql_result($LoginRS,0,'level');
        $updateQuery = "UPDATE data SET count = count+1 WHERE logid = $loginUserName";  

        $countLogin = mysql_query($updateQuery);

// remember to use YOUR table and column names

ahchim

Roger Ramjet wrote:
It is a basic update query to increment the count by one in the count column. If it does not work as I have written it, that would be because the column or table name is wrong. Substitute the names you have.

You add it after you have verified the user login - where you have your $count=$count+1
  $LoginRS = mysql_query($LoginRS__query, $libcn) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
	$loginStrGroup  = mysql_result($LoginRS,0,'level');
        $updateQuery = "UPDATE data SET count = count+1 WHERE logid = $loginUserName";  

        $countLogin = mysql_query($updateQuery);

// remember to use YOUR table and column names

I have change the field name of your code already, but still can't work? Any things I still need to do?

  $LoginRS = mysql_query($LoginRS__query, $dbcn) or die(mysql_error());

  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {

$loginStrGroup  = mysql_result($LoginRS,0,'level');
$updateQuery = "UPDATE data SET count = count+1 WHERE logid = $loginUsername";   
$count = mysql_query($updateQuery);

Roger_Ramjet

Well, you could try using the correct process for user input just as you do in your original check login query, ie addslashes/quote the string etc. Personally, I would use mysql_real_escape_string instead of addslashes as well. If you are using the code you've posted then it's not going to work at all now is it? And you obviously know why.

ahchim

Roger Ramjet wrote:
Well, you could try using the correct process for user input just as you do in your original check login query, ie addslashes/quote the string etc. Personally, I would use mysql_real_escape_string instead of addslashes as well. If you are using the code you've posted then it's not going to work at all now is it? And you obviously know why.

the addslashes function just the dreamweaver add it, I don't know how to use other code because I'm newbie. So, I don't know how to change the code to work.
Ah...... :xbones: