voteresult.php

来自「php模块设计。。。里面的模块很有学习价值」· PHP 代码 · 共 87 行

<?

	include("db_conn.php");
	include("db_func.php");

	// 计算出 t_count 加总的值 (也就是总票数) BEGIN
	$SQLSum = "SELECT SUM(t_count) from vote WHERE v_id = '$v_id'";
	$res = db_query($SQLSum);
	$row = db_fetch_array($res);
	$countall = $row[0];
	// 计算出 t_count 加总的值 (也就是总票数) END

	// 取出投票的主题 BEGIN
	$SQLStr = "SELECT v_name FROM votesubject WHERE v_id = '$v_id'";
	$res = db_query($SQLStr);
	$row = db_fetch_array($res);
	$subject = $row[0];
	// 取出投票的主题 END

	// 取出同一个投票主题的选项数据 BEGIN
	$SQLStr = "SELECT * FROM vote WHERE v_id = '$v_id'";
	$res = db_query($SQLStr);
	// 取出同一个投票主题的选项数据 END

	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);

	// 逐笔输出每个选项的得票数 BEGIN
	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>";

                // 呈现百分比数字及得票数 BEGIN
		echo "<td width='40' align='center'>" . $per . "</td>";
		echo "<td width='40' align='center'>" . $row['t_count'] . "</td>";
                // 呈现百分比数字及得票数 END

		echo "</tr>";
	}
	// 逐笔输出每个选项的得票数 END

	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>
<?
	} // 若无数据则不执行此页程序
?>