viewpoll.php

php开发实例完全剖析

<?php
// 包含数据库连接文件和头文件
require ('dbconnect.php');
include('head.php');
// 获得参数，得到投票主题id
	$id=$_GET[id];
?>
<?
// 取得投票主题标题
$titlesql="select * from title where id='$id'";
$titleresult=mysql_query($titlesql,$conn);
$title=mysql_fetch_array($titleresult);

// 获得投票结果
$sql="select * from vote where titleid= '$id'";
$result=mysql_query($sql,$conn);

// 获得参与投票总人数
$emailsql="select * from email where id='$id'";
$email_re=mysql_query($emailsql,$conn);
$votenum=mysql_num_rows($email_re);

?>
<table border="0" width="80%" cellspacing="0" cellpadding="0" align=center>
<tr>
  <td width="100%" colspan="4">
  <p align="center"><font color="#FF0000">"<?echo $title[title];?>"的投票结果</font></p>
  </td></tr>
  <tr>
  <td width="100%" colspan="4">
  <p align="center">(共有<?echo $votenum;?>人参与投票)</font></p>
  </td></tr>
<tr>
  <td width="30%">　</td>
  <td width="10%">　</td>
  <td width="50%">　</td>
  <td width="10%">　</td>
</tr>
<tr>
  <td width="30%" align="center">
      <font size="2" color="#0000FF">选&nbsp;&nbsp;项</font></td>
  <td width="10%" align="center">
      <font size="2" color="#0000FF">票&nbsp;&nbsp;数</font></td>
  <td width="60%" colspan="2" align="center">
      <font size="2" color="#0000FF">比&nbsp;&nbsp;例</font></td>
</tr>
<?
// 计算所有选项的总票数
$num=0;
while($row=mysql_fetch_array($result)){
	$num+=$row[vcount];
}
// 设置行指针
mysql_data_seek($result,0);
// 柱状显示各选项比例
while($bar=mysql_fetch_array($result)){
	echo "<tr>";
	echo "<td width='30%' align='center'>";
    echo "<font size='2' color='#0000FF'>$bar[info]</font></td>";
	echo "<td width='10%' align='center'>";
    echo "<font size='2' color='#0000FF'>$bar[vcount]</font></td>";
	echo "<td width='50%' >";
	// 计算比例
	$scale=(int)($bar["vcount"]/$num*100);
	$bar_width=$scale*500/100;
	if ($scale!=0){
	    echo "<img src='./bar.gif' width=$bar_width height=10></td>";
	}
	else{
		echo "</td>";
	}
	echo "<td width='10%' align='center'>";
    echo "<font size='2' color='#0000FF'>$scale%</font></td>";
	echo "</tr>";
}
?>

<tr>
  <td width="30%">　</td>
  <td width="10%">　</td>
  <td width="50%">　</td>
  <td width="10%">　</td>
</tr>

<!--<tr><td colspan=4 align=center><a href='circle_result.php?id=$id'>饼图显示结果</a></td></tr>-->
</table>