How to maintain login and logout session time in php


1 maintain login session time with login page code is below


<?php
include "config.php";
session_start();
$count=0;


if(isset($_POST['submit']) and $_POST['submit'] =="Sign In")
{
 $sql ="select * from user where name ='". $_POST['name']."' and password ='". $_POST['password']."'";
$run = mysql_query($sql);
$count=mysql_num_rows($run);
if($count > 0)
{
while($data=mysql_fetch_array($run))
{
 $id = $data['id'];
 $type = $data['type'];
}
$_SESSION['name'] = $_POST['name'];
$_SESSION['id'] = $id;
echo $_SESSION['type'] = $type;

header ("location:index.php");
if($count == 1)
{
echo $_date = date("y/m/d") ;
date_default_timezone_set("Asia/Calcutta"); //India time (GMT+5:30)
echo $_time = date("h:i:sa");
 echo $sql2="insert into userlog (name, date, time, status) values ('".$_POST['name']."', '".$_date."', '".$_time."', 'login'  )";
$row2=mysql_query($sql2);
}
}
else
{
echo  "<font color='red'> Wrong username and password</font>";
}
}
?>
<div class="username">
<span class="username">Username:</span>
<input type="text" name="name" id="name" class="name" placeholder="" required="">
<div class="clearfix"></div>
</div>
<div class="password-agileits">
<span class="username">Password:</span>
<input type="password" name="password" id="password" class="password" placeholder="" required="">
<div class="clearfix"></div>
</div>
<div class="rem-for-agile">
<input type="checkbox" name="remember" class="remember">Remember me<br>
<a href="#">Forgot Password</a><br>
</div>
<div class="login-w3">
<input type="submit" name="submit" id="submit" class="login" value="Sign In">
</div>
<div class="clearfix"></div>
</form>


2 maintain logout session time with logout page code is below


<?php
include 'config.php';
$name='';
 session_start();
echo $name=$_SESSION['name'];

if (isset($_SESSION['name']))
{
unset($_SESSION['name']);
{
echo $_date = date("y/m/d") ;
date_default_timezone_set("Asia/Calcutta"); //India time (GMT+5:30)
echo $_time = date("h:i:sa");
echo $sql2="insert into sahakaar_userlog (name, date, time, status) values ('".$name."', '".$_date."', '".$_time."', 'logout'  )";
$row2=mysql_query($sql2);

}
}

header("location:login.php");
?>





Comments

Popular posts from this blog

How to filter data from database according to client name & date wise in PHP

Captcha Code In PHP