can i insert value from another page into next page query

pollysal · March 21, 2010

i have 2 forms here.

1) DisplayDetails.php

2) RegistrationForm.php

when user click to the link 'Next' at the DisplayDetails.php page it will bring

all the session value to the RegistrationForm.php page. But, there's also value which is not session which is

i) $room_type

so, at the RegistrationForm, i wanted to passed all the values from the DisplayDetails.php into mysql query

to insert into database.After i test it, all the data work fine including the session values from DisplayDetails.php.

The only problem is, value which is i) $room_type

that i got from the query in the DisplayDetails.php as the only that

unsuccessfully inserted into the database.

So, the question is, is it possible for me to get value from the DisplayDetails.php page into

RegistrationForm.php page query so that i can insert the value into database.

below is the code for DisplayDetails.php


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

$id_no=$_GET['id_no'];


$query="SELECT * from room1 WHERE id_no=$id_no";

$result=mysql_query($query);

//Get the number of rows in array for loop
$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {
$id_no=mysql_result($result,$i,"id_no");
$room_no=mysql_result($result,$i,"room_no");
$room_type=mysql_result($result,$i,"room_type");
$qty=mysql_result($result,$i,"qty");
$room_price=mysql_result($result,$i,"room_price");

//echo "$id_no - $room_no - $room_type - $qty - $rom_price";

$i++;
} 

?>

<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 $room_type; ?></td>
    </tr>
    <tr>
      <td>Room Price</td>
      <td><?php echo $room_price; ?></td>
    </tr>
    <tr>
      <td>TOTAL PRICE :</td>
      <td><?php $total =$_SESSION['days'] * $room_price;
  		echo $total;?>        </td>
    </tr>
  </table>  
  <label>
  <input type="submit" name="submit" id="submit" value="submit" />
  </label>
  <a href="RegistrationForm.php"><strong> 
  Next >> </strong></a>
</form>
</body>
</html>

below is the code for RegistrationForm.php

<?php
session_start();
?>
<html>
<body>

<form action="RegistrationForm.php" method="post">

<p><strong>REGISTRATION FORM</strong></p>

<table width="285" border="1">
   <tr>
     <th width="120" scope="row">Name :</th>
     <td width="149"><label>
      <input type="text" name="name" id="name" value="<?php $name; ?>"/>
     </label></td>
   </tr>
   <tr>
     <th scope="row">Ic No :</th>
     <td><label>
       <input type="text" name="ic_no" id="ic_no" value="<?php $ic_no; ?>">
     </label></td>
   </tr>
   <tr>
     <th scope="row">Contact No :</th>
     <td><label>
       <input type="text" name="contact_no" id="contact_no" value="<?php $contact_no; ?>">
     </label></td>
   </tr>
   <tr>
     <th scope="row">Email :</th>
     <td><label>
       <input type="text" name="email" id="email" value="<?php $email; ?>">
     </label></td>
   </tr>
   <tr>
     <th scope="row">Gender :</th>
     <td><label>
       <select name="gender" id="gender" value="<?php $gender; ?>">
         <option>female</option>
         <option>male</option>
      </select>
     </label></td>
   </tr>
   <tr>
     <th scope="row">Username :</th>
     <td><label>
       <input type="text" name="username" id="username" value="<?php $username; ?>">
     </label></td>
   </tr>
   <tr>
     <th scope="row">Password :</th>
     <td><label>
       <input type="text" name="password" id="password" value="<?php $password; ?>">
     </label></td>
   </tr>
</table>
<p>
</p>
<p>
   <label>
   <input type="submit" name="submit" id="submit" value="Submit">
   </label>
   
      <?php


$room_type=$_POST['room_type'];

$sql="INSERT INTO reservation1 
(name,ic_no, gender,checkin,checkout,
room_type)
VALUES
('$_POST[name]','$_POST[ic_no]','$_POST[gender]','$_SESSION[checkin]','$_SESSION[checkout]',
'$_POST[room_type]')";
?>

</p>
</form>

</body>
</html>

teamatomic · March 21, 2010

$_SESSION['room_type']=$room_type;

HTH

Teamatomic

Sign In

can i insert value from another page into next page query

Recommended Posts

pollysal

Link to comment

Share on other sites

teamatomic

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information