PHP+MySQL实现的简单投票系统实例
本文实例讲述了PHP+MySQL实现的简单投票系统。分享给大家供大家参考,具体如下:
当前票数:手机系统调查问卷 你现在使用的手机是什么系统?
<?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); ?>
android | Symbian | iphone | winphone | other | |
---|---|---|---|---|---|
<?php echo $android ?>票 | <?php echo $symbian ?>票 | <?php echo $iphone ?>票 | <?php echo $google ?>票 | <?php echo $winphone ?>票 | <?php echo $other ?>票 |
<?php for ($i=1;$i<=$android/$total+1;$i=$i+0.1){ echo ""; } ?> | <?php for ($i=1;$i<=$symbian/$total+1;$i=$i+0.1){ echo ""; } ?> | <?php for ($i=1;$i<=$iphone/$total+1;$i=$i+0.1){ echo ""; } ?> | <?php for ($i=1;$i<=$google/$total+1;$i=$i+0.1){ echo ""; } ?> | <?php for ($i=1;$i<=$winphone/$total+1;$i=$i+0.1){ echo ""; } ?> | <?php for ($i=1;$i<=$other/$total+1;$i=$i+0.1){ echo ""; } ?> |
写的有点啰嗦,有点笨但很实用
<?php include 'connect.php'; $name=$_POST['phone']; $sql="insert into countone values(null,$name,now(),null)"; mysql_query($sql); ?>
PHP之友评论