表结构
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>";}
;;;;?>;;
【本文版权归作者与奥索网共同拥有，如需转载，请注明作者及出处】;;;;
标签：
