PHP+MySQL實現的簡單投票系統執行個體_php技巧

來源:互聯網
上載者:User

本文執行個體講述了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"> GoogleGoogle<br><input type="radio" name="phone" value="5"> Winphone微軟<input type="radio" name="phone" value="6"> 其它<br><input type="submit" value="提交"></form><span>當前票數:<br><?phpinclude '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>

寫的有點囉嗦,有點笨但很實用

<?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程式設計有所協助。

相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.