checkbox
Posted: Tue Jan 02, 2007 8:04 am
How to make condition to make loop after chosing by checkbox???
I use form so I have 2 pages : edit_display.php and edit_function.php
I use form so I have 2 pages : edit_display.php and edit_function.php
Code: Select all
$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");
$state_room=mysql_result($result,$i,"state_room");
?>
<tr>
<?php
$n = 0;
echo "<td width= '90'><div align= 'center'>$number_room</div></td>" ;
echo "<td width= '90'><div align= 'right'>$floor</div></td>";
echo "<td width= '90'><div align= 'right'>$building</div></td>";
echo "<td width= '90'><div align= 'right'>$number_beg</div></td>";
echo "<td width= '90'><div align= 'right'>$price</div></td>";
echo "<td width= '90'><div align= 'right'>$state_room</div></td>";
echo "<td width= '60'><div align= 'right'><input type='checkbox' name='id_numberRoom[]' value= '$id_numberRoom'></div></td>" ;
$i++;
}Code: Select all
$id_numberRoom = $_POST['id_numberRoom'];
if(isset($_POST['submit'])) {
for ($t=0; $t<count($id_numberRoom);$t++) {
$query="SELECT DISTINCT p.id_numberRoom,p.number_room,p.state_room,
p.id_typeRoom,t.price
FROM room p,type_room t
WHERE p.id_typeRoom = t.id_typeRoom
AND id_numberRoom = '$id_numberRoom[t]'";
$result=mysql_query($query)or die(mysql_error());
$num=mysql_numrows($result);
}
$i=0;
while ($i<$num){
$id_numberRoom=mysql_result($result,$i,"id_numberRoom");
$number_room=mysql_result($result,$i,"number_room");
$price=mysql_result($result,$i,"price");
$state_room=mysql_result($result,$i,"state_room");
?>
<tr>
<?php
echo "<td><input type='hidden' name='new_id_numberRoom' value='$id_numberRoom'></td>" ;
echo "<td><input type='text' name='new_number_room' value= '$number_room' size='8' style='font-family:Arial'></td>" ;
echo "<td><input type='text' name='new_price' size='10' value= '$price' size='8' style='font-family:Arial'></td>";
echo "<td><input type='text' name='new_state_room' size='10' value= '$state_room' size='8' style='font-family:Arial'></td>";
$i++;
}
}
?>