当前位置: 首页 > 图文教程 > 网络编程 > PHP > 投票管理程序

PHP
工作笔记：配置MySQL为高可用集群 （1）
MySQL (C API)VC实例及代码下载 （1）(5)
MySQL (C API)VC实例及代码下载 （1）(4)
MySQL (C API)VC实例及代码下载 （1）(3)
MySQL (C API)VC实例及代码下载 （1）(2)
MySQL (C API)VC实例及代码下载 （1）
用JSP连接mysql数据库的方法 （1）(2)
用JSP连接mysql数据库的方法 （1）
MySQL数据库账户授权的相关管理解析 （1）(2)
MySQL数据库账户授权的相关管理解析 （1）
SAP MaxDB MySQL修补数据库严重漏洞
MySQL研发中心成立发布会会后访问整理 （1）(2)
MySQL研发中心成立发布会会后访问整理 （1）
MySQL中SQL-TEXT、DATE和SET数据类型
MySQL存在权限提升及安全限制绕过漏洞
MySQL 卸载的问题
windows下安装、卸载mysql服务
如何正确卸载MySQL
MySQL手册版本 5.0.20-MySQL优化(四) （1）(5)
MySQL手册版本 5.0.20-MySQL优化(四) （1）(4)

No. « 183 184 185 186 »

技术文章搜索

关键字

PHP 中的 投票管理程序

出处:互联网   整理: 软晨网（RuanChen.com）   发布: 2009-09-13   浏览: 275 ::
收藏到网摘: n/a

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