📄 showprise.php

📁 酒店管理系统

💻 PHP

字号:

<? 
 require_once('include/connection.php'); 
 include('include/admin_or_user.php');
 require_once('include/sqlfuns.php');

 ?>
 <?
 $selectsql="select distinct  room.room_person,roomlevel.room_level,roomlevel.room_prise from room,roomlevel where room.room_level=roomlevel.room_level order by roomlevel.room_level,room_person";
 $rs=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>
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
-->
</style>
<link href="css/hotel.css" rel="stylesheet" type="text/css" />
</head>

<body>
<table width="49%" border="0" align="center">
  <tr>
    <td><div align="center" class="greenclore">房间价格列表</div></td>
  </tr>
  <tr>
    <td><table width="100%" border="1" cellpadding="0" cellspacing="1">
  <tr>
    <td width="8%"><div align="center">房间星级</div></td>
	<td width="10%"><div align="center">人数</div></td>
    <td width="15%"><div align="center">房间价格/天</div></td>
  </tr>
  <? while(odbc_fetch_row($rs)){?>
  <tr>
    <td><div align="center"><? echo odbc_result($rs,'room_level');?>星级</div></td>
	<td><div align="center"><? echo odbc_result($rs,'room_person');?>人房</div></td>
    <td><div align="center"><span class="STYLE2 STYLE1">&yen;</span><? echo odbc_result($rs,'room_prise')*odbc_result($rs,'room_person');?>&nbsp;/天</div></td>
  </tr>
  <? }?>
</table></td>
  </tr>
</table>
<p></p>
 <script src="copyright.inc">
</script>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -