📄 room.php
字号:
<?
include('../include/admin_or_user.php');
require_once('../include/connectionadmin.php');
$selectsql="select distinct room.room_number,room.room_person,roomlevel.room_level,roomlevel.room_prise,roomlevel.room_introduction from room,roomlevel where room.room_level=roomlevel.room_level order by roomlevel.room_level,room.room_number,room.room_person,roomlevel.room_prise asc";
$result=odbc_exec($conn,$selectsql);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<link href="../css/hotel.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
margin-left: 36px;
margin-right: 36px;
}
.STYLE1 {color: #FF0000}
-->
</style></head>
<body>
<span class="greenclore">房间信息</span>
<table width="100%" border="1" cellpadding="0" cellspacing="1">
<tr>
<td width="6%"><div align="center">房间号</div></td>
<td width="8%"><div align="center">房间星级</div></td>
<td width="15%"><div align="center">房间价格/人/天</div></td>
<td width="10%"><div align="center">可入住人数</div></td>
<td width="56%"><div align="center">房间介绍</div></td>
<td width="5%"><div align="center">操作</div></td>
</tr>
<? while(odbc_fetch_row($result)){?>
<tr>
<td><div align="center"><? echo odbc_result($result,'room_number');?></div></td>
<td><div align="center"><? echo odbc_result($result,'room_level');?>星级</div></td>
<td><div align="center"><span class="STYLE1">¥</span><? echo odbc_result($result,'room_prise')*odbc_result($result,'room_person');?> /天</div></td>
<td><div align="center"><? echo odbc_result($result,'room_person');?>人房</div></td>
<td> <? echo odbc_result($result,'room_introduction');?></td>
<td><a href="modefiyroom.php?room_number=<? echo base64_encode(odbc_result($result,'room_number'));?> ">修改</a></td>
</tr>
<? }?>
</table>
<p \>
<script src="../copyright.inc">
</script>
</body>
</html>
<? odbc_close($conn);
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -