要求:
选择第一个页面的复选框值,点击提交则提交数据,点击查看结果在同一页面覆盖显示结果的投票人数,百分比和进度条,点击返回,返回第一页面
数据库为 投票
表格为diaoyanxx
表格内容为:
zhuye.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>无标题文档</title> <style type="text/css"> * { margin:0px; padding:0px; } h3 { margin:10px; } .diyiceng { height:220px; width:200px; background-color:#0F6; position:absolute; visibility:visible; left:10px; top:40px; } .dierceng { height:220px; width:800px; background-color:#6FC; position:absolute; visibility:hidden; left:0px; top:0px; } .xuanxiang { position:absolute; } .jindu { width:200px; height:10px; position:absolute; left:100px; border:solid #999 1px; } .jindutiao { height:8px; position:absolute; background-color:#0F0; border:solid 1px #00FF00; } .shuzi { position:absolute; left:320px; } .baifenbi { position:absolute; left:350px; } </style> </head> <body> <h3>你35岁的发展方向?</h3> <div class="diyiceng" id="diyiceng"> <form action="xiugai.php" method="post"> <?php $db=new mysqli("localhost","root","123","投票"); if(mysqli_connect_error()) { echo "连接错误"; } else { $sql="select * from diaoyanxx"; $resulttp=$db->query($sql); while($row = $resulttp->fetch_row()) { echo "<div><input type='checkbox' name='test[]' value='".$row[0]."'/>".$row[1]."</div><br />"; } } ?> <input type="submit" name="submit" value="提交" /> <input type="button" name="chakan" value="查看结果" οnclick="xianshi()"/> </form> <?php $db=new mysqli("localhost","root","123","投票"); if(mysqli_connect_error()) { echo "连接错误"; } else { $sql="select * from diaoyanxx"; $result=$db->query($sql); echo "<div class='dierceng' id='yincang'>"; echo "<form>"; $sqlsum = "select SUM(numbers) from diaoyanxx"; $resultsum = $db->query($sqlsum); $aa = $resultsum->fetch_row(); $zongshu = $aa[0]; while($rowjg = $result->fetch_row()) { $xuanxiang = $rowjg[1]; $shuliang = $rowjg[2]; $baifenbi = $shuliang/$zongshu*100; $baifenbi1=round($baifenbi,1);//对小数取一位 echo "<div><div class='xuanxiang'>".$xuanxiang."</div><div class='jindu'><div class='jindutiao' style='width:".$baifenbi."%'></div></div><div class='shuzi'>".$shuliang."</div><div class='baifenbi'>".$baifenbi1."%</div></div><br /><br />"; } echo "<input type='button' name='fanhui' value='返回' οnclick='buxianshi()' />"; echo "</form>"; echo "</div></div>"; } ?> </body> </html> <script> function xianshi() { var a=document.getElementById("yincang"); if(a.style.visibility="hidden") { a.style.visibility="visible"; } } function buxianshi() { var a=document.getElementById("yincang"); if(a.style.visibility="visible") { a.style.visibility="hidden"; } } </script>
xiugai.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>无标题文档</title> </head> <body> <?php $test=$_POST["test"]; //1.造连接对象 $db=new mysqli("localhost","root","123","投票"); //2.判断是否连接成功 if(mysqli_connect_error()) { echo "连接失败"; } else { for($i=0;$i<count($test);$i++) { $sql="update diaoyanxx set numbers=numbers+1 where ids='".$test[$i]."'"; $result=$db->query($sql); } //判断是否修改成功 if($result) { header("Location:zhuye.php"); } else { echo "修改失败!"; } } ?> </body> </html>