📄 show_reader.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.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<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$connection = openconnection( );
$query = "SELECT * from VOTE_TITLE where VOTE_ID={$VOTE_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SUBJECT = $ROW['SUBJECT'];
$TO_ID = $ROW['TO_ID'];
$ANONYMITY = $ROW['ANONYMITY'];
$READERS = $ROW['READERS'];
}
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/notify.gif\" align=\"absmiddle\">";
echo "<s";
echo "pan class=\"big3\"> 投票结果 - ";
echo $SUBJECT;
echo "</span><br>\r\n </td>\r\n </tr>\r\n</table>\r\n\r\n<table border=\"0\" width=\"95%\" cellpadding=\"3\" cellspacing=\"1\" align=\"center\" bgcolor=\"#000000\" class=\"small\">\r\n <tr class=\"TableHeader\" align=\"center\">\r\n <td>选项</td>\r\n <td width=\"240\">图标</td>\r\n <td width=\"50\">票数</td>\r\n <td>投票人员</td>\r\n </tr>\r\n";
$query = "SELECT sum(VOTE_COUNT),max(VOTE_COUNT) from VOTE_ITEM where VOTE_ID={$VOTE_ID}";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$SUM_COUNT = $ROW[0];
$MAX_COUNT = $ROW[1];
}
if ( $SUM_COUNT == 0 )
{
$SUM_COUNT = 1;
}
$query = "SELECT * from VOTE_ITEM where VOTE_ID={$VOTE_ID}";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$ITEM_ID = $ROW['ITEM_ID'];
$ITEM_NAME = $ROW['ITEM_NAME'];
$VOTE_COUNT = $ROW['VOTE_COUNT'];
$VOTE_USER = $ROW['VOTE_USER'];
if ( $ANONYMITY == "0" )
{
$VOTE_USER_NAME = "";
$query = "SELECT * from USER where find_in_set(USER_ID,'{$VOTE_USER}')";
$cursor1 = exequery( $connection, $query );
while ( $ROW1 = mysql_fetch_array( $cursor1 ) )
{
$VOTE_USER_NAME .= $ROW1['USER_NAME'].",";
}
$VOTE_USER_NAME = substr( $VOTE_USER_NAME, 0, -2 );
}
echo " <tr class=\"TableData\">\r\n <td> ";
echo $ITEM_NAME;
echo "</td>\r\n <td width=\"240\">\r\n <table height=\"10\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" class=\"small\">\r\n <tr height=\"10\">\r\n <td width=\"10\" background=\"/images/vote_bg.gif\"></td>\r\n <td width=\"";
echo $VOTE_COUNT * 200 / $MAX_COUNT;
echo "\" background=\"/images/vote_bg.gif\"></td>\r\n <td width=\"30\">";
echo floor( $VOTE_COUNT * 100 / $SUM_COUNT );
echo "%</td>\r\n </tr>\r\n </table>\r\n </td>\r\n <td align=\"right\">";
echo $VOTE_COUNT;
echo "票</td>\r\n <td style=\"cursor:hand\" title=\"";
echo $VOTE_USER_NAME;
echo "\">";
echo csubstr( $VOTE_USER_NAME, 0, 30 ).( 30 < strlen( $VOTE_USER_NAME ) ? "..." : "" );
echo "</td>\r\n </tr>\r\n";
}
echo "\r\n</table>\r\n<div align=\"center\">\r\n <br>\r\n <input type=\"button\" class=\"BigButton\" value=\"关闭\" onclick=\"window.close();\">\r\n</div>\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -