i have 2 forms here.
1) DisplayDetails. php
2) RegistrationFor m.php
when user click to the link 'Next' at the DisplayDetails. php page it will bring
all the session value to the RegistrationFor m.php page. But, there's also value which is not session which is
i) $room_type
so, at the RegistrationFor m, 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
RegistrationFor m.php page query so that i can insert the value into database.
below is the code for DisplayDetails. php
below is the code for RegistrationFor m.php
1) DisplayDetails. php
2) RegistrationFor m.php
when user click to the link 'Next' at the DisplayDetails. php page it will bring
all the session value to the RegistrationFor m.php page. But, there's also value which is not session which is
i) $room_type
so, at the RegistrationFor m, 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
RegistrationFor m.php page query so that i can insert the value into database.
below is the code for DisplayDetails. php
Code:
<?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:
<?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>
Comment