php查询操作实现投票功能.docVIP

php查询操作实现投票功能 “-//W3C//DTD XHTML 1.0 Transitional//EN” “/TR/xhtml1/DTD/xhtml1-transitional.dtd” lt;html xmlns=“/1999/xhtml” lt;head lt;meta http-equiv=“Content-Type” content=“text/html; charset=utf-8” / lt;title投票lt;/title lt;style #list { nbsp; width:400px; nbsp; height:300px;} #jieguo { nbsp; width:400px; nbsp; height:300px;} .x { nbsp; float:left;} lt;/style lt;/head lt;body lt;form action=“TouChuLi.php” method=“post” lt;?php include (“DBDA.class.php”); $db=new DBDA(); //从调研题目表中找出题目代号和名称 $sql=“select * from diaoyantimu limit 0,1”; $arr=$db-query($sql); $tmmc=$arr[0][1]; $tmdh=$arr[0][0]; echo “lt;divlt;h2{$tmmc}:lt;/h2lt;/div”; //从调研选项表中输出选项内容： $sqlxx=“select * from diaoyanxuanxiang where timudaihao=‘{$tmdh}’”; $arrxx=$db-query($sqlxx); echo “lt;div id=‘list’”; foreach ($arrxx as $v) { nbsp; echo “lt;divlt;input type=‘checkbox’ value=‘{$v[0]}’ name=‘xx[]’{$v[1]}lt;/divlt;br /”; } ? lt;input type=“submit” value=“提交” lt;input type=“button” value=“查看结果” id=“check” onclick=“Showjieguo()” lt;/form lt;/div lt;div id=“jieguo” style=“display:none” lt;?php //计算总人数： $sqlzs=“select sum(numbers) from diaoyanxuanxiang where timudaihao=‘{$tmdh}’”; $zrs=$db-query($sqlzs); foreach ($arrxx as $v) { nbsp; $name=$v[1]; nbsp; $number=$v[2]; nbsp; if($zrs[0][0]==0) nbsp; nbsp;{ nbsp; nbsp; nbsp;$bfb = 0; nbsp; nbsp;} nbsp; nbsp;else nbsp; nbsp;{ nbsp; nbsp; nbsp;$bfb = ($number/$zrs[0][0])*100; nbsp; nbsp;} nbsp; $bfb=round($bfb,2); nbsp; echo “lt;div nbsp; nbsp; lt;span class=‘x’{$name} lt;/span nbsp; nbsp; lt;div class=‘x’ style=‘width:200px; height:10px; background-color:#808080’ nbsp; nbsp; lt;div style=‘width:{$bfb}%; height:10px; background-color:#FF8040’ lt;/div nbsp; nbsp; lt;/div nbsp; nbsp; lt;span class=‘x’{$number} lt;/span nbsp; nbsp; lt;span class=‘x’{$bfb}% lt;/span nbsp; nbsp; lt;/div nbsp; nbsp; lt;br / nbsp; nbsp; “;nbsp; }