Page 1 of 1

$_POST['']

Posted: Thu Dec 07, 2006 6:27 am
by hrubos
number_room are outputed by query selecting from table Room, and radiobutton besides it to book room and insert into table RESERVATION. I can insert id_reservation into table.

But I don't know how to insert number_room into table RESERVATION, because when I use $_POST, number_room was undefined --> ofcourse not query

How to do to insert both of id_reservation and number_room in table RESERVATION.

Code: Select all

<?php
require_once ("D:\htdocs\BP\db_connectFun.php");
//require_once(".php");
db_connect();

$query="SELECT DISTINCT p.id_numberRoom,p.number_room,p.building,p.floor,p.state_room,
p.id_typeRoom, t.number_beg,t.price
FROM pokoj p,type_room t
WHERE p.id_typeRoom = t.id_typeRoom
  AND p.state_room = 'volný'";


$result=mysql_query($query)or die(mysql_error());

$num=mysql_numrows($result);
mysql_close();


$i=0;

while($i<$num){
$id_numberRoom=mysql_result($result,$i,"id_numberRoom");
$number_room=mysql_result($result,$i,"number_room");
$building=mysql_result($result,$i,"building");
$floor=mysql_result($result,$i,"floor");
$number_beg=mysql_result($result,$i,"number_beg");
$price=mysql_result($result,$i,"price");

?>
<tr>
<?php
$n=0;
echo "<td>$id_numberRoom</td>" ;
echo "<td>$number_room</td>" ;
echo "<td>$floor</td>";
echo "<td>$building</td>";
echo "<td>$number_beg</td>";
echo "<td>$price</td>";
echo "<td> <input type= 'radio' value = '$n' name= 'id_reservation'></td>";
$i++;
}
?>
<tr>
<td>
 <input type="submit" value="Submit" name="submit">
 </td>
</tr>
</tr>
</form>
 </body>
</html>

Code: Select all

<?php

$id_reservation = $_POST['id_reservation'];
$number_room=$_GET['$number_room'];

if(!get_magic_quotes_gpc())
 {
 $id_reservation  = addslashes($id_reservation);
 }

 @ $db = mysql_connect("localhost", "root","") or die("Error");
 mysql_select_db("db",$db) or die("Can't choose database");
  $query = "insert into reservation " . "(id_reservation,number_room) values"
		. "('$id_reservation','$number_room')";
		 mysql_query($query) or die(mysql_error());
 ?>

Posted: Thu Dec 07, 2006 8:56 am
by Buddha443556
How about putting both numbers in the radio button separated by say a comma? On the receiving end, just explode() the value.

Not exactly a database question.