Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

Am i passing the session wrong way? can someone check.

align session

  • Please log in to reply
1 reply to this topic

#1 faith89

faith89

    CC Newcomer

  • Just Joined
  • PipPip
  • 14 posts

Posted 19 March 2010 - 11:50 PM

i have page findroom.php that will redirect to the page DisplayDetails.php.

i wanted the DisplayDetails.php page to display data from the query in the page findroom.php. The data that i wanted to display from the query from page DisplayDetails is 'room_price' and 'room_type'.

However, when i clik the Book Now link, it dosesnt't display the value.

Since i'm just a starter in php, can someone tell me am i treating the session the right way as it doesn't diplay any result for the data that i wanted to take from the query in the findroom.php. But, for the the others data which is 'checkin', 'checkout' and others, it just show perfectly.

I do hope if someone can tell me am i using the session in the right way or not.

below is the code: findroom.php

<?php
session_start();
unset($_SESSION['error']);
// echo variable from the session, we set this on our other page
$_SESSION['checkin'] = $_POST['checkin'];
//$_SESSION['checkin']=$checkin;
$_SESSION['checkout'] = $_POST['checkout'];
$_SESSION['rooms']= $_POST['rooms'];
$_SESSION['adults']= $_POST['adults'];
$_SESSION['children']= $_POST['children'];
$days = (strtotime($_POST['checkout']) - strtotime($_POST['checkin'])) / (60 * 60 * 24);

$_SESSION['days']=$days;

$_SESSION['room_price']=$data['room_price'];
$room_price=$_SESSION['room_price'];

$_SESSION['room_type']=$data['room_type'];
$room_type=$_SESSION['room_type'];
?>

<html>
<body>
<form action="DisplayDetails.php" method="post">
<p>

<?php

//$result = mysql_query("SELECT id_no,room_type,room_price from room1 WHERE room_no NOT IN ( SELECT id_room_no
//FROM reservation1 WHERE datein >='$datein' AND dateout <='$dateout')");

$result = mysql_query("SELECT room_price, room_type from room1 WHERE room_no NOT IN ( SELECT id_room_no
FROM reservation1 WHERE datein >='$datein' AND dateout <='$dateout')");
?>

<?php 
    /*if(isset($_POST['Check']) && $_POST['Check']=='Submit') 
    { 
          echo "The rooms availale on the date of :";
		  echo $datein;
		  echo "  until  ";
          echo $dateout; 
    } */
?> 

</p>
<p><strong><strong>Room Availbility</strong> </p>
<td><table width="61%" height="64" border="1" cellpadding="0" cellspacing="0" bordercolor="#CC66CC" class="report2">
      <tr>
        <td width="190" bgcolor="#E8E8E8"><div align="center"><strong>Room Type </strong></div></td>
        <td width="218" bgcolor="#E8E8E8"><div align="center"><strong>Room Price </strong></div></td>
        <td bgcolor="#E8E8E8"><strong>Task</strong></div></td>
      </tr>
      <?php
		//$counter=1;
		while ($data = mysql_fetch_array($result)):
		?>
      <tr>
     
        <td><?php echo $data['room_type']; ?></td>
        <td><?php echo $data['room_price']; ?></td>
  <td width="153"><label><a href="DisplayDetails.php?id_no=<?php echo $data['id_no'];?>"><strong>Book Now</strong></a></label></td>

 
    </tr>
      <?php
  		//$counter++;
  		endwhile;
		?>
    </table>
  <table width="373" border="1">
     <tr>
       <td colspan="2"><strong>Reservation Summary</strong></td>
      </tr>
     <tr>
       <td>Check In :</td>
       <td><label>
         <?php echo $_SESSION['checkin']; ?>
       </label></td>
      </tr>
     <tr>
       <td>Check Out :</td>
       <td><label><?php echo $_SESSION['checkout']; ?></label></td>
      </tr>
     <tr>
       <td>Rooms :</td>
       <td><label><?php echo $_SESSION['rooms']; ?></label></td>
      </tr>
     <tr>
       <td>Adults Per Room :</td>
       <td><label><?php echo $_SESSION['adults']; ?></label></td>
      </tr>
     <tr>
       <td>Children Per Room :</td>
       <td><label><?php echo $_SESSION['children']; ?></label></td>
      </tr>
     <tr>
       <td>Days :</td>
       <td><?php echo $_SESSION['days']; ?></td>
     </tr>
   </table>
   <p>
    <label></label>
   </form>
  </body>
</html>


below is the code for : DisplayDetails.php


<?php
session_start();
$_SESSION['days']= $_POST['days'];
$_SESSION['room_price']= $_POST['room_price'];
$_SESSION['room_type']= $_POST['room_type'];

// echo variable from the session, we set this on our other page
//$_SESSION['checkin'] = $_POST['checkin'];
//$_SESSION['checkout'] = $_POST['checkout'];
//$_SESSION['rooms']= $_POST['rooms'];
//$_SESSION['adults']= $_POST['adults'];
//$_SESSION['children']= $_POST['children'];

?>

<html>
<body>
<h3><center>
   Room's Reservation
</center></h3>
<form action="DisplayDetails.php" method="post">

  <table width="373" border="1">
    <tr>
      <td colspan="2"><strong>Reservation Summary</strong></td>
    </tr>
    <tr>
      <td>Check In :</td>
      <td><label> <?php echo $_SESSION['checkin']; ?> </label></td>
    </tr>
    <tr>
      <td>Check Out :</td>
      <td><label><?php echo $_SESSION['checkout']; ?></label></td>
    </tr>
    <tr>
      <td>Rooms :</td>
      <td><label><?php echo $_SESSION['rooms']; ?></label></td>
    </tr>
    <tr>
      <td>Adults Per Room :</td>
      <td><label><?php echo $_SESSION['adults']; ?></label></td>
    </tr>
    <tr>
      <td>Children Per Room :</td>
      <td><label><?php echo $_SESSION['children']; ?></label></td>
    </tr>
    <tr>
      <td>Days :</td>
      <td><?php echo $_SESSION['days']; ?></td>
    </tr>
    <tr>
      <td>Room Type</td>
      <td><?php echo $_SESSION['room_type']; ?></td>
    </tr>
    <tr>
      <td>Room Price</td>
      <td><?php echo $_SESSION['room_price']; ?></td>
    </tr>
  </table>
</form>

</body>
</html>


any kinds of help really apprecited
  • 0

#2 faith89

faith89

    CC Newcomer

  • Just Joined
  • PipPip
  • 14 posts

Posted 20 March 2010 - 12:16 AM

i try to trace the output based on the session using this cod :

echo "<pre>";
var_dump($_SESSION);
echo "</pre>"; 


it produce that this kind of result:

array(8) {
  ["checkin"]=>
  string(12) " 	2010-03-01"
  ["checkout"]=>
  string(12) " 	2010-03-24"
  ["rooms"]=>
  string(1) "1"
  ["adults"]=>
  string(1) "1"
  ["children"]=>
  string(1) "1"
  ["days"]=>
  int(23)
  ["room_price"]=>
  NULL
  ["room_type"]=>
  NULL
}



it shows that my room_type and room_price which is the data that i wanted to take from the query at the page findroom.php is NULL. i wonderi if i'm using the right code to take the data from query is right or not?
can someone tell me is this sysntax is right or not?


$_SESSION['room_price']=$data['room_price'];
$room_price=$_SESSION['room_price'];

$_SESSION['room_type']=$data['room_type'];
$room_type=$_SESSION['room_type'];


or can someone tell me is it actually possible to take the data from the query and the make it as session variable?
  • 0





Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download