1.建立数据库
表1:DiaoYanTiMu
表2:DiaoYanXuanXiang
2.页面
页面1:投票首页
无标题文档#fanhui{ display:none}
$db = new MySQLi("localhost","root","123","mydb");
$sql = "select * from diaoyantimu";
$result = $db->query($sql);
$attr = $result->fetch_all();
foreach($attr as $v)
{
echo "
$sxx = "select * from diaoyanxuanxiang where timudaihao='{$v[0]}'";
$rxx = $db->query($sxx);
$axx = $rxx->fetch_all();
$bs = 0;
if(!empty($_GET["a"]))
{
$bs = $_GET["a"];
}
$s = $bs==1?"none":"block";
echo "
foreach($axx as $v1)
{
echo "
}
echo "
$s1 = $bs==0?"none":"block";
//显示投票结果
echo "
foreach($axx as $v2)
{
$v2[2]; //当前选项的人数
//求总人数
$szrs = "select sum(numbers) from diaoyanxuanxiang where timudaihao='{$v[0]}'";
$rzrs = $db->query($szrs);
$azrs = $rzrs->fetch_row();
$azrs[0]; //总人数
$bfb = ($v2[2]/$azrs[0])*100;
echo "
$sql = "update diaoyanxuanxiang set numbers = numbers+1 where ids in('{$str}')";
$db = new MySQLi("localhost","root","123","mydb");
$db->query($sql);
header("location:toupiao.php?a=1");
来源:https://www.cnblogs.com/ysdong/p/6028197.html