Table structure CREATETABLEpoll (Poll_IdINT (11) blocks, Poll_Namechar (50), Poll_DelINT (10) DEFAULT0, PRIMARYKEY (Poll_Id) CREATETABLEpollsele (Pollsele_IdINT (11) blocks, pollsele_Namechar (50), Poll _ vote manager
Table structure
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 ))
Bytes -------------------------------------------------------------------------------------------------
Poll. php // Main program
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 "manage"; echo"
";?>
-----------------------------------------------------------------------
Poll_input.php // add a topic
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! = "Add ")
{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! = "Valid" & $ submit3! = "Delete ")
{Echo"
";
Echo "";
}
Else
{
If ($ submit1 = "valid ")
{
$ 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 // Add option
Mysql_select_db ("class", $ db );
$ SQL = "select pollsele_id, pollsele_name, pollsele_del, pollsele_num from pollsele where pollsele_poll_id = '$ ID '";
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 $ my [3]; echo" | ";Echo"
";} Echo"
";
?>
If ($ submit2! = "Add ")
{Echo"
";
Echo "";}
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" ";}
If ($ submit1! = "Valid" & $ submit3! = "Invalid ")
{Echo"
";
Echo "";
}
Else
{$ Db = mysql_connect ("localhost", "root", "391450 ");
Mysql_select_db ("class", $ db );
If ($ submit1 = "valid ")
{
$ 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" ";}
?>
----------------------------------------------------------------------
Pollsee. php // voting result
$ 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"
";
Echo $ title [0]; echo"
";
Echo"
";
$ SQL = "select Pollsele_Name, pollsele_num from pollsele where pollsele_del = '0' and pollsele_poll_id = '$ poll_id '";
@ $ Result = mysql_query ($ SQL );
Echo"
";While ($ myrow = mysql_fetch_row ($ result )){Echo"
"; Echo"
"; Echo $ myrow [0]; echo" |
"; Echo $ myrow [1]; echo" |
";} Echo"
";}
Else
{Echo "you cannot enter a ticket !!! ";}
?>
[This article is copyrighted by the author and osuo. if you need to reprint it, please indicate the author and its source]