Jump to content

User Login Problems

topflight

By topflight
in PHP Coding Help

Recommended Posts

topflight Regular Member

topflight

Posted
  • Author
Posted

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?

blueman378 Advanced Member

blueman378

Posted
Posted

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>
";
} ?>

blueman378 Advanced Member

blueman378

Posted
Posted

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

topflight Regular Member

topflight

Posted
  • Author
Posted

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?

 

blueman378 Advanced Member

blueman378

Posted
Posted

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.

topflight Regular Member

topflight

Posted
  • Author
Posted

With the following code up above I am getting the following message now.

 

 

Array ( [iD] => 36 [login] => 2000 [pwd] => google [fname] => <a name here> [lname] => <a name here> => <a emailhere> [semail] => 0 [hub] => PANC [thours] => 15 [thoursc] => delta [rating] => SeniorCaptain [vatsimid] => <id here>  [about] => [pic] => [date] => 0000-00-00 [ip] => 127.0.0.1 [status] => 1 [hm] => 0 [ed] => 0 [fm] => 0 => 0 [bm] => 1 )

 

That is what it tells me the(<a name here> and stuff like that I put that their to not reveal real names so what should I do now?

blueman378 Advanced Member

blueman378

Posted
Posted

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>
   ";
} ?>

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.