login using sessionid or time

ravi951

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.....

DrRakha

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

ravi951

i need to store in my database

DrRakha

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.

ravi951

how it will store the time in the database

DrRakha

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();
 

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka

login using sessionid or time

Topic Tags