auto log out php

---

auto log out php

After log in,You may have seen auto log out after few mints of time.First you have to log in.So I have created simple log in form and database table for check in users details correct or not.Here I have set only 5 second time for auto log out to check your script as earliest. 

CREATE TABLE IF NOT EXISTS `members` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `username` varchar(65) NOT NULL DEFAULT '',
  `password` varchar(65) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`id`, `username`, `password`) VALUES
(1, 'upul', 'upul123');

<table bgcolor=#d2dbf1 align="center"> <form name="form1" method="post" action="checklogin.php"> <tr> <td colspan="3"><strong>Member Login </strong></td> </tr> <tr> <td width="78">Username</td> <td width="6">:</td> <td width="294"><input name="myusername" type="text" id="myusername"></td> </tr> <tr> <td>Password</td> <td>:</td> <td><input name="mypassword" type="text" id="mypassword"></td> </tr> <tr> <td>&nbsp;</td> <td>&nbsp;</td> <td><input type="submit" name="Submit" value="Login"></td> </tr> </table> </td> </form> </tr> </table>

checklogin.php

<?php session_start(); $host="localhost"; $username="root"; $password=""; $db_name="my_database"; $tbl_name="members"; mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql); $count=mysql_num_rows($result); if($count==1){ session_register("myusername"); session_register("mypassword"); header("location:login_success.php"); } else { echo "Wrong Username or Password"; } ?>

login_success.php

<?php header('Refresh: 5; URL=login.php'); ?> <?php session_start();    echo " welcome".$myusername;     $inactive = 500;     // check to see if $_SESSION['timeout'] is set     if(isset($_SESSION['timeout']) ) {     $session_life = time() - $_SESSION['start'];     if($session_life > $inactive)     { session_destroy(); header("Location: page6.php"); }     }     $_SESSION['timeout'] = time(); ?>