📄 hour.php
字号:
<?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</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n\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/system.gif\" WIDTH=\"22\" HEIGHT=\"20\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 时段统计</span>\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n\r\n";
$TOTAL_COUNT = 1;
$I = 0;
for ( ; $I <= 23; ++$I )
{
if ( $I < 10 )
{
$query = "SELECT count(*) from SYS_LOG where RIGHT(TIME,8)>='0".$I.":00:00' and RIGHT(TIME,8)<='0".$I.":59:59'";
}
else
{
$query = "SELECT count(*) from SYS_LOG where RIGHT(TIME,8)>='".$I.":00:00' and RIGHT(TIME,8)<='".$I.":59:59'";
}
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$HOUR_COUNT[$I] = $ROW[0];
}
$TOTAL_COUNT += $HOUR_COUNT[$I];
}
echo "<table border=\"0\" width=\"70%\" cellpadding=\"0\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n <tr>\r\n <td class=\"TableHeader\">\r\n <img src=\"/images/green_arrow.gif\" WIDTH=\"20\" HEIGHT=\"18\"> 总访问量小时分布统计\r\n </td>\r\n </tr>\r\n <tr>\r\n <td class=\"TableData\">\r\n <table border=\"0\" height=\"100%\" cellspacing=\"2\" cellpadding=\"0\" class=\"small\">\r\n <tr>\r\n <td width";
echo "=\"42\" valign=\"top\">\r\n <table border=\"0\" width=\"100%\" height=\"100%\" align=\"right\" cellspacing=\"0\" cellpadding=\"0\" class=\"small\">\r\n <tr>\r\n <td width=\"100%\" align=\"right\">";
echo "<s";
echo "pan style=\"font-family: 宋体\"> </span>";
echo max( $HOUR_COUNT );
echo "</td>\r\n </tr>\r\n <tr>\r\n <td width=\"100%\" align=\"right\">";
echo "<s";
echo "pan style=\"font-family: 宋体\"> </span>";
echo ceil( max( $HOUR_COUNT ) * 0.8 );
echo "</td>\r\n </tr>\r\n <tr>\r\n <td width=\"100%\" align=\"right\">";
echo "<s";
echo "pan style=\"font-family: 宋体\"> </span>";
echo ceil( max( $HOUR_COUNT ) * 0.6 );
echo "</td>\r\n </tr>\r\n <tr>\r\n <td width=\"100%\" align=\"right\">";
echo "<s";
echo "pan style=\"font-family: 宋体\"> </span>";
echo ceil( max( $HOUR_COUNT ) * 0.4 );
echo "</td>\r\n </tr>\r\n <tr>\r\n <td width=\"100%\" align=\"right\">";
echo "<s";
echo "pan style=\"font-family: 宋体\"> </span>";
echo ceil( max( $HOUR_COUNT ) * 0.2 );
echo "</td>\r\n </tr>\r\n </table>\r\n </td>\r\n";
$I = 0;
for ( ; $I <= 23; ++$I )
{
echo " <td width=\"42\" height=\"100\" align=\"center\" valign=\"bottom\">\r\n <table border=\"0\" width=\"15\" cellspacing=\"0\" cellpadding=\"0\" class=\"graph\" id=\"table3\">\r\n <tr>\r\n <td width=\"100%\" valign=\"bottom\" align=\"center\"><img border=\"0\" src=\"/images/column.gif\" width=\"15\"></td>\r\n </tr>\r\n <tr>\r\n <td width=\"100%\" height=\"";
echo floor( $HOUR_COUNT[$I] * 100 / max( $HOUR_COUNT ) );
echo "\" background=\"/images/column.gif\" valign=\"bottom\"></td>\r\n </tr>\r\n </table>\r\n </td>\r\n";
}
echo " </tr>\r\n <tr>\r\n <td align=\"right\">0</td>\r\n <td height=30 align=\"center\">0</td>\r\n <td height=30 align=\"center\"></td>\r\n <td height=30 align=\"center\">2</td>\r\n <td height=30 align=\"center\"></td>\r\n <td height=30 align=\"center\">4</td>\r\n <td height=30 align=\"center\"></td>\r\n <td height=30 align=\"center\">6</td>\r\n <td height=30 alig";
echo "n=\"center\"></td>\r\n <td height=30 align=\"center\">8</td>\r\n <td height=30 align=\"center\"></td>\r\n <td height=30 align=\"center\">10</td>\r\n <td height=30 align=\"center\"></td>\r\n <td height=30 align=\"center\">12</td>\r\n <td height=30 align=\"center\"></td>\r\n <td height=30 align=\"center\">14</td>\r\n <td height=30 align=\"center\"></td>\r\n <td height=30 a";
echo "lign=\"center\">16</td>\r\n <td height=30 align=\"center\"></td>\r\n <td height=30 align=\"center\">18</td>\r\n <td height=30 align=\"center\"></td>\r\n <td height=30 align=\"center\">20</td>\r\n <td height=30 align=\"center\"></td>\r\n <td height=30 align=\"center\">22</td>\r\n <td height=30 align=\"center\"></td>\r\n </tr>\r\n </table>\r\n\r\n </td>\r\n </tr>\r\n</table>\r\n<br>\r\n\r";
echo "\n<table border=\"0\" cellspacing=\"1\" width=\"70%\" align=\"center\" class=\"small\" bgcolor=\"#000000\" cellpadding=\"3\">\r\n <tr>\r\n <td nowrap class=\"TableHeader\" colspan=\"3\">\r\n <img src=\"/images/green_arrow.gif\" WIDTH=\"20\" HEIGHT=\"18\"> 总访问量小时分布数据\r\n </td>\r\n </tr>\r\n";
$I = 0;
for ( ; $I <= 23; ++$I )
{
echo " <tr class=\"TableData\">\r\n <td>\r\n <table border=\"0\" width=\"100%\" align=\"right\" cellspacing=\"0\" cellpadding=\"0\" class=\"small\">\r\n <tr>\r\n <td nowrap align=\"center\" width=\"80\">";
echo $I;
echo "</td>\r\n <td nowrap align=\"center\">";
echo round( $HOUR_COUNT[$I] * 100 / $TOTAL_COUNT );
echo "%</td>\r\n <td nowrap align=\"center\" width=\"100\">";
echo $HOUR_COUNT[$I];
echo "</td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n";
}
echo "</table>\r\n\r\n</body>\r\n</html>\r\n";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -