voteresult.php

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>
<?
	}
?>