📄 die_other_prise.php
字号:
<?
require_once('include/connection.php');
include('include/admin_or_user.php');
?>
<?
if(!empty($_GET['room_number']))
$sql="select * from dept_2 where room_number='".base64_decode($_GET['room_number'])."' order by id ";
else
$sql="select * from dept_2 order by id";
$detail=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>
</head>
<body>
<table width="600" border="1" align="center">
<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>
</tr>
<? $total=0;
while(odbc_fetch_row($detail)) {
$total=$total+1;
?>
<tr>
<td><div align="center">
<? echo $total;?></div></td>
<td><div align="center">
<? echo odbc_result($detail,2);?></div></td>
<td><div align="center">
<? echo odbc_result($detail,5);?></div></td>
<td><div align="center">
<? echo odbc_result($detail,4);?></div></td>
</tr>
<? }
if($total==0)
echo "无记录";
odbc_close($conn);
?>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -