Fleet Member Login
if (isset($_SESSION['valid_member']))
{
$usrnm = $_SESSION['valid_member'];
$conn = mysql_connect("localhost", "HBdbAdmin", "PHRF0wner") or die(mysql_error());
mysql_select_db("hbphrf",$conn) or die(mysql_error());
$lquery = "select member_no, username, password, last_login from phrf_logins where member_no ='$usrnm' and password ='$password'";
$lresult = mysql_query($lquery, $conn) or die(mysql_error());
$num_result = mysql_num_rows($lresult);
if ($num_result >0 )
{
while ($array = mysql_fetch_array($lresult)) {
$id = $array['member_no'];
$usr = $array['username'];
$pass = $array['password'];
$login = $array['last_login'];
}
}
// check for first login DOESN't WORK!!
if ($login < 1) {
$display_block = "";
print $display_block;
mysql_query("update phrf_logins set last_login = now() where member_no ='$usrnm'");
exit;
}
mysql_query("update phrf_logins set last_login = now() where member_no ='$usrnm'");
header('Location:member_functions.php');
}
else
{
if (isset($usrnm))
{
// if they've tried and failed to log in
$display_block = "Could not log you in - please try again
";
}
else
{
// they have not tried to log in yet or have logged out
$display_block = "You are not logged in, please login to proceed.
";
}
// provide form to log in
$display_block = "";
print $display_block;
}
?>