if(!$session)
{ if($user&&$pass){ mysql_connect("server", "username", "password"); $q= mysql_query("SELECT * FROM your_database.users WHERE user='$user' AND pass='$pass'"); $n= mysql_num_rows($q);
if($n){ $_SESSION['user'] =$user; mysql_query("UPDATE your_database.users SET status='online' WHERE user='$user'"); //SETS STATUS AS ONLINE session_write_close();
}
else
{ $q= mysql_query("SELECT * FROM your_database.users WHERE user='$user'"); $r= mysql_num_rows($q); if($r){ echo 'Wrong Password <a href="index.php">Go back</a>';
}
else
{ echo 'Email not found <a href="index.php">Go back</a>';
}
}
}
else
{ echo 'Enter both fields <a href="index.php">Go back</a>';
}
}
else
{ header("Location: index.php");
}
?>
logout.php
<?php
session_start(); $user = $_SESSION['user']; if($user)
{ mysql_connect('server', 'username', 'password'); mysql_query("UPDATE yourdatabase.users SET status='offline' WHERE user='$user'");