Simple voting system example implemented by PHP+MySQL

WBOY
Release: 2016-07-29 09:01:15
Original
923 people have browsed it

The example in this article describes a simple voting system implemented by PHP+MySQL. Share it with everyone for your reference, the details are as follows:

<html>
<head><title>手机系统调查问卷</title>
<style type="text/css">
<!--
span{
  width:600px;
  height:100px;
  background-color:write;
  postion:relative;
  border:1px #cccccc solid;
}
div{
  width:60px;
  height:1px;
  background-color:blue;
  postion:absolute;
  bottom:0;
}
-->
</style>
</head>
<body>
你现在使用的手机是什么系统?
<form method="POST" action="count.php">
<input type="radio" name="phone" value="1"> Android安卓
<input type="radio" name="phone" value="2"> Symbian塞班
<br>
<input type="radio" name="phone" value="3"> iphone苹果
<input type="radio" name="phone" value="4"> Google谷歌
<br>
<input type="radio" name="phone" value="5"> Winphone微软
<input type="radio" name="phone" value="6"> 其它
<br>
<input type="submit" value="提交">
</form>
<span>
当前票数:<br>
<&#63;php
include 'connect.php';
$sql="select answer from countone";
$rs=mysql_query($sql);
$total=mysql_num_rows($rs);
$sql="select * from countone where answer=1";
$rs=mysql_query($sql);
$android=mysql_num_rows($rs);
$sql="select * from countone where answer=2";
$rs=mysql_query($sql);
$symbian=mysql_num_rows($rs);
$sql="select * from countone where answer=3";
$rs=mysql_query($sql);
$iph
$sql="select * from countone where answer=4";
$rs=mysql_query($sql);
$google=mysql_num_rows($rs);
$sql="select * from countone where answer=5";
$rs=mysql_query($sql);
$winph
$sql="select * from countone where answer=6";
$rs=mysql_query($sql);
$other=mysql_num_rows($rs);
&#63;>
<table border="0">
<th>android</th><th>Symbian</th><th>iphone</th><th>Google</th><th>winphone</th><th>other</th>
<tr>
<td><&#63;php echo $android &#63;>票</td>
<td><&#63;php echo $symbian &#63;>票</td>
<td><&#63;php echo $iphone &#63;>票</td>
<td><&#63;php echo $google &#63;>票</td>
<td><&#63;php echo $winphone &#63;>票</td>
<td><&#63;php echo $other &#63;>票</td>
</tr>
<tr>
<td><&#63;php for ($i=1;$i<=$android/$total+1;$i=$i+0.1){  echo "<div></div>"; } ?></td>
<td><&#63;php for ($i=1;$i<=$symbian/$total+1;$i=$i+0.1){  echo "<div></div>"; } ?></td>
<td><&#63;php for ($i=1;$i<=$iphone/$total+1;$i=$i+0.1){  echo "<div></div>"; } ?></td>
<td><&#63;php for ($i=1;$i<=$google/$total+1;$i=$i+0.1){  echo "<div></div>"; } ?></td>
<td><&#63;php for ($i=1;$i<=$winphone/$total+1;$i=$i+0.1){ echo "<div></div>"; } ?></td>
<td><&#63;php for ($i=1;$i<=$other/$total+1;$i=$i+0.1){ echo "<div></div>"; } ?></td>
</tr>
</table>
</span>
</body>
</html>

Copy after login

The writing is a bit verbose, a bit stupid but very practical

<&#63;php
include 'connect.php';
$name=$_POST['phone'];
$sql="insert into countone values(null,$name,now(),null)";
mysql_query($sql);
&#63;>
<script type="text/javascript">
 alert ("投票成功!");
 location="question.php";
</script>

Copy after login

Link to mysql:

<&#63;php
mysql_connect("localhost","root","");
mysql_select_db("vote");
mysql_query("set names utf8");
&#63;>

Copy after login

Readers who are interested in more PHP related content can check it out Special topics of this site: "Introduction Tutorial on PHP Object-Oriented Programming", "Summary of PHP String Usage", "Introduction Tutorial on PHP+mysql Database Operation" and "Summary of PHP Common Database Operation Skills"

I hope this article will help Everyone PHP programming helps.

The above introduces an example of a simple voting system implemented by PHP+MySQL, including the relevant content. I hope it will be helpful to friends who are interested in PHP tutorials.

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template