软件开发|编程技术|编程代码|编程入门先学什么—程序设计语言

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

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

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

htmlheadtitle手机系统调查问卷/titlestyle 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/headbody你现在使用的手机是什么系统?form id="form1" method="POST" action="count.php"input type="radio" name="phone" value="1" Android安卓input type="radio" name="phone" value="2" Symbian塞班brinput type="radio" name="phone" value="3" iphone苹果input type="radio" name="phone" value="4" Google谷歌brinput type="radio" name="phone" value="5" Winphone微软input type="radio" name="phone" value="6" 其它brinput type="submit" value="提交"/formspan当前票数:brphpinclude '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"thandroid/ththSymbian/ththiphone/ththGoogle/ththwinphone/ththother/thtrtdphp echo $android 票/tdtdphp echo $symbian 票/tdtdphp echo $iphone 票/tdtdphp echo $google 票/tdtdphp echo $winphone 票/tdtdphp echo $other 票/td/trtrtdphp for ($i=1;$i=$android/$total+1;$i=$i+0.1){  echo "div/div"; } /tdtdphp for ($i=1;$i=$symbian/$total+1;$i=$i+0.1){  echo "div/div"; } /tdtdphp for ($i=1;$i=$iphone/$total+1;$i=$i+0.1){  echo "div/div"; } /tdtdphp for ($i=1;$i=$google/$total+1;$i=$i+0.1){  echo "div/div"; } /tdtdphp for ($i=1;$i=$winphone/$total+1;$i=$i+0.1){ echo "div/div"; } /tdtdphp for ($i=1;$i=$other/$total+1;$i=$i+0.1){ echo "div/div"; } /td/tr/table/span/body/html

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

phpinclude '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:

phpmysql_connect("localhost","root","");mysql_select_db("vote");mysql_query("set names utf8");

更多关于PHP相关内容感兴趣的读者可查看本站专题:《php面向对象程序设计入门教程》、《php字符串(string)用法总结》、《php+mysql数据库操作入门教程》及《php常见数据库操作技巧汇总》

希望本文所述对大家PHP程序设计有所帮助。