PHP+MySQL实现的简单投票系统实例_PHP教程

PHP+MySQL实现的简单投票系统实例

2020-12-22 18:13Sword_A PHP教程

这篇文章主要介绍了PHP+MySQL实现的简单投票系统,以完整实例形式分析了PHP+MySQL实现投票功能的具体功能代码与相关技巧,需要的朋友可以参考下

本文实例讲述了PHP+MySQL实现的简单投票系统。分享给大家供大家参考，具体如下：

									<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 id="form1" 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>

									<?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);

									$iphone=mysql_num_rows($rs);

									$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);

									$winphone=mysql_num_rows($rs);

									$sql="select * from countone where answer=6";

									$rs=mysql_query($sql);

									$other=mysql_num_rows($rs);

									?>

									<table border="0">

									<th>android</th><th>Symbian</th><th>iphone</th><th>Google</th><th>winphone</th><th>other</th>

									<tr>

									<td><?php echo $android ?>票</td>

									<td><?php echo $symbian ?>票</td>

									<td><?php echo $iphone ?>票</td>

									<td><?php echo $google ?>票</td>

									<td><?php echo $winphone ?>票</td>

									<td><?php echo $other ?>票</td>

									</tr>

									<tr>

									<td><?php for ($i=1;$i<=$android/$total+1;$i=$i+0.1){  echo "<div></div>"; } ?></td>

									<td><?php for ($i=1;$i<=$symbian/$total+1;$i=$i+0.1){  echo "<div></div>"; } ?></td>

									<td><?php for ($i=1;$i<=$iphone/$total+1;$i=$i+0.1){  echo "<div></div>"; } ?></td>

									<td><?php for ($i=1;$i<=$google/$total+1;$i=$i+0.1){  echo "<div></div>"; } ?></td>

									<td><?php for ($i=1;$i<=$winphone/$total+1;$i=$i+0.1){ echo "<div></div>"; } ?></td>

									<td><?php for ($i=1;$i<=$other/$total+1;$i=$i+0.1){ echo "<div></div>"; } ?></td>

									</tr>

									</table>

									</span>

									</body>

									</html>

写的有点啰嗦，有点笨但很实用

									<?php

									include 'connect.php';

									$name=$_POST['phone'];

									$sql="insert into countone values(null,$name,now(),null)";

									mysql_query($sql);

									?>

									<script type="text/javascript">

									 alert ("投票成功！");

									 location="question.php";

									</script>

链接mysql：

									<?php

									mysql_connect("localhost","root","");

									mysql_select_db("vote");

									mysql_query("set names utf8");

									?>