投票管理程序
【字号:
大 中 小】
日期:2023-08-29 16:37:14浏览:19作者:馨心
投票管理程序 表结构 CREATE TABLE poll(Poll_Id INT (11) not null AUTO_INCREMENT,Poll_Name char(50) ,Poll_Del INT (10) DEFAULT '0' , PRIMARY KEY (Poll_Id));;;CREATE TABLE pollsele(Pollsele_Id INT (11) not null AUTO_INCREMENT,Pollsele_Name char(50) ,Poll_Del INT (10) DEFAULT '0' , Pollsele_poll_Id INT (10) ,pollsele_num int (10), PRIMARY KEY (Pollsele_Id));;;------------------------------------------------------------------------------------------------- poll.php;;;//主程序 <?;;;;;$db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); $sql="select poll_id,Poll_Name from poll where poll_del='1'"@$result = mysql_query($sql); ;;;;;;$myrow=mysql_fetch_row($result); ;;;;;echo "<table align=center bgcolor=aabbcc width=250 hight=450 border=0 style='border:1px solid rgb(0,0,0)'>"echo "<td align=center bgcolor=99aabb style='border:1px solid rgb(255,255,255)'>";;;;;echo "$myrow[1]";;;;;;$sql="select Pollsele_Name,pollsele_poll_id from pollsele where pollsele_del='0' and pollsele_poll_id='$myrow[0]'"@$result = mysql_query($sql); ;;echo "<FORM ACTION='pollsee.php?poll_id=$myrow[0]' METHOD='post' target=_blank>";;;;echo "<p align=center>";;while($myrow=mysql_fetch_row($result)) ;;;{ ;;;echo "<input type='radio' name=toupiao value='$myrow[0]'>$myrow[0]";;;;echo " ";;;} ;;;echo "<br>";;;echo "<br>";echo "<input type=submit name=submit value='投票' >";;echo "</p>";echo "</form>"echo "</td>";;;;;;echo "</table>";;mysql_close(); ;;;;echo "<br>";;;echo "<p align=right>";;echo "<a href=poll_input>管理</a>"echo "</p>";;;;;;?> ----------------------------------------------------------------------- poll_input.php;;//添加主题 <?$db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); ;;;;;;;$sql="select poll_id,poll_name,poll_del from poll";;;;;echo "<table width=300 hight=560 bgcolor=aabbcc align=center style='border:1px solid rgb(0,0,0)'>";;;;$result=mysql_query($sql); ;;;;;while($my=mysql_fetch_row($result)) ;;;;{ ;;;;echo "<tr>";echo "<td align=center width=50 bgcolor=99aabb style='border: 1px solid rgb(255,255,255)'>";echo $my[0];echo "</td>";;;;;echo "<td align=center width=200 bgcolor=99aabb style='border: 1px solid rgb(255,255,255)'><a href=pollsele.php?id=$my[0]>$my[1]</a></td>";;;echo "<td align=center width=50 bgcolor=99aabb style='border: 1px solid rgb(255,255,255)'>";echo $my[2];echo "</td>"echo "</tr>";};;;;echo "</table>";;?> <html> <head> ;;<? ;;;if($submit2!="添加") ;;;;;{ echo "<p align=center>";;;;echo "<FORM ACTION='poll_input.php' METHOD='post'>"echo "<font color=004080>主题:</font>";;;;;;echo "<input type=text name=title size=30 value=''>";;;;;echo "<input type=submit name=submit2 value='添加'>";;;echo "</p>";;echo"</form>";;;;} else ;;;;;;{$db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); ;;;;;;;$sql="select poll_name from poll where poll_name='$title'";;;;mysql_query($sql); $sql="insert into poll values('','$title','')"mysql_query($sql); mysql_close(); echo "<META HTTP-EQUIV=REFRESH CONTENT='1; URL=poll_input.php'>";;;} ;;;if($submit1!="有效"&&$submit3!="删除") ;;;{;;echo "<p align=center>";;echo "<FORM ACTION='poll_input.php' METHOD='post'>";;echo "<font color=004080>设置主题:</font>";;echo "<select name='sele' size=1>"$db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); $sql="select Poll_Id from poll"$result = mysql_query($sql); mysql_close(); while($myrow=mysql_fetch_row($result)) { echo "<option value='$myrow[0]'>$myrow[0]";} ;;;echo "</select>";;;;echo "<input type=submit name=submit1 value='有效'>"echo "<input type=submit name=submit3 value='删除'>";;;;;;echo "</p>"echo "</FORM>";;} ;;;else ;;;{ ;;;;;;if($submit1=="有效") ;;;;;;{ ;;;$db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); $sql="update poll set Poll_Del='0'"$result = mysql_query($sql); ;;$sql="update poll set Poll_Del='1' where poll_id='$sele'"$result = mysql_query($sql); mysql_close(); echo "<META HTTP-EQUIV=REFRESH CONTENT='1; URL=poll_input.php'>"} ;;;;else ;;;;{;;;$db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); $sql="delete from poll where poll_id='$sele'"$result = mysql_query($sql); $sql="delete from pollsele where pollsele_poll_id='$sele'"mysql_query($sql); mysql_close(); echo "<META HTTP-EQUIV=REFRESH CONTENT='1; URL=poll_input.php'>"} } ?> -------------------------------------------------------------------- pollsele.php;;//添加选项 <?$db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); ;;;;;;;$sql="select pollsele_id,pollsele_name,pollsele_del,pollsele_num from pollsele where pollsele_poll_id='$id'";;;;;echo "<table width=300 hight=560 align=center bgcolor=aabbcc >";;;;@$result=mysql_query($sql); ;;;;;while($my=mysql_fetch_row($result)) ;;;;{ ;;;;echo "<tr>";echo "<td align=center width=50 bgcolor=99aabb;;style='border: 1px solid rgb(255,255,255)'>";echo $my[0];echo "</td>";;;;;echo "<td align=center width=200 bgcolor=99aabb;;style='border: 1px solid rgb(255,255,255)'>$my[1]</td>";;;echo "<td align=center width=50 bgcolor=99aabb;;style='border: 1px solid rgb(255,255,255)'>";echo $my[2];echo "</td>"echo "<td align=center width=50 bgcolor=99aabb;;style='border: 1px solid rgb(255,255,255)'>";echo $my[3];echo "</td>"echo "</tr>";};;;;echo "</table>";;?> <html> <head> ;;<? ;;;if($submit2!="添加") ;;;;;{;;;;;echo "<p align=center>";;;;echo "<FORM ACTION='pollsele.php?id=$id' METHOD='post'>"echo "<font color=004080>选项:</font></td>";;;;;;echo "<input type=text name=title size=30 value=''>";;;;;echo "<input type=submit name=submit2 value='添加'>";;;echo "</p>";;echo"</form>";;;;} else ;;;;;;{$db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); $sql="insert into pollsele values('','$title','','$id','')"mysql_query($sql); mysql_close(); echo "<META HTTP-EQUIV=REFRESH CONTENT='1; URL=pollsele.php?id=$id'>";;;} ;;;if($submit1!="有效"&&$submit3!="无效") ;;;{;;echo "<p align=center>";;echo "<FORM ACTION='pollsele.php?id=$id' METHOD='post'>";;;echo "<font color=004080>设置选项:</font>";;echo "<select name='sele' size=1>"$db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); $sql="select Pollsele_Id from pollsele where pollsele_poll_id='$id'"$result = mysql_query($sql); mysql_close(); while($myrow=mysql_fetch_row($result)) { echo "<option value='$myrow[0]'>$myrow[0]";} ;;;echo "</select>";;;;echo "<input type=submit name=submit1 value='有效'>"echo "<input type=submit name=submit3 value='无效'>";;;;;echo "</p>"echo "</FORM>";;} ;;;else ;;;{ $db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); ;;;;;;if ($submit1=="有效") ;;;;;;{ ;;;;$sql="update pollsele set Pollsele_Del='0' where pollsele_id='$sele'"$result = mysql_query($sql);} else { $sql="update pollsele set Pollsele_Del='1' where pollsele_id='$sele'"$result = mysql_query($sql);;;;} mysql_close(); echo "<META HTTP-EQUIV=REFRESH CONTENT='1; URL=pollsele.php?id=$id'>"} ?> ---------------------------------------------------------------------- pollsee.php;;//投票结果 <?;;;;;;;if ($toupiao!=""){ $db =mysql_connect("localhost", "root","391450"); mysql_select_db("class",$db); ;;$sql="select Pollsele_Name,pollsele_num from pollsele where pollsele_name='$toupiao'"@$result = mysql_query($sql); ;;$myrow=mysql_fetch_row($result); ;;$poll_num=$myrow[1]; ;;$poll_num=$poll_num+1; $sql="update pollsele set Pollsele_num='$poll_num' where pollsele_name='$toupiao'"mysql_query($sql); ;;;;$sql="select Poll_Name from poll where poll_id='$poll_id'"@$result = mysql_query($sql); ;;;;;$title=mysql_fetch_row($result); ;;;;;;;echo "<p align=center>";;;;;echo $title[0]; echo "</p>";;;;;echo "<br>";;;;;;$sql="select Pollsele_Name,pollsele_num from pollsele where pollsele_del='0' and pollsele_poll_id='$poll_id'"@$result = mysql_query($sql); ;;;;;;echo "<table align=center bgcolor=aabbcc style='border:1px solid rgb(0,0,0)'>";while($myrow=mysql_fetch_row($result)) ;;{;;;echo "<tr>"echo "<td width=150 bgcolor=99aabb style='border:1px solid rgb(255,255,255)'>";echo $myrow[0];echo "</td><td width=50 bgcolor=99aabb style='border:1px solid rgb(255,255,255)'>";echo $myrow[1]; echo "</td></tr>";} echo "</table>";;;} ;;else ;;{echo "<font color=red>你不能投空票!!!</font>";} ;;;;?>;;【本文版权归作者与奥索网共同拥有,如需转载,请注明作者及出处】;;;;