room_detail.php

来自「通达网络办公 - Office Anywhere 2008 增强版100%源码(」· PHP 代码 · 共 53 行

PHP
53
字号
<?php

include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title>会议室详情</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n  <tr>\r\n    <td class=\"Big\"><img src=\"/images/menu/meeting.gif\" HEIGHT=\"20\" width=\"20\" align=\"absmiddle\"><span class=\"big3\"> 会议室详情</span>\r\n    </td>\r\n  </tr>\r\n</table>\r\n\r\n";
$query = "SELECT * from MEETING_ROOM";
$cursor = exequery( $connection, $query );
$ROOM_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
	++$ROOM_COUNT;
	$MR_ID = $ROW['MR_ID'];
	$MR_NAME = $ROW['MR_NAME'];
	$MR_CAPACITY = $ROW['MR_CAPACITY'];
	$MR_DEVICE = $ROW['MR_DEVICE'];
	$MR_DESC = $ROW['MR_DESC'];
	$MR_PLACE = $ROW['MR_PLACE'];
	if ( $ROOM_COUNT % 2 == 1 )
	{
		$TableLine = "TableLine1";
	}
	else
	{
		$TableLine = "TableLine2";
	}
	if ( $ROOM_COUNT == 1 )
	{
		echo "<table class=\"TableList\" width=\"95%\" align=\"center\">\r\n  <tr class=\"TableHeader\">\r\n    <td nowrap align=\"center\">名称</td>\r\n    <td nowrap align=\"center\">可容纳人数</td>\r\n    <td align=\"center\">设备情况</td>\r\n    <td nowrap align=\"center\">所在地点</td>\r\n    <td align=\"center\">会议室描述</td>\r\n  </tr>\r\n";
	}
	echo "   <tr class=\"";
	echo $TableLine;
	echo "\">\r\n     <td nowrap align=\"center\">";
	echo $MR_NAME;
	echo "</td>\r\n     <td nowrap align=\"center\">";
	echo $MR_CAPACITY;
	echo "</a></td>\r\n     <td align=\"center\">";
	echo $MR_DEVICE;
	echo "</a></td>\r\n     <td align=\"center\">";
	echo $MR_PLACE;
	echo "</td>\r\n     <td align=\"center\">";
	echo $MR_DESC;
	echo "</td>\r\n   </tr>\r\n";
}
if ( 0 < $ROOM_COUNT )
{
	echo "<tr align=\"center\" class=\"TableControl\">\r\n  <td colspan=\"5\">\r\n     <input type=\"button\" value=\"关闭\" class=\"BigButton\" onClick=\"window.close();\" title=\"关闭窗口\">\r\n  </td>\r\n</tr>\r\n</table>\r\n";
}
else
{
	message( "", "无会议室" );
}
echo "</body>\r\n\r\n</html>\r\n";
?>

⌨️ 快捷键说明

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