PHP代码:PHP投票管理程序
来源:学生作业帮助网 编辑:作业帮 时间:2024/05/17 17:02:56 PHP
投票管理程序 "; ";
表结构
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 "";
";
echo ""; ";
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 ""; echo "
echo "
mysql_close();
echo "
";
echo "
echo "管理"; echo "
-----------------------------------------------------------------------
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 "";
";
$result=mysql_query($sql);
while($my=mysql_fetch_row($result))
{
echo "";echo " "; ";echo $my[0];echo " ";
echo "$my[1] ";
echo "";echo $my[2];echo " ";
echo "
} echo "
?>
if($submit2!="添加")
{ echo "
echo "
echo""; }
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 ""; }
if($submit1!="有效"&&$submit3!="删除")
{ echo "
";
echo "
}
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 ""; }
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 ""; }
}
?>
--------------------------------------------------------------------
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 "
";echo $my[0];echo " | ";$my[1] | ";";echo $my[2];echo " | ";";echo $my[3];echo " | ";