$_POST['']
Posted: Thu Dec 07, 2006 6:27 am
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.
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());
?>