Jump to content

User Login Problems


topflight

Recommended Posts

Now it is saying my login information is incorrect. But it is correct this is what my code reads now:

<?php
session_start();
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());
  
$lresult = mysql_fetch_assoc($link);
$lcount = mysql_num_rows($link);
$lname = $lresult["lname"];
$hub = $lresult["hub"];
$pwd = $lresult["pwd"];
$fname = $lresult["fname"];
$login= $lresult["login"];
$status= $lresult["status"];


if($lcount== 1){
$_SESSION['SESS_LOGGEDIN'] = true;
$_SESSION['SESS_LNAME'] = $lname;
$_SESSION['SESS_HUB'] = $hub;
$_SESSION['SESS_FNAME'] = $fname;
$_SESSION['login'] = $login;
$_SESSION['status'] = $status;
}
}
if(isset($_SESSION['SESS_LOGGEDIN']) == true)
{


$slogin = $_SESSION['login'];

$slink = mysql_query("SELECT * FROM `pilots` where login='$slogin'")
  or die("MySQL Said:".mysql_error());
  
  $data = mysql_fetch_assoc($slink);
  $scount = mysql_num_rows($slink);

if($scount ==1){

$sstatus = $_SESSION['status'];


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
   {

?>
   <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="?page=addnews_hub">Add News</a></br>
 <a href="?page=edithub">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="?page=edithub">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>';?>
  <?
}
} 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 align="center">
      <input type="submit" name="login" value="Login">
    </p>
      <p align="center">        <a href="#">Forgot Password</a></p></td>
  </tr>
</table>
<? 
} ?>


 

What should I do from here now?

Link to comment
Share on other sites

Hi mate, i havnt made any changes as far as logic, but ive gone through and made it more readable and understandable, also i would suggest you invest in learning proper css, ive updated your code as much as possible so now its sort of in the year 2000, youll have to do the rest.

 

anyway try running this:

 

<?php
session_start();
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());
  
$lresult = mysql_fetch_assoc($link);
$lcount = mysql_num_rows($link);
$lname = $lresult["lname"];
$hub = $lresult["hub"];
$pwd = $lresult["pwd"];
$fname = $lresult["fname"];
$login= $lresult["login"];
$status= $lresult["status"];

if($lcount == 1)
{
	$_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)
{
$slogin = $_SESSION['login'];

$slink = mysql_query("SELECT * FROM `pilots` where login='$slogin'")
or die("MySQL Said:".mysql_error());
  
$data = mysql_fetch_assoc($slink);
$scount = mysql_num_rows($slink);

if($scount ==1)
{
	$sstatus = $_SESSION['status'];

	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.</font>
    			<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=$data[login]\">Return From L.O.A</a><br />";
   				}
   				else
   				{
   					echo "
   				<body link=\"#0066FF\" vlink=\"#0066FF\" alink=\"#0066FF\">
   					<center>Welcome Back $fname $lname
   					<h7><em><strong>Pilots Panel</strong></em></h7><br />
   					<a href=\"?page=pirepform&lname=$data[lname]\">File Pirep</a><br />
   					<a href=\"?page=fileloa&login=$data[login]\">File LOA</a><br />
   					<a href=\"#\">Signatures</a><br />
   					<A href=\"?page=profile&login=$data[login]\">My Profile</a><br />
   					<a href=\"?page=editp&login=$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><br />
   					<a href=\"logout.php\">Log Out</a><br />
   					<br>
   					<h7><em><strong>Pilots Tools</strong></em></h7><br />
   					<a href=\"http://www.fspassengers.com/\"> FS Passengers</a><br />
   					</center>
				";

				if($data['hm'] == 1)
    				{
    					echo "
     					<center>
    					<h7><em><strong>Hub Manager Panel</strong></em></h7><br />
     					<a href=\"?page=addnews_hub\">Add News</a><br />
 					<a href=\"?page=edithub\">Edit Hub Page</a><br />
     					<a href=\"apppireps.php?hub=$data[hub]\">Approve Pireps</a><br />
     					<a href=\"promote.php?hub=$data[hub]\">Promote Pilot</a><br />
     					<a href=\"awards.php\">Grant Award</a><br />
    					</center>
    					";
				}

				if($data['fm'] == 1)
    				{
    					echo "
     					<center>
    					<h7><em><strong>Fleet Manager Panel</strong></em></h7><br />
     					<a href=\"addaircraft.php\">Add Aircraft</a><br />
     					<a href=\"manageaircraft.php\">Manage Aircraft</a>
     					</center>
     					";
   					}
   					
   					if($data['ed'] == 1)
    				{
   						echo "
					<center>
    					<h7><em><strong>Events Director Panel</strong></em></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>
					";
   					}
   					
   					if($data['hr'] == 1)
    				{
    					echo "
    					<center>
    					<h7><em><strong>Human Rescources Panel</strong></em></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 />
					";
			   }
			   
				if($data['bm'] == 1)
    				{
    					echo "
					<center>
     					<h7><em><strong>Executive Staff Panel</strong></em></h7><br />
     					<a href=\"?page=edithub\">Edit Hub Page</a><br />
     					<a href=\"apppireps.php?hub=$data[hub]\">Approve Pireps</a><br />
     					<a href=\"promote.php?hub=$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=$data[login]\">New Pilots</a>
					<font color=\"#0066FF\" size=\"3\" face=\"Times New Roman, Times, serif\">
					<strong>$newprow</strong></font><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 />
     					";
				}
			}
		} 
	}
}
else
{
	echo "<script>javascript:alert(\"Log In Failed!\")</script>
	<center><font color=\"ff001b\">Your <em>Pilot ID And/Or Password</em> is wrong!</font></center>
	";
}
}
else
{
echo "	
<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>
";
} ?>

Link to comment
Share on other sites

also mate try putting this

 

print_r ($lresult);
Die();

 

straight after

$lresult = mysql_fetch_assoc($link);
$lcount = mysql_num_rows($link);
$lname = $lresult["lname"];
$hub = $lresult["hub"];
$pwd = $lresult["pwd"];
$fname = $lresult["fname"];
$login= $lresult["login"];
$status= $lresult["status"];

and post the output here.

 

Matt

Link to comment
Share on other sites

With the following code and with print_r ($lresult);

Die(); I get the following error

 

Notice: Undefined index: SESS_LOGGEDIN in C:\xampp\htdocs\login.php on line 41

 

This is my login.php code now

<?php
session_start();
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());
  
   $lresult = mysql_fetch_assoc($link);
   $lcount = mysql_num_rows($link);
   $lname = $lresult["lname"];
   $hub = $lresult["hub"];
   $pwd = $lresult["pwd"];
   $fname = $lresult["fname"];
   $login= $lresult["login"];
   $status= $lresult["status"];
   print_r ($lresult);
Die();

   if($lcount == 1)
   {
      $_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)
{
   $slogin = $_SESSION['login'];
   
   $slink = mysql_query("SELECT * FROM `pilots` where login='$slogin'")
   or die("MySQL Said:".mysql_error());
  
   $data = mysql_fetch_assoc($slink);
   $scount = mysql_num_rows($slink);

   if($scount ==1)
   {
      $sstatus = $_SESSION['status'];

      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.</font>
             <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=$data[login]\">Return From L.O.A</a><br />";
               }
               else
               {
                  echo "
                  <body link=\"#0066FF\" vlink=\"#0066FF\" alink=\"#0066FF\">
                  <center>Welcome Back $fname $lname
                  <h7><em><strong>Pilots Panel</strong></em></h7><br />
                  <a href=\"?page=pirepform&lname=$data[lname]\">File Pirep</a><br />
                  <a href=\"?page=fileloa&login=$data[login]\">File LOA</a><br />
                  <a href=\"#\">Signatures</a><br />
                  <A href=\"?page=profile&login=$data[login]\">My Profile</a><br />
                  <a href=\"?page=editp&login=$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><br />
                  <a href=\"logout.php\">Log Out</a><br />
                  <br>
                  <h7><em><strong>Pilots Tools</strong></em></h7><br />
                  <a href=\"http://www.fspassengers.com/\"> FS Passengers</a><br />
                  </center>
               ";

               if($data['hm'] == 1)
                {
                   echo "
                    <center>
                   <h7><em><strong>Hub Manager Panel</strong></em></h7><br />
                    <a href=\"?page=addnews_hub\">Add News</a><br />
                   <a href=\"?page=edithub\">Edit Hub Page</a><br />
                    <a href=\"apppireps.php?hub=$data[hub]\">Approve Pireps</a><br />
                    <a href=\"promote.php?hub=$data[hub]\">Promote Pilot</a><br />
                    <a href=\"awards.php\">Grant Award</a><br />
                   </center>
                   ";
               }
               
               if($data['fm'] == 1)
                {
                   echo "
                    <center>
                   <h7><em><strong>Fleet Manager Panel</strong></em></h7><br />
                    <a href=\"addaircraft.php\">Add Aircraft</a><br />
                    <a href=\"manageaircraft.php\">Manage Aircraft</a>
                    </center>
                    ";
                  }
                  
                  if($data['ed'] == 1)
                {
                     echo "
                  <center>
                   <h7><em><strong>Events Director Panel</strong></em></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>
                  ";
                  }
                  
                  if($data['hr'] == 1)
                {
                   echo "
                   <center>
                   <h7><em><strong>Human Rescources Panel</strong></em></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 />
                  ";
               }
               
               if($data['bm'] == 1)
                {
                   echo "
                  <center>
                    <h7><em><strong>Executive Staff Panel</strong></em></h7><br />
                    <a href=\"?page=edithub\">Edit Hub Page</a><br />
                    <a href=\"apppireps.php?hub=$data[hub]\">Approve Pireps</a><br />
                    <a href=\"promote.php?hub=$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=$data[login]\">New Pilots</a>
                  <font color=\"#0066FF\" size=\"3\" face=\"Times New Roman, Times, serif\">
                  <strong>$newprow</strong></font><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 />
                    ";
               }
            }
         } 
      }
   }
   else
   {
      echo "<script>javascript:alert(\"Log In Failed!\")</script>
      <center><font color=\"ff001b\">Your <em>Pilot ID And/Or Password</em> is wrong!</font></center>
      ";
   }
}
else
{
   echo "   
   <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>
   ";
} ?>

 

Line 41 is:

if($_SESSION['SESS_LOGGEDIN'] == true)

 

Any other suggestions?

 

Link to comment
Share on other sites

sorry mate,

 

try this:

<?php
session_start();
if(!isset($_SESSION['SESS_LOGGEDIN']))
{
$_SESSION['SESS_LOGGEDIN'] = false;
}
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());
  
   $lresult = mysql_fetch_assoc($link);
   $lcount = mysql_num_rows($link);
   $lname = $lresult["lname"];
   $hub = $lresult["hub"];
   $pwd = $lresult["pwd"];
   $fname = $lresult["fname"];
   $login= $lresult["login"];
   $status= $lresult["status"];
   print_r ($lresult);
Die();

   if($lcount == 1)
   {
      $_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)
{
   $slogin = $_SESSION['login'];
   
   $slink = mysql_query("SELECT * FROM `pilots` where login='$slogin'")
   or die("MySQL Said:".mysql_error());
  
   $data = mysql_fetch_assoc($slink);
   $scount = mysql_num_rows($slink);

   if($scount ==1)
   {
      $sstatus = $_SESSION['status'];

      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.</font>
             <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=$data[login]\">Return From L.O.A</a><br />";
               }
               else
               {
                  echo "
                  <body link=\"#0066FF\" vlink=\"#0066FF\" alink=\"#0066FF\">
                  <center>Welcome Back $fname $lname
                  <h7><em><strong>Pilots Panel</strong></em></h7><br />
                  <a href=\"?page=pirepform&lname=$data[lname]\">File Pirep</a><br />
                  <a href=\"?page=fileloa&login=$data[login]\">File LOA</a><br />
                  <a href=\"#\">Signatures</a><br />
                  <A href=\"?page=profile&login=$data[login]\">My Profile</a><br />
                  <a href=\"?page=editp&login=$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><br />
                  <a href=\"logout.php\">Log Out</a><br />
                  <br>
                  <h7><em><strong>Pilots Tools</strong></em></h7><br />
                  <a href=\"http://www.fspassengers.com/\"> FS Passengers</a><br />
                  </center>
               ";

               if($data['hm'] == 1)
                {
                   echo "
                    <center>
                   <h7><em><strong>Hub Manager Panel</strong></em></h7><br />
                    <a href=\"?page=addnews_hub\">Add News</a><br />
                   <a href=\"?page=edithub\">Edit Hub Page</a><br />
                    <a href=\"apppireps.php?hub=$data[hub]\">Approve Pireps</a><br />
                    <a href=\"promote.php?hub=$data[hub]\">Promote Pilot</a><br />
                    <a href=\"awards.php\">Grant Award</a><br />
                   </center>
                   ";
               }
               
               if($data['fm'] == 1)
                {
                   echo "
                    <center>
                   <h7><em><strong>Fleet Manager Panel</strong></em></h7><br />
                    <a href=\"addaircraft.php\">Add Aircraft</a><br />
                    <a href=\"manageaircraft.php\">Manage Aircraft</a>
                    </center>
                    ";
                  }
                  
                  if($data['ed'] == 1)
                {
                     echo "
                  <center>
                   <h7><em><strong>Events Director Panel</strong></em></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>
                  ";
                  }
                  
                  if($data['hr'] == 1)
                {
                   echo "
                   <center>
                   <h7><em><strong>Human Rescources Panel</strong></em></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 />
                  ";
               }
               
               if($data['bm'] == 1)
                {
                   echo "
                  <center>
                    <h7><em><strong>Executive Staff Panel</strong></em></h7><br />
                    <a href=\"?page=edithub\">Edit Hub Page</a><br />
                    <a href=\"apppireps.php?hub=$data[hub]\">Approve Pireps</a><br />
                    <a href=\"promote.php?hub=$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=$data[login]\">New Pilots</a>
                  <font color=\"#0066FF\" size=\"3\" face=\"Times New Roman, Times, serif\">
                  <strong>$newprow</strong></font><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 />
                    ";
               }
            }
         } 
      }
   }
   else
   {
      echo "<script>javascript:alert(\"Log In Failed!\")</script>
      <center><font color=\"ff001b\">Your <em>Pilot ID And/Or Password</em> is wrong!</font></center>
      ";
   }
}
else
{
   echo "   
   <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>
   ";
} ?>

 

so yeah try logging in and then post the output.

Link to comment
Share on other sites

ok try this,

 

i just went through and simlified your ifs, no need to nestle then that deep just use elseif

 

anyway

<?php
session_start();
if(!isset($_SESSION['SESS_LOGGEDIN']))
{
$_SESSION['SESS_LOGGEDIN'] = false;
}
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());
  
   $lresult = mysql_fetch_assoc($link);
   $lcount = mysql_num_rows($link);
   $lname = $lresult["lname"];
   $hub = $lresult["hub"];
   $pwd = $lresult["pwd"];
   $fname = $lresult["fname"];
   $login= $lresult["login"];
   $status= $lresult["status"];

   if($lcount == 1)
   {
      $_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)
{
$slogin = $_SESSION['login'];
   
$slink = mysql_query("SELECT * FROM `pilots` where login='$slogin'")
or die("MySQL Said:".mysql_error());
  
$data = mysql_fetch_assoc($slink);
$scount = mysql_num_rows($slink);

if($scount ==1)
{
	$sstatus = $_SESSION['status'];

	if($data['status'] == 0)
	{
		echo "<center>Your Account Is Not Active.</center>";
	}
        elseif($data['status'] == 2)
        {
		echo "<center><font color=\"ff001b\">Your Account Has Been Suspended.</font>
		<a href=\"logout.php\">Log Out</a><br /></center>";
	}
	elseif($data['status'] == 3)
	{
		echo "<center>You Are Currently On L.O.A</center>
		<a href=\"rfileloa.php?login=$data[login]\">Return From L.O.A</a><br />";
	}
        else
	{
        	echo "
            <body link=\"#0066FF\" vlink=\"#0066FF\" alink=\"#0066FF\">
            <center>Welcome Back $fname $lname
            <h7><em><strong>Pilots Panel</strong></em></h7><br />
            <a href=\"?page=pirepform&lname=$data[lname]\">File Pirep</a><br />
            <a href=\"?page=fileloa&login=$data[login]\">File LOA</a><br />
            <a href=\"#\">Signatures</a><br />
            <a href=\"?page=profile&login=$data[login]\">My Profile</a><br />
            <a href=\"?page=editp&login=$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><br />
            <a href=\"logout.php\">Log Out</a><br />
            <br>
            <h7><em><strong>Pilots Tools</strong></em></h7><br />
            <a href=\"http://www.fspassengers.com/\"> FS Passengers</a><br />
            </center>
            ";

            if($data['hm'] == 1)
            {
                   echo "
                    <center>
                   <h7><em><strong>Hub Manager Panel</strong></em></h7><br />
                    <a href=\"?page=addnews_hub\">Add News</a><br />
                   <a href=\"?page=edithub\">Edit Hub Page</a><br />
                    <a href=\"apppireps.php?hub=$data[hub]\">Approve Pireps</a><br />
                    <a href=\"promote.php?hub=$data[hub]\">Promote Pilot</a><br />
                    <a href=\"awards.php\">Grant Award</a><br />
                   </center>
                   ";
		}
               
		if($data['fm'] == 1)
		{
               	echo "
               	<center>
               	<h7><em><strong>Fleet Manager Panel</strong></em></h7><br />
               	<a href=\"addaircraft.php\">Add Aircraft</a><br />
        		<a href=\"manageaircraft.php\">Manage Aircraft</a>
            	</center>
            	";
            }
                  
        	if($data['ed'] == 1)
            {
            	echo "
                <center>
                <h7><em><strong>Events Director Panel</strong></em></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>
                ";
            }
                  
            if($data['hr'] == 1)
            {
            	echo "
                <center>
                <h7><em><strong>Human Rescources Panel</strong></em></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 />
                ";
            }
               
            if($data['bm'] == 1)
            {
            	echo "
                <center>
                <h7><em><strong>Executive Staff Panel</strong></em></h7><br />
                <a href=\"?page=edithub\">Edit Hub Page</a><br />
                <a href=\"apppireps.php?hub=$data[hub]\">Approve Pireps</a><br />
                <a href=\"promote.php?hub=$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=$data[login]\">New Pilots</a>
                <font color=\"#0066FF\" size=\"3\" face=\"Times New Roman, Times, serif\">
                <strong>$newprow</strong></font><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 />
                ";
            }
        }
    }
else
{
    	echo "<script>javascript:alert(\"Log In Failed!\")</script>
    	<center><font color=\"ff001b\">Your <em>Pilot ID And/Or Password</em> is wrong!</font></center>
    	";
} 
}
else
{
   echo "   
   <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>
   ";
} ?>

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.