📄 moneydetail.php

📁 酒店管理系统
💻 PHP
字号:
<?
require_once('include/connection.php'); 
?>
<?

$sql="select * from charge where time like '%".$_GET['key']."%' order by time desc";
$result=odbc_exec($conn,$sql);




?>



<!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" />
</head>

<body>
<p><span class="greenclore">账户详细信息</span></p>
<table width="100%" border="1">
  <tr>
    <td><div align="center">编号</div></td>
    <td><div align="center">房间号</div></td>
    <td><div align="center">结帐时间</div></td>
	<td><div align="center">入住天数</div></td>
	 <td><div align="center">房间费用</div></td>
	  <td><div align="center">饮食费用</div></td>
	  <td><div align="center">其它费用</div></td>
	   <td><div align="center">共</div></td>
	 
  </tr>
  <? 
  $i=0;
  while(odbc_fetch_row($result))
    {  $i++;?>
  <tr>
    <td><div align="center"><? echo $i;?></div></td>
   
    <td>&nbsp;<? echo odbc_result($result,'room_number');?></td>
    <td>&nbsp;&nbsp;<? echo odbc_result($result,'time');?></td>
	  <td><div align="center"><? echo odbc_result($result,'days');?></div></td>
   <td><div align="center"><span class="redclore">￥</span><? echo odbc_result($result,'room_prise');?></div></td>
   <td><div align="center"><span class="redclore">￥</span><? echo odbc_result($result,'dieing_prise');?></div></td>
    <td><div align="center"><span class="redclore">￥</span><? echo odbc_result($result,'other_prise');?></div></td>
   <td><div align="center"><span class="redclore">￥</span><? echo odbc_result($result,'total_prise');?></div></td>
     
  </tr>
  <? } if($i==0)
   echo "
   <tr>
     <td colspan='11'>
   <p align='center' class='STYLE1'>暂无记录</p>
   </td>
   </tr>";
   ?>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -