投票管理程序 表结构 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 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)'>$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>";} ?> 【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】
投票管理程序-PHP实例
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://www.haodehen.cn/did3682
阅读：35次