pollysal Posted March 21, 2010 Share Posted 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> Quote Link to comment https://forums.phpfreaks.com/topic/195966-can-i-insert-value-from-another-page-into-next-page-query/ Share on other sites More sharing options...
teamatomic Posted March 21, 2010 Share Posted March 21, 2010 $_SESSION['room_type']=$room_type; HTH Teamatomic Quote Link to comment https://forums.phpfreaks.com/topic/195966-can-i-insert-value-from-another-page-into-next-page-query/#findComment-1029354 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.