Jump to content

Session Info

vasoftwaresolutions

By vasoftwaresolutions
in PHP Coding Help

Recommended Posts

vasoftwaresolutions Newbie

vasoftwaresolutions

Posted
Posted

hello again guys,

 

I am trying to echo the users info so they can see where they stand... it is suppost to display there first name, last name, etc. here is the login info to test it out.... http://bluewavesvirtual.com/index1.php user=BWA1001 password=833699

 

any help is apprecheated

also here is my code

<?php $pagename = "Pilot Overview"; ?>
<?php
$host="localhost"; // Host name 
$username="pacifij1_blue"; // Mysql username 
$password="8336994895"; // Mysql password 
$db_name="pacifij1_blue"; // Database name 
$tbl_name="pilot"; // Table name 



session_start();


if(!session_is_registered('callsign') AND !session_is_registered('pwd') AND !session_is_registered('first_name') AND !session_is_registered('last_name')){ 

header( 'Location: http://bluewavesvirtual.com/');

exit();

}


?>
<?php

$hostname = "localhost";   
$database = "pacifij1_blue"; 
$username = "pacifij1_blue"; 
$password = "8336994895"; 
$vrbo = mysql_connect($hostname, $username, $password) or die(mysql_error()); 

mysql_select_db($database, $vrbo);
$query_Session_Info = ("SELECT * FROM pilot WHERE callsign = '$callsign' and last_name = '$last_name'");
$Session_Info = mysql_query($query_Session_Info, $vrbo) or die(mysql_error());
$row_Session_Info = mysql_fetch_assoc($Session_Info);
$totalRows_Session_Info = mysql_num_rows($Session_Info);



?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Blue Waves Virtual Airlines :: <?php echo $pagename; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/style.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style2 {color: #808080}
-->
</style>
</head>

<body>
<div align="center">
  <table width="800" border="0" cellspacing="0" cellpadding="0">
    <tr> 
      <td><img src="images/toplayer.jpg" width="800" height="20"></td>
    </tr>
  </table>
  <table width="800" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><img src="banners/banners.jpg" width="800" height="150"></td>
    </tr>
  </table>
<?php include("includes/mainmenu.php"); ?>
  <table width="800" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td width="144"><p> </p>
        <p><?php include("includes/pilotmenu.php"); ?></p>
      <p> </p></td>
      <td width="556"><p><img src="images/careerimg.jpg" alt="Carrer Image" width="288" height="193"></p>
        <p>Hello And Welcome To Your Pilot Overview</p>
        <p>First Name: <?php echo $row_Session_Info['first_name']; ?></p>
        <p>Last Name: <?php echo $row_Session_Info['last_name']; ?></p>
      <p>City: <?php echo $row_Session_Info['city']; ?></p>
      <p>State: <?php echo $row_Session_Info['state']; ?></p>
      <p>Country: <?php echo $row_Session_Info['country']; ?></p>
      <p>About: <?php echo $row_Session_Info['about']; ?></p>
      <p>Hours: <?php
		  
		  $last_name = $row_pilots['last_name']; 

		  

		mysql_select_db($database, $vrbo);
$tt = 0;
$midnight = strtotime(date('Y-m-d') . ' 00:00:00');



mysql_select_db($database, $vrbo);
$query_h = "SELECT duration FROM pireps WHERE last_name = '$last_name' and approved = '1'";
$h = mysql_query($query_h, $vrbo) or die(mysql_error());


while($r = mysql_fetch_assoc($h))
$tt += strtotime($r['duration']) - $midnight;
$hours = floor($tt/3600);
$x = $tt - floor($tt/3600)*3600;
$mins = floor($x/60);
$secs = $x - floor($x/60) * 60;
echo  $hours . ':' . $mins;
?><br>
          </p></td>
      <td width="100">Hello <?php echo $callsign; ?>,  Welcome</p>
      <p><a href="logout.php" class="linkblue">Logout</a></td>
    </tr>
  </table>
  <table width="800" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><div align="center"><font color="#808080">©2008 Blue Waves Virtual 
          Airlines. Logos And Slogans And All Other Property 
          Are Part Of Blue Waves Virtual Airlines And May Never Be Redestributed. 
      All Rights Reserved.</font></div></td>
    </tr>
    <tr>
      <td><img src="images/bottomlayer.jpg" width="800" height="50"></td>
    </tr>
  </table>
  <p> </p>
  <p>  </p>
</div>
</body>
</html>

Link to comment
https://forums.phpfreaks.com/topic/95743-session-info/
Share on other sites
conker87 Member

conker87

Posted
Posted

For a start, remove your mysql authorisation data from the variables.

 

Change:

if(!session_is_registered('callsign') AND !session_is_registered('pwd') AND !session_is_registered('first_name') AND !session_is_registered('last_name')){

to

if(!$_SESSION['callsign']) && !$_SESSION['pwd'] && $_SESSION['first_name'] && $_SESSION['last_name']){

 

Remove the first set of mysql data, since you've already set it at the pint where you're actually connecting. Why are you connecting to your databases so often? You need to do it once.

 

Also, if you've already stored the sessions, then you can echo the sessions:

<?=$_SESSION['callsign']; ?>

The <?= is a short way of saying echo.

 

Off topic, is the callsign the username, but a radio callsign?

Link to comment
https://forums.phpfreaks.com/topic/95743-session-info/#findComment-490326
Share on other sites

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.