复选框选择,点击提交上传数据库,点击查看显示百分比
封装类的代码
<?php /** * Created by PhpStorm. * User: Administrator * Date: 2016/6/16 * Time: 11:23 */ class DBDA { public $host="localhost";//服务器地址 public $uid="root" ;//用户名 public $pwd="";//密码 public $dbconnect;//链接对象 function Query($sql,$type=1,$dbname="aaas")//sql语句;type语句类型,数字来表示;数据库的默认值 { $this->dbconnect = new mysqli($this->host,$this->uid,$this->pwd,$dbname); //判断是否出错 if(!mysqli_connect_error()) { //如果连接成功,执行SQL语句 $result = $this->dbconnect->query($sql); //根据语句类型判断 if($type==1) { //如果是查询语句,返回二维数组 return $result->fetch_all(); } else { //如果是其他语句,返回true或false return $result; } } else { return "连接失败!"; } } }
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>投票系统</title>
<style type="text/css">
.x
{
float:left;
}
#top
{
width: 500px;
height: 200px;
}
#bottom
{
width: 500px;
height: 200px;
display: none;
}
#fanhui
{
display: none;
}
</style>
</head>
<body>
<form action="0616toupiaocl.php" method="post">
<?php
include("0616DBDA.class.php");
$db=new DBDA();//造对象
$stm="select * from diaoyantimu limit 0,1";//查出数据,取第一条
$atm=$db->query($stm);//执行,返回二维数组
echo "<div>题目名称:{$atm[0][1]}</div>";//显示题目名称
//输出选项
$atm[0][0];//题目代号
//查调研选项表
$sxx="select * from diaoyanxuanxiang where timudaihao='{$atm[0][0]}'";
$axx=$db->query($sxx);//存放选项的二维数组
echo "<div id='top'>";
foreach($axx as $v)
{
echo
"<div>
<input type='checkbox' value='{$v[0]}' name='xx[]'>{$v[1]}
</div>";
}
echo "</div>";
?>
<div id="bottom">
<?PHP
$sum="select sum(numbers) from diaoyanxuanxiang where timudaihao='{$atm[0][0]}'";//查出数目总和
$asum=$db->query($sum);
$total=$asum[0][0];//总人数
foreach($axx as $v)
{
$bfb=($v[2]/$total)*100;//投该选项的人数百分比
echo "<div><span class='x'>{$v[1]}</span>
<div class='x' style='border:2px solid #a414a1;width:120px; height:12px'>
<div style='background-color:#292aff;width:{$bfb}%;height:12px'></div>
</div>
<span class='x'>{$v[2]}</span>
<span class='x'> {$bfb}%</span>
</div><br>";
}
?>
</div>
<div id="anniu"><input type="submit" value="提交"><input type="button" value="查看" οnclick="showresult()"></div>
<div id="fanhui"><input type="button" value="返回" οnclick="show()"></div>
</form>
</body>
<script type="text/javascript">
function showresult()
{
document.getElementById("top").style.display="none";
document.getElementById("bottom").style.display="block";
document.getElementById("fanhui").style.display="block";
document.getElementById("anniu").style.display="none";
}
function show()
{
document.getElementById("top").style.display="block";
document.getElementById("bottom").style.display="none";
document.getElementById("fanhui").style.display="none";
document.getElementById("anniu").style.display="block";
}
</script>
</html>
<?php
/**
* Created by PhpStorm.
* User: Administrator
* Date: 2016/6/17
* Time: 10:53
*/
$ids=$_POST["xx"];
include("0616DBDA.class.php ");
$db=new DBDA();
foreach($ids as $v)
{
$sql= "update diaoyanxuanxiang set numbers=numbers+1 where ids='{$v}'";
$db->query($sql,0);
}
header("location:0617toupiao.php");