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

Discussion in 'PHP' started by sally89, Mar 20, 2010.

  1. #1
    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>
    
    
    Code (markup):
    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>
    
    
    Code (markup):
    any kinds of help really apprecited
     
    sally89, Mar 20, 2010 IP