Example of implementing WeChat voting function using PHP and MySql-PHP Tutorial-php.cn

Example of implementing WeChat voting function using PHP and MySql

黄舟

Release： 2023-03-16 13:30:01

Original

1312 people have browsed it

1. Main voting page:

<!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>
</head>
  
<body>
  
<form action="TouChuLi.php" method="post">
<?phpinclude ("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 "<p><h2>{$tmmc}:</h2></p>";
//从调研选项表中输出选项内容：
$sqlxx="select * from diaoyanxuanxiang where timudaihao=&#39;{$tmdh}&#39;";
$arrxx=$db->query($sqlxx);
echo "<p id=&#39;list&#39;>";
foreach ($arrxx as $v)
{  echo "<p><input type=&#39;checkbox&#39; value=&#39;{$v[0]}&#39; name=&#39;xx[]&#39;>{$v[1]}</p><br />";
}  
?>
<input type="submit" value="提交">
<input type="button" value="查看结果" id="check" onclick="Showjieguo()">
</form>
</p>
  
<p id="jieguo" style="display:none">
<?php//计算总人数：$sqlzs="select sum(numbers) from diaoyanxuanxiang where timudaihao=&#39;{$tmdh}&#39;";$zrs=$db->query($sqlzs);  
foreach ($arrxx as $v)
{    
  $name=$v[1];  $number=$v[2];  if($zrs[0][0]==0)
   {     $bfb = 0;
   }   else
   {     $bfb = ($number/$zrs[0][0])*100;
   }  $bfb=round($bfb,2);  echo "<p>
    <span class=&#39;x&#39;>{$name} </span>
    <p class=&#39;x&#39; style=&#39;width:200px; height:10px; background-color:#808080&#39;>
    <p style=&#39;width:{$bfb}%; height:10px; background-color:#FF8040&#39;> </p>
    </p>
    <span class=&#39;x&#39;>{$number} </span>
    <span class=&#39;x&#39;>{$bfb}% </span>
    </p>
    <br />    "; 
}?>
<input type="button" value="返回" id="fanhui" onclick="Showfanhui()">
</p>
<script>function Showjieguo()
{
  document.getElementById("list").style.display="none";
  document.getElementById("jieguo").style.display="block";
  }function Showfanhui()
{
  document.getElementById("list").style.display="block";
  document.getElementById("jieguo").style.display="none";
  }</script>
  
</body>
</html>

Copy after login

2. Processing voting page:

<?php$arr=$_POST["xx"];include ("../DBDA.class.php");$db=new DBDA();  
  
foreach($arr as $v)
{  $sql = "update diaoyanxuanxiang set numbers = numbers+1 where ids = &#39;{$v}&#39;";  
$db->Query($sql,1);//1代表$sql的类型
}
header ("location:TouPiao.php");
?>

Copy after login

3. Create Class for accessing the database, encapsulated for reference:

<?php//执行一个sql语句，返回相应的结果class DBDA
{  public $host="localhost";//数据库服务器地址
  public $uid="root";//数据库用户名
  public $password="";//数据库密码
  //执行SQL语句的方法
  //参数里面：$sql代表要执行的sql语句；$type是sql语句的类型，0代表查询，1代表其他(增删改)；$db代表要操作的数据库
  function Query($sql,$type=0,$db="0710_info")
  {    //造连接对象
    $dbconnect=new MySQLi($this->host,$this->uid,$this->password,$db);    //判断连接是否出错
    !mysqli_connect_error() or die("连接失败！");    //执行sql语句
    $result=$dbconnect->query($sql);    //判断SQL语句类型
    if($type==0)
    {       //如果是查询语句返回结果集的二维数组
      return $result->fetch_all();
      }    else
    {      //如果是其他语句，返回true或false
      return $result;
      }   
    }
      
  }

Copy after login

The above is the detailed content of Example of implementing WeChat voting function using PHP and MySql. For more information, please follow other related articles on the PHP Chinese website!