Jump to content

Need Serious Help with login problems

topflight

By topflight
in PHP Coding Help

Recommended Posts

topflight Regular Member

topflight

Posted
Posted

I am having a serious problem with my login script. My login portion is on the right hand side of my site and when you login that box expands downs and show you the various links it is suppose to show. That's ok. Now when I go to another page like contact us or something the login links doesn't show and and goes back to the login form. I want to have it set up so that it will always show the login link until you click logout. I am using sessions. I also know that the sessions are registering because some pages require that the session mu be true or you can't view them and I know they are registering because when I try to view them without being logged in it tells me I must be login to view this pages like it is suppose to. But once agin the main problem is that I am trying to figure out how to make the login content/links stay unless the user does not click logout. This is my code.

<?php
session_start();
?>

<?php
if(isset($_POST['user']))
{
//Include Config File For DB info..
include 'db.php';
//Connect TO The MySQL Server
$connect = mysql_connect($db_host,$db_username,$db_password)
  or die("MySQL Said:".mysql_error());
  
$database = mysql_select_db($db_database,$connect)
  or die("MySQl Said:".mysql_error());
  
$login = mysql_real_escape_string($_POST['user']);
$pwd = mysql_real_escape_string($_POST['pwd']);

$link = mysql_query("SELECT * FROM `pilots` where login='$login' and pwd='$pwd'")
  or die("MySQL Said:".mysql_error());
  
$count = mysql_num_rows($link);
$data = mysql_fetch_assoc($link);
$lname = $data["lname"];
$hub = $data["hub"];
$pwd = $data["pwd"];
$fname = $data["fname"];
$login= $data["login"];
$status= $data["status"];

$newp = mysql_query("SELECT * FROM `pilots` where status ='0'")
  or die("MySQL Said:".mysql_error());
  
  $newprow = mysql_num_rows($newp);
  $result = count($newp);
  


if($count == 1)
{




  if($data['status'] == 0)
   {
    echo '<center>Your Account Is Not Active.</center>';
   }
  else
  {
   if($data['status'] == 2)
    {
    echo '<center><FONT COLOR =ff001b>Your Account Has Been Suspended.</center></FONT COLOR>';?>
    <center><a href="logout.php">Log Out</a></br></center>
   
<?  }
   else
   {
     if($data['status'] == 3)
    {
    echo '<center>You Are Currently On L.O.A</center>';?>
     <a href="rfileloa.php?login=<? echo "{$data["login"]}"?>">Return From L.O.A</a></br><?
   }
   else
   {
   
   

$_SESSION['SESS_LOGGEDIN'] = TRUE;
$_SESSION['SESS_LNAME'] = $lname;
$_SESSION['SESS_HUB'] = $hub;
$_SESSION['SESS_FNAME'] = $fname;
$_SESSION['login'] = $login;
$_SESSION['status'] = $status;


?>
   <body link="#0066FF" vlink="#0066FF" alink="#0066FF">
   <center>Welcome Back <? echo"$fname"; ?> <? echo"$lname"; ?></center>
   <center>
   <h7><i><b>Pilots Panel</b></i></h7></br>
   <a href="?page=pirepform&lname=<? echo "{$data["lname"]}"?>">File Pirep</a></br>
   <a href="?page=fileloa&login=<? echo "{$data["login"]}"?>">File LOA</a></br>
   <a href="#">Signatures</a></br>
   <A HREF="?page=profile&login=<? echo "{$data["login"]}"?> ">My Profile</a></br>
   <a href="?page=editp&login=<? echo "{$data["login"]}"?>">Edit My Profile</a></br>
   <a href="?page=events">Events</a></br>
   <a href="?page=rosterphp">VIew Roster</a></br>
   <a href="#"><font color="#FF0000">Resignation Form</font Color></br>
   <a href="logout.php">Log Out</a></br>
   
   <br>
   <h7><i><b>Pilots Tools</b></i></h7></br>
   <a href="http://www.fspassengers.com/"> FS Passengers</a></br>
   </center>

    <?php
   if($data['hm'] == 1)
    {?>
     <center>
    <h7><i><b>Hub Manager Panel</b></i></h7></br>
     <a href="edithub.php?hub=<?php echo $data['hub']; ?>">Edit Hub Page</a></br>
     <a href="apppireps.php?hub=<?php echo $data['hub']; ?>">Approve Pireps</a></br>
     <a href="promote.php?hub=<?php echo $data['hub']; ?>">Promote Pilot</a></br>
     <a href="awards.php">Grant Award</a></br>
    </center>
    <?php
   }
   if($data['fm'] == 1)
    {?>
     <center>
    <h7><i><b>Fleet Manager Panel</b></i></h7></br>
     <a href="addaircraft.php">Add Aircraft</a></br>
     <a href="manageaircraft.php">Manage Aircraft</a>
     </center>
    <?php
   }
   if($data['ed'] == 1)
    {?>
   <center>
    <h7><i><b>Events Director Panel</b></i></h7></br>
    <a href="?page=addevent">Add Event</a></br>
    <a href="?page=manageevents">Manage Events</a></br>
    <a href="postnews.php">Post News</a></br>
   
   
</center>
    <?php
   }
   if($data['hr'] == 1)
    { ?>
    <center>
    <h7><i><b>Human Rescources Panel</b></i></h7></br>
    <a href="?page=newpilots">New Pilots</a></br>
    <a href="?page=editpilots">Edit Pilots</a></br>
    <a href="viewcomments.php">View Comments</a></br>
    <a href="viewsitecomments.php">View Site Comments</a></br>
   <a href="?page=addnews">Post News</a></br>
   <a href="?page=editnews">Edit News</a></br>

   <?php
   }
   if($data['bm'] == 1)
    {?>
    <center>
     <h7><i><b>Executive Staff Panel</b></i></h7></br>
     <a href="edithub.php?hub=<?php echo $data['hub']; ?>">Edit Hub Page</a></br>
     <a href="apppireps.php?hub=<?php echo $data['hub']; ?>">Approve Pireps</a></br>
     <a href="promote.php?hub=<?php echo $data['hub']; ?>">Promote Pilot</a></br>
     <a href="awards.php">Grant Award</a></br>
    <a href="addevent">Add Event</a></br>
     <a href="manageevents.php">Manage Events</a></br>
      <a href="?page=addnews">Post News</a></br>
   <a href="?page=editnews">Edit News</a></br>
    <a href="pilotrec.php">Pilot Records</a></br>
    <a href="?page=newpilots&staffid=<? echo "{$data["login"]}"?>">New Pilots</a>  <font color="#0066FF" size="3" face="Times New Roman, Times, serif"><b><? echo"$newprow"; ?></font></b></br>
     <a href="?page=editpilots">Edit Pilots</a></br>
     <a href="viewcomments.php">View Comments</a></br>
     <a href="viewsitecomments.php">View Site Comments</a></br>
   
   <?php
   }
  }
  } }
}
else
{?>
<script>javascript:alert("Log In Failed!")</script>
<?
  echo '<center><FONT COLOR =ff001b> Your <i>Pilot ID And/Or Password</i> is wrong!</center></FONT COLOR>';?>
<style type="text/css">
.idBox {
width:50px;
}
.passwordBox {
width:80px;
}
</style>

<table border="0" align="center">
<form action="<? $_SERVER['PHP_SELF']; ?>" method="post">
  <tr>
    <td align="center">ID:</td><td align="center">ASA<input type="text" name="user" class="idBox"></td>
  </tr>
  <tr>
    <td align="center">Password:</td><td align="center"><input type="password" name="pwd" class="passwordBox"></td>
  </tr>
  <tr>
    <td></td><td align="center"><p align="center">
      <input type="submit" name="login" value="Login">
    </p>
      <p align="center">        <a href="#">Forgot Password</a></p></td>
  </tr>
</table>
<?
}?>
<? } else {?>
<style type="text/css">
.idBox {
width:50px;
}
.passwordBox {
width:80px;
}
</style>

<table border="0" align="center">
<form action="<? $_SERVER['PHP_SELF']; ?>" method="post">
  <tr>
    <td align="center">ID:</td><td align="center">ASA<input type="text" name="user" class="idBox"></td>
  </tr>
  <tr>
    <td align="center">Password:</td><td align="center"><input type="password" name="pwd" class="passwordBox"></td>
  </tr>
  <tr>
    <td></td><td align="center"><p>
      <input type="submit" name="login" value="Login">
      </p>
      <p><a href="#">Forgot Password</a> </p></td>
  </tr>
</table>
<?php } ?>

<font color="#0066FF" size="3">

 

 

Link to comment
https://forums.phpfreaks.com/topic/145580-need-serious-help-with-login-problems/
Share on other sites
Brian W Regular Member

Brian W

Posted
Posted

first off, imo, short tags are no good and shouldn't be used.

Secondly (actual trouble shooting :-), you have:

if(isset($_POST['user'])){
...all of your code including the links...
}

Try:

<?php
session_start();
?>

<?php
if(isset($_POST['user']))
{
//Include Config File For DB info..
include 'db.php';
//Connect TO The MySQL Server
$connect = mysql_connect($db_host,$db_username,$db_password)
  or die("MySQL Said:".mysql_error());
  
$database = mysql_select_db($db_database,$connect)
  or die("MySQl Said:".mysql_error());
  
$login = mysql_real_escape_string($_POST['user']);
$pwd = mysql_real_escape_string($_POST['pwd']);

$link = mysql_query("SELECT * FROM `pilots` where login='$login' and pwd='$pwd'")
  or die("MySQL Said:".mysql_error());
  
$count = mysql_num_rows($link);
$data = mysql_fetch_assoc($link);
$lname = $data["lname"];
$hub = $data["hub"];
$pwd = $data["pwd"];
$fname = $data["fname"];
$login= $data["login"];
$status= $data["status"];

$newp = mysql_query("SELECT * FROM `pilots` where status ='0'")
  or die("MySQL Said:".mysql_error());
  
  $newprow = mysql_num_rows($newp);
  $result = count($newp);
  


if($count == 1)
{




  if($data['status'] == 0)
   {
    echo '<center>Your Account Is Not Active.</center>';
   }
  else
  {
   if($data['status'] == 2)
    {
    echo '<center><FONT COLOR =ff001b>Your Account Has Been Suspended.</center></FONT COLOR>';?>
    <center><a href="logout.php">Log Out</a></br></center>
   
<?  }
   else
   {
     if($data['status'] == 3)
    {
    echo '<center>You Are Currently On L.O.A</center>';?>
     <a href="rfileloa.php?login=<? echo "{$data["login"]}"?>">Return From L.O.A</a></br><?
   }
   else
   {
   
   

$_SESSION['SESS_LOGGEDIN'] = TRUE;
$_SESSION['SESS_LNAME'] = $lname;
$_SESSION['SESS_HUB'] = $hub;
$_SESSION['SESS_FNAME'] = $fname;
$_SESSION['login'] = $login;
$_SESSION['status'] = $status;

}
if($_SESSION['SESS_LOGGEDIN'] == TRUE){
?>
   <body link="#0066FF" vlink="#0066FF" alink="#0066FF">
   <center>Welcome Back <? echo"$fname"; ?> <? echo"$lname"; ?></center>
   <center>
   <h7><i><b>Pilots Panel</b></i></h7></br>
   <a href="?page=pirepform&lname=<? echo "{$data["lname"]}"?>">File Pirep</a></br>
   <a href="?page=fileloa&login=<? echo "{$data["login"]}"?>">File LOA</a></br>
   <a href="#">Signatures</a></br>
   <A HREF="?page=profile&login=<? echo "{$data["login"]}"?> ">My Profile</a></br>
   <a href="?page=editp&login=<? echo "{$data["login"]}"?>">Edit My Profile</a></br>
   <a href="?page=events">Events</a></br>
   <a href="?page=rosterphp">VIew Roster</a></br>
   <a href="#"><font color="#FF0000">Resignation Form</font Color></br>
   <a href="logout.php">Log Out</a></br>
   
   <br>
   <h7><i><b>Pilots Tools</b></i></h7></br>
   <a href="http://www.fspassengers.com/"> FS Passengers</a></br>
   </center>

    <?php
   if($data['hm'] == 1)
    {?>
     <center>
    <h7><i><b>Hub Manager Panel</b></i></h7></br>
     <a href="edithub.php?hub=<?php echo $data['hub']; ?>">Edit Hub Page</a></br>
     <a href="apppireps.php?hub=<?php echo $data['hub']; ?>">Approve Pireps</a></br>
     <a href="promote.php?hub=<?php echo $data['hub']; ?>">Promote Pilot</a></br>
     <a href="awards.php">Grant Award</a></br>
    </center>
    <?php
   }
   if($data['fm'] == 1)
    {?>
     <center>
    <h7><i><b>Fleet Manager Panel</b></i></h7></br>
     <a href="addaircraft.php">Add Aircraft</a></br>
     <a href="manageaircraft.php">Manage Aircraft</a>
     </center>
    <?php
   }
   if($data['ed'] == 1)
    {?>
   <center>
    <h7><i><b>Events Director Panel</b></i></h7></br>
    <a href="?page=addevent">Add Event</a></br>
    <a href="?page=manageevents">Manage Events</a></br>
    <a href="postnews.php">Post News</a></br>
   
   
</center>
    <?php
   }
   if($data['hr'] == 1)
    { ?>
    <center>
    <h7><i><b>Human Rescources Panel</b></i></h7></br>
    <a href="?page=newpilots">New Pilots</a></br>
    <a href="?page=editpilots">Edit Pilots</a></br>
    <a href="viewcomments.php">View Comments</a></br>
    <a href="viewsitecomments.php">View Site Comments</a></br>
   <a href="?page=addnews">Post News</a></br>
   <a href="?page=editnews">Edit News</a></br>


   <?php
   }
   if($data['bm'] == 1)
    {?>
    <center>
     <h7><i><b>Executive Staff Panel</b></i></h7></br>
     <a href="edithub.php?hub=<?php echo $data['hub']; ?>">Edit Hub Page</a></br>
     <a href="apppireps.php?hub=<?php echo $data['hub']; ?>">Approve Pireps</a></br>
     <a href="promote.php?hub=<?php echo $data['hub']; ?>">Promote Pilot</a></br>
     <a href="awards.php">Grant Award</a></br>
    <a href="addevent">Add Event</a></br>
     <a href="manageevents.php">Manage Events</a></br>
      <a href="?page=addnews">Post News</a></br>
   <a href="?page=editnews">Edit News</a></br>
    <a href="pilotrec.php">Pilot Records</a></br>
    <a href="?page=newpilots&staffid=<? echo "{$data["login"]}"?>">New Pilots</a>  <font color="#0066FF" size="3" face="Times New Roman, Times, serif"><b><? echo"$newprow"; ?></font></b></br>
     <a href="?page=editpilots">Edit Pilots</a></br>
     <a href="viewcomments.php">View Comments</a></br>
     <a href="viewsitecomments.php">View Site Comments</a></br>
   
   <?php
   }
  }
  } }
}
else
{?>
<script>javascript:alert("Log In Failed!")</script>
<?
  echo '<center><FONT COLOR =ff001b> Your <i>Pilot ID And/Or Password</i> is wrong!</center></FONT COLOR>';?>
<style type="text/css">
.idBox {
width:50px;
}
.passwordBox {
width:80px;
}
</style>

<table border="0" align="center">
<form action="<? $_SERVER['PHP_SELF']; ?>" method="post">
  <tr>
    <td align="center">ID:</td><td align="center">ASA<input type="text" name="user" class="idBox"></td>
  </tr>
  <tr>
    <td align="center">Password:</td><td align="center"><input type="password" name="pwd" class="passwordBox"></td>
  </tr>
  <tr>
    <td></td><td align="center"><p align="center">
      <input type="submit" name="login" value="Login">
    </p>
      <p align="center">        <a href="#">Forgot Password</a></p></td>
  </tr>
</table>
<?
}?>
<? } else {?>
<style type="text/css">
.idBox {
width:50px;
}
.passwordBox {
width:80px;
}
</style>

<table border="0" align="center">
<form action="<? $_SERVER['PHP_SELF']; ?>" method="post">
  <tr>
    <td align="center">ID:</td><td align="center">ASA<input type="text" name="user" class="idBox"></td>
  </tr>
  <tr>
    <td align="center">Password:</td><td align="center"><input type="password" name="pwd" class="passwordBox"></td>
  </tr>
  <tr>
    <td></td><td align="center"><p>
      <input type="submit" name="login" value="Login">
      </p>
      <p><a href="#">Forgot Password</a> </p></td>
  </tr>
</table>
<?php } ?>

<font color="#0066FF" size="3">

topflight Regular Member

topflight

Posted
  • Author
Posted

first off, imo, short tags are no good and shouldn't be used.

Secondly (actual trouble shooting :-), you have:

if(isset($_POST['user'])){
...all of your code including the links...
}

Try:

<?php
session_start();
?>

<?php
if(isset($_POST['user']))
{
//Include Config File For DB info..
include 'db.php';
//Connect TO The MySQL Server
$connect = mysql_connect($db_host,$db_username,$db_password)
  or die("MySQL Said:".mysql_error());
  
$database = mysql_select_db($db_database,$connect)
  or die("MySQl Said:".mysql_error());
  
$login = mysql_real_escape_string($_POST['user']);
$pwd = mysql_real_escape_string($_POST['pwd']);

$link = mysql_query("SELECT * FROM `pilots` where login='$login' and pwd='$pwd'")
  or die("MySQL Said:".mysql_error());
  
$count = mysql_num_rows($link);
$data = mysql_fetch_assoc($link);
$lname = $data["lname"];
$hub = $data["hub"];
$pwd = $data["pwd"];
$fname = $data["fname"];
$login= $data["login"];
$status= $data["status"];

$newp = mysql_query("SELECT * FROM `pilots` where status ='0'")
  or die("MySQL Said:".mysql_error());
  
  $newprow = mysql_num_rows($newp);
  $result = count($newp);
  


if($count == 1)
{




  if($data['status'] == 0)
   {
    echo '<center>Your Account Is Not Active.</center>';
   }
  else
  {
   if($data['status'] == 2)
    {
    echo '<center><FONT COLOR =ff001b>Your Account Has Been Suspended.</center></FONT COLOR>';?>
    <center><a href="logout.php">Log Out</a></br></center>
   
<?  }
   else
   {
     if($data['status'] == 3)
    {
    echo '<center>You Are Currently On L.O.A</center>';?>
     <a href="rfileloa.php?login=<? echo "{$data["login"]}"?>">Return From L.O.A</a></br><?
   }
   else
   {
   
   

$_SESSION['SESS_LOGGEDIN'] = TRUE;
$_SESSION['SESS_LNAME'] = $lname;
$_SESSION['SESS_HUB'] = $hub;
$_SESSION['SESS_FNAME'] = $fname;
$_SESSION['login'] = $login;
$_SESSION['status'] = $status;

}
if($_SESSION['SESS_LOGGEDIN'] == TRUE){
?>
   <body link="#0066FF" vlink="#0066FF" alink="#0066FF">
   <center>Welcome Back <? echo"$fname"; ?> <? echo"$lname"; ?></center>
   <center>
   <h7><i><b>Pilots Panel</b></i></h7></br>
   <a href="?page=pirepform&lname=<? echo "{$data["lname"]}"?>">File Pirep</a></br>
   <a href="?page=fileloa&login=<? echo "{$data["login"]}"?>">File LOA</a></br>
   <a href="#">Signatures</a></br>
   <A HREF="?page=profile&login=<? echo "{$data["login"]}"?> ">My Profile</a></br>
   <a href="?page=editp&login=<? echo "{$data["login"]}"?>">Edit My Profile</a></br>
   <a href="?page=events">Events</a></br>
   <a href="?page=rosterphp">VIew Roster</a></br>
   <a href="#"><font color="#FF0000">Resignation Form</font Color></br>
   <a href="logout.php">Log Out</a></br>
   
   <br>
   <h7><i><b>Pilots Tools</b></i></h7></br>
   <a href="http://www.fspassengers.com/"> FS Passengers</a></br>
   </center>

    <?php
   if($data['hm'] == 1)
    {?>
     <center>
    <h7><i><b>Hub Manager Panel</b></i></h7></br>
     <a href="edithub.php?hub=<?php echo $data['hub']; ?>">Edit Hub Page</a></br>
     <a href="apppireps.php?hub=<?php echo $data['hub']; ?>">Approve Pireps</a></br>
     <a href="promote.php?hub=<?php echo $data['hub']; ?>">Promote Pilot</a></br>
     <a href="awards.php">Grant Award</a></br>
    </center>
    <?php
   }
   if($data['fm'] == 1)
    {?>
     <center>
    <h7><i><b>Fleet Manager Panel</b></i></h7></br>
     <a href="addaircraft.php">Add Aircraft</a></br>
     <a href="manageaircraft.php">Manage Aircraft</a>
     </center>
    <?php
   }
   if($data['ed'] == 1)
    {?>
   <center>
    <h7><i><b>Events Director Panel</b></i></h7></br>
    <a href="?page=addevent">Add Event</a></br>
    <a href="?page=manageevents">Manage Events</a></br>
    <a href="postnews.php">Post News</a></br>
   
   
</center>
    <?php
   }
   if($data['hr'] == 1)
    { ?>
    <center>
    <h7><i><b>Human Rescources Panel</b></i></h7></br>
    <a href="?page=newpilots">New Pilots</a></br>
    <a href="?page=editpilots">Edit Pilots</a></br>
    <a href="viewcomments.php">View Comments</a></br>
    <a href="viewsitecomments.php">View Site Comments</a></br>
   <a href="?page=addnews">Post News</a></br>
   <a href="?page=editnews">Edit News</a></br>


   <?php
   }
   if($data['bm'] == 1)
    {?>
    <center>
     <h7><i><b>Executive Staff Panel</b></i></h7></br>
     <a href="edithub.php?hub=<?php echo $data['hub']; ?>">Edit Hub Page</a></br>
     <a href="apppireps.php?hub=<?php echo $data['hub']; ?>">Approve Pireps</a></br>
     <a href="promote.php?hub=<?php echo $data['hub']; ?>">Promote Pilot</a></br>
     <a href="awards.php">Grant Award</a></br>
    <a href="addevent">Add Event</a></br>
     <a href="manageevents.php">Manage Events</a></br>
      <a href="?page=addnews">Post News</a></br>
   <a href="?page=editnews">Edit News</a></br>
    <a href="pilotrec.php">Pilot Records</a></br>
    <a href="?page=newpilots&staffid=<? echo "{$data["login"]}"?>">New Pilots</a>  <font color="#0066FF" size="3" face="Times New Roman, Times, serif"><b><? echo"$newprow"; ?></font></b></br>
     <a href="?page=editpilots">Edit Pilots</a></br>
     <a href="viewcomments.php">View Comments</a></br>
     <a href="viewsitecomments.php">View Site Comments</a></br>
   
   <?php
   }
  }
  } }
}
else
{?>
<script>javascript:alert("Log In Failed!")</script>
<?
  echo '<center><FONT COLOR =ff001b> Your <i>Pilot ID And/Or Password</i> is wrong!</center></FONT COLOR>';?>
<style type="text/css">
.idBox {
width:50px;
}
.passwordBox {
width:80px;
}
</style>

<table border="0" align="center">
<form action="<? $_SERVER['PHP_SELF']; ?>" method="post">
  <tr>
    <td align="center">ID:</td><td align="center">ASA<input type="text" name="user" class="idBox"></td>
  </tr>
  <tr>
    <td align="center">Password:</td><td align="center"><input type="password" name="pwd" class="passwordBox"></td>
  </tr>
  <tr>
    <td></td><td align="center"><p align="center">
      <input type="submit" name="login" value="Login">
    </p>
      <p align="center">        <a href="#">Forgot Password</a></p></td>
  </tr>
</table>
<?
}?>
<? } else {?>
<style type="text/css">
.idBox {
width:50px;
}
.passwordBox {
width:80px;
}
</style>

<table border="0" align="center">
<form action="<? $_SERVER['PHP_SELF']; ?>" method="post">
  <tr>
    <td align="center">ID:</td><td align="center">ASA<input type="text" name="user" class="idBox"></td>
  </tr>
  <tr>
    <td align="center">Password:</td><td align="center"><input type="password" name="pwd" class="passwordBox"></td>
  </tr>
  <tr>
    <td></td><td align="center"><p>
      <input type="submit" name="login" value="Login">
      </p>
      <p><a href="#">Forgot Password</a> </p></td>
  </tr>
</table>
<?php } ?>

<font color="#0066FF" size="3">

 

Isn't that code is the same as mine up above?

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.