📄 voteresult.php
字号:
<?
include("db_conn.php");
include("db_func.php");
//算出总投票数
$SQLSum = "SELECT SUM(t_count) from vote WHERE v_id = '$v_id'";
$res = db_query($SQLSum);
$row = db_fetch_array($res);
$countall = $row[0];
$SQLStr = "SELECT v_name FROM votesubject WHERE v_id = '$v_id'";
$res = db_query($SQLStr);
$row = db_fetch_array($res);
$subject = $row[0];
$SQLStr = "SELECT * FROM vote WHERE v_id = '$v_id'";
$res = db_query($SQLStr);
if (db_num_rows($res)>0)
{
?>
<table width="480" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" align='center'>
<tr>
<td>
<table width="480" border="1" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" bgcolor="#99CCFF">
<tr>
<td align="center"><b><?=$subject?></b></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="480" border="0" cellspacing="0" cellpadding="0" bgcolor="#DDDDDD">
<tr>
<td colspan="2" align='center'>题目</td>
<td colspan="2" align='center'>比率</td>
<td width="40" align='center'>票数</td>
</tr>
</table>
<table width="480" border="0" cellspacing="0" cellpadding="0">
<?
$num = db_num_rows($res);
for ($i=0;$i<$num;$i++)
{
$row = db_fetch_array($res);
$per = floor(($row['t_count']/$countall)*100) . "%";
echo "<tr>";
echo "<td width='10' align='center'>" . $row['t_id'] . "-</td>";
echo "<td width='270'>" . $row['t_name'] . "</td>";
echo "<td width='100'><img src='images/bar1.gif' height='10' width='" . $per . "'></td>";
echo "<td width='40' align='center'>" . $per . "</td>";
echo "<td width='40' align='center'>" . $row['t_count'] . "</td>";
echo "</tr>";
}
echo "<tr><td colspan='5'><br></td></tr>";
echo "<tr><td colspan='4' align='right'>总投票人数:</td>";
echo "<td align='center'>" . $countall . "</td></tr>";
?>
</table>
</td>
</tr>
</table>
<?
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -