数据访问类---投票

一、制作投票页面

<body>
	<form action="toupiaochuli.php" method="post">
<?php
	require_once "DBDB.class.php";//加载数据访问类
	$db = new DBDB();
	$sql = "select * from diaoyantimu";
	$arr = $db -> query($sql);
	foreach($arr as $v){
		echo "<h2>{$v[1]}:</h2>";
		$sqlxx = "select * from diaoyanxuanxiang where timudaihao = '{$v[0]}'";
		$arrxx = $db->query($sqlxx);
		foreach($arrxx as $vxx){
			echo "<input type='checkbox' name='ck[]' value='{$vxx[0]}'/>{$vxx[1]}<br>";
			//ck[]  一个空数组 
		}	
	}
	
?>
		<br />
		<input type="submit" value="投票">
	</form>
</body>

 

二、做执行代码

<?php
$arr = $_POST["ck"];
require_once "DBDB.class.php";
$db = new DBDB();
$str = implode("','",$arr);//拼接字符串
$sql = "update diaoyanxuanxiang set numbers = numbers+1 where ids in('$str')";
//ck[]数组中所有的索引组合成一个数组用','拼接
$result = $db->query($sql,1);
if($result){
	header("location:jieguo.php");
}else{
	echo"投票失败";
}

 三、显示投票结果

	<style type="text/css">
		.wai{
			width:300px;
			height:30px;
			background:#090;
			}
		.nei{
			height:30px;
			background-color:#F60;
			}	
       </style>
<body>
    <h1>投票结果显示</h1>
<?php
	require_once "DBDB.class.php";//加载数据访问类
	$db = new DBDB();
	$sql = "select * from diaoyantimu";
	$arr = $db -> query($sql);
	foreach($arr as $v){
		echo "<h2>{$v[1]}:</h2>";
		$sqlall = "select sum(numbers) from diaoyanxuanxiang where timudaihao = '{$v[0]}'";
		$arrall = $db->query($sqlall);//获取二维数组。
		$sqlxx = "select * from diaoyanxuanxiang where timudaihao = '{$v[0]}'";
		$arrxx = $db->query($sqlxx);
		foreach($arrxx as $vxx){
			$vxx[2];//投该选项的数量
			$arrall[0][0];//获取二维数组中的唯一的一个值
			$bfb = ($vxx[2]/$arrall[0][0])*100;//百分比
			$bfb1 = ROUND($bfb,2);
			echo "<div><font size='5' color='#090'>{$vxx[1]}</font></div>
		<div class='wai'>
			<div class='nei' style='width:{$bfb1}%;'></div>
			<font color='#F60'>百分比：{$bfb1}%票数：{$vxx[2]}</font>
		</div><br>";
		}	
	}
	
?>
</body>

 

 

posted @ 2018-01-19 11:04  navyyouth  阅读(134)  评论(0)    收藏  举报