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> Code (markup): 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> Code (markup):
maybe I'm just missing something here. seems you do not have the room type as a form field on the displaydetails.php page. so where exactly is room type coming from ? One method for multi step forms is to pass them as hidden form inputs then posting to the database as this helps reduce partial entries.
you could use javascript with your existing php and go ajax/php and skip out on the intervening forms. simply make the click an event that grabs those variables, and run it to a processing php page. or make that form's action a javascript function that takes that information and sends it to a processing php file.