login using sessionid or time

Save the login date to database with session id:
i have written a code in php using sessions.below is the code......

Code:


<?php
if(!isset($_SESSION)) 
{
 session_start();
}
$now = time();
$limit = $now;
if(isset($_SESSION['last_activity']) && ($_SESSION['last_activity'] < $limit)) 
{
 $_SESSION = array();
 header('Location:logout.php');
 exit;
} 
else 
{
//the current time
$_SESSION['last_activity'] = $now;
}
?>


.
tell me how to modify in the above code that if the user is entering for first
time then using time() or sessionid it should be stored
or else if he is entering for first time then using current time() or sessionid
it must be stored.....

you want to save first time login date ! , you have to save such information in database or text file which i don't recommend.

i need to store in my database

Code:


<?php
  $hostname="localhost";
  $username="username";
  $password="password";
 
  $dbconnection= mysql_connect ($hostname, $username, $password);
 
  if (!$dbconnection) {
     die (" cannot connect to database");
  }
 
  $result=mysql_select_db ("databasename");
 
  if (! $result) {
     die ("database could not be selected");
  }
     
  echo "Database ready.";
?>


Code:


  $query_res = mysql_query( "SELECT * from tableName" );
 

you may create a data column in users table , if its first time , store the time , any new visits check this column value , it null so its new visit , else it is not and do nothing.

how it will store the time in the database

It is easy like other PHP variables :

Code:


         $date = date("Y-m-d H:i:s"); 
         $query =" INSERT INTO `user` VALUES (0,null,'$country_code','$username','$firstname','$lastname','$password','
$address1',
'$address2','$telephone','$mobile','$email','$city',0,'$date','$date','$date_birthday','$gender',0,'$activationkey',0)";
         $result =mysql_query($query );
         echo mysql_error();