Simple voting system developed by PHP with complete voting display function module
The previous chapter explains the function implementation of each module of the voting display page
Click to select the voting function
View the voting results function
In this section we will fully demonstrate these functions in the index.php file
<?php
ob_start();
session_start();
header("Content-type:text/html;charset=utf-8");
$link = mysqli_connect('localhost','username','password','test');
mysqli_set_charset($link, "utf8");
if (!$link) {
die("连接失败:".mysqli_connect_error());
}
?>
<!doctype html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>投票系统</title>
<script type="text/javascript" src="//cdn.bootcss.com/jquery/1.12.4/jquery.js"></script>
<style type="text/css">
/*全局样式*/
body { font-family: "宋体"; font-size: 12pt; color: #333333; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;background-color: #A6C7E1;}
table { font-family: "宋体"; font-size: 9pt; line-height: 20px; color: #333333}
a:link { font-size: 9pt; color: #333333; text-decoration: none}
a:visited { font-size: 9pt; color: #333333; text-decoration: none}
a:hover { font-size: 9pt; color: #E7005C; text-decoration: underline}
a:active { font-size: 9pt; color: #333333; text-decoration: none}
/*全局样式结束*/
</style>
<script language="javascript">
function check()
{
node=frm.itm;
flag=false;
for(i=0;i<node.length;i++)
{
if(node[i].checked)
{
flag=true;
}
}
if(!flag)
{
alert("您没有选择")
return false;
}
return true;
}
</script>
<?php
if(isset($_POST["submit"])){
if($_POST){
$id = $_POST["selected_id"];
$sql = "update vote set count = count+1 where id=$id";
mysqli_query($link,$sql);
}
if($_SESSION["vote"]==session_id())
{
?>
<script language="javascript">
alert("您已经投票了");
location.href="index.php";
</script>
<?php
exit();
}
$id=$_POST["itm"];
$sql="update vote set count=count+1 where id=$id";
if(mysqli_query($link,$sql))
{
$_SESSION["vote"]=session_id();
?>
<script language="javascript">alert("投票成功,点确定查看结果");location.href="index.php?id=ck";</script>
<?php
}
else
{
?>
<script language="javascript">alert("投票失败");location.href="index.php";</script>
<?php
}
}
?>
</head>
<body>
<form name="frm" action="" method="post" onsubmit=return(check()) style="margin-bottom:5px;">
<table width="365" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#C2C2C2">
<tr>
<th bgcolor="#FFFFCC">
<?php
$sql="select * from votetitle";
$rs=mysqli_query($link,$sql);
$row=mysqli_fetch_assoc($rs);
echo $row["votetitle"];
?> </th>
</tr>
<?php
$sql="select * from vote";
$rs=mysqli_query($link,$sql);
while($rows=mysqli_fetch_assoc($rs))
{
?>
<tr>
<td bgcolor="#FFFFFF"><input type="radio" name="itm" value="<?php echo $rows["id"]?>" />
<?php echo $rows["item"]?></td>
</tr>
<?php
}
?>
<tr>
<td align="center" bgcolor="#FFFFFF">
<input type="submit" name="submit" value="投票"/>
<input type="hidden" id="selected_id" name="selected_id" value="">
<input type="button" value="查看结果" onClick="location.href='index.php?id=ck'"/>
<script type="text/javascript">
$("[type='radio']").click(function(){
$("#selected_id").val($(this).val());
});
</script></td>
</tr>
</table>
</form>
<?php
if(isset($_GET["id"])=="ck"){?>
<?php
$sql="select sum(count) as 'total' from vote";
$rs=mysqli_query($link,$sql);
$rows=mysqli_fetch_assoc($rs);
$sum=$rows["total"]; //得出总票数
$sql="select * from vote";
$rs=mysqli_query($link,$sql);
?>
<table id="click" width="365" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#C2C2C2" >
<tr>
<th bgcolor="#FFFFFF">项目</th>
<th bgcolor="#FFFFFF">票数</th>
<th bgcolor="#FFFFFF">百分比</th>
</tr>
<?php
while($rows=mysqli_fetch_assoc($rs))
{
?>
<tr>
<td bgcolor="#FFFFFF"><?php echo $rows["item"]?></td>
<td bgcolor="#FFFFFF"><?php echo $rows["count"]?></td>
<td bgcolor="#FFFFFF">
<?php
$per=$rows["count"]/$sum;
$per=number_format($per,4);
?>
<img src="" height="4" width="<?php echo $per*100?>" />
<?php echo $per*100?>% </td>
</tr>
<?php
}
?>
</table>
<div align="center">
<a href="index.php">隐藏结果</a>
</div>
<?php } ?>
</body>
</html>Note: This chapter only briefly demonstrates various functions , its code is for learning reference only.
new file
<?php
ob_start();
session_start();
header("Content-type:text/html;charset=utf-8");
$link = mysqli_connect('localhost','username','password','test');
mysqli_set_charset($link, "utf8");
if (!$link) {
die("连接失败:".mysqli_connect_error());
}
?>
<!doctype html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>投票系统</title>
<script type="text/javascript" src="//cdn.bootcss.com/jquery/1.12.4/jquery.js"></script>
<style type="text/css">
/*全局样式*/
body { font-family: "宋体"; font-size: 12pt; color: #333333; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;background-color: #A6C7E1;}
table { font-family: "宋体"; font-size: 9pt; line-height: 20px; color: #333333}
a:link { font-size: 9pt; color: #333333; text-decoration: none}
a:visited { font-size: 9pt; color: #333333; text-decoration: none}
a:hover { font-size: 9pt; color: #E7005C; text-decoration: underline}
a:active { font-size: 9pt; color: #333333; text-decoration: none}
/*全局样式结束*/
</style>
<script language="javascript">
function check()
{
node=frm.itm;
flag=false;
for(i=0;i<node.length;i++)
{
if(node[i].checked)
{
flag=true;
}
}
if(!flag)
{
alert("您没有选择")
return false;
}
return true;
}
</script>
<?php
if(isset($_POST["submit"])){
if($_POST){
$id = $_POST["selected_id"];
$sql = "update vote set count = count+1 where id=$id";
mysqli_query($link,$sql);
}
if($_SESSION["vote"]==session_id())
{
?>
<script language="javascript">
alert("您已经投票了");
location.href="index.php";
</script>
<?php
exit();
}
$id=$_POST["itm"];
$sql="update vote set count=count+1 where id=$id";
if(mysqli_query($link,$sql))
{
$_SESSION["vote"]=session_id();
?>
<script language="javascript">alert("投票成功,点确定查看结果");location.href="index.php?id=ck";</script>
<?php
}
else
{
?>
<script language="javascript">alert("投票失败");location.href="index.php";</script>
<?php
}
}
?>
</head>
<body>
<form name="frm" action="" method="post" onsubmit=return(check()) style="margin-bottom:5px;">
<table width="365" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#C2C2C2">
<tr>
<th bgcolor="#FFFFCC">
<?php
$sql="select * from votetitle";
$rs=mysqli_query($link,$sql);
$row=mysqli_fetch_assoc($rs);
echo $row["votetitle"];
?> </th>
</tr>
<?php
$sql="select * from vote";
$rs=mysqli_query($link,$sql);
while($rows=mysqli_fetch_assoc($rs))
{
?>
<tr>
<td bgcolor="#FFFFFF"><input type="radio" name="itm" value="<?php echo $rows["id"]?>" />
<?php echo $rows["item"]?></td>
</tr>
<?php
}
?>
<tr>
<td align="center" bgcolor="#FFFFFF">
<input type="submit" name="submit" value="投票"/>
<input type="hidden" id="selected_id" name="selected_id" value="">
<input type="button" value="查看结果" onClick="location.href='index.php?id=ck'"/>
<script type="text/javascript">
$("[type='radio']").click(function(){
$("#selected_id").val($(this).val());
});
</script></td>
</tr>
</table>
</form>
<?php
if(isset($_GET["id"])=="ck"){?>
<?php
$sql="select sum(count) as 'total' from vote";
$rs=mysqli_query($link,$sql);
$rows=mysqli_fetch_assoc($rs);
$sum=$rows["total"]; //得出总票数
$sql="select * from vote";
$rs=mysqli_query($link,$sql);
?>
<table id="click" width="365" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#C2C2C2" >
<tr>
<th bgcolor="#FFFFFF">项目</th>
<th bgcolor="#FFFFFF">票数</th>
<th bgcolor="#FFFFFF">百分比</th>
</tr>
<?php
while($rows=mysqli_fetch_assoc($rs))
{
?>
<tr>
<td bgcolor="#FFFFFF"><?php echo $rows["item"]?></td>
<td bgcolor="#FFFFFF"><?php echo $rows["count"]?></td>
<td bgcolor="#FFFFFF">
<?php
$per=$rows["count"]/$sum;
$per=number_format($per,4);
?>
<img src="" height="4" width="<?php echo $per*100?>" />
<?php echo $per*100?>% </td>
</tr>
<?php
}
?>
</table>
<div align="center">
<a href="index.php">隐藏结果</a>
</div>
<?php } ?>
</body>
</html>
Preview
Clear
- Course Recommendations
- Courseware download
The courseware is not available for download at the moment. The staff is currently organizing it. Please pay more attention to this course in the future~
Students who have watched this course are also learning
Let's briefly talk about starting a business in PHP
Quick introduction to web front-end development
Large-scale practical Tianlongbabu development of Mini version MVC framework imitating the encyclopedia website of embarrassing things
Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]
Login verification and classic message board
Computer network knowledge collection
Quick Start Node.JS Full Version
The front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original]
Write your own PHP MVC framework (40 chapters in depth/big details/must read for newbies to advance)