if($roomID!=null)
{
$result=mysql_query("SELECT roomID,roomtype,roomsize FROM room WHERE roomID NOT IN (SELECT roomID FROM bookingroom WHERE bookingdate='$bookingdate' AND bookingtime='$bookingtime') AND roomID='$roomID'");
$num_rows = mysql_num_rows($result);
if ($num_rows==0) {
echo "<p align=\"center\">Sorry, No result found. Please search again.</p>";
}
else{ while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>".$row['roomID']."</td>";
echo "<td>".$row['roomtype']."</td>";
echo "<td>".$row['roomsize']."</td>";
echo "<td><input type=\"submit\" name=\"submit\" value=\"Book\"onClick=\"if(confirm('Are you sure you want to book this room?'))location='insert_data.php'\")/></td>";
echo "</tr>";
}
}
}
怎么把我网页界面选择的那行数据传到insert_data.php去呢PHPMySQL搜索
{
$result=mysql_query("SELECT roomID,roomtype,roomsize FROM room WHERE roomID NOT IN (SELECT roomID FROM bookingroom WHERE bookingdate='$bookingdate' AND bookingtime='$bookingtime') AND roomID='$roomID'");
$num_rows = mysql_num_rows($result);
if ($num_rows==0) {
echo "<p align=\"center\">Sorry, No result found. Please search again.</p>";
}
else{ while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>".$row['roomID']."</td>";
echo "<td>".$row['roomtype']."</td>";
echo "<td>".$row['roomsize']."</td>";
echo "<td><input type=\"submit\" name=\"submit\" value=\"Book\"onClick=\"if(confirm('Are you sure you want to book this room?'))location='insert_data.php'\")/></td>";
echo "</tr>";
}
}
}
怎么把我网页界面选择的那行数据传到insert_data.php去呢PHPMySQL搜索
解决方案 »
- PHP中使用正则表达式统计
- 简单问题,数组排序
- 请教各位大虾在php中怎么读取javascript中的变量
- php调webservice的中文乱码问题!!!!!!!!!!
- 请教:对页面的链接搜索,如根据index.php中的链接,对该文件中指向到自身的,或如上一页、下一页的循环链接,该怎么处理?
- 上传文件请问????
- 在用gd作图的时候不能用sql语句,为什么?在线!
- 帮忙看看
- 如何解决图像显示问题?
- 求个P标签的正则匹配,匹配第一段的内容
- 3.7兆的图片为什么用不了imagecreatefromjpeg函数
- PHP Warning: json_encode(): Invalid UTF-8 sequence in argument in
echo "<td><input type=\"submit\" name=\"submit\" value=\"Book\"onClick=\"if(confirm('Are you sure you want to book this room?'))location='insert_data.php?id=".$row['roomID']."'\")/></td>";在文件名后面增加ID参数,参数值为对应行数据的ID
在另一边php得到就行了