Voting Management Program
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
<? $ 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) '> ";
Echo "<td align = center bgcolor = 99 aabb 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 = 'fig. 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 = 'voting '> ";
Echo "</p> ";
Echo "</form>"; echo "</td> ";
Echo "</table> ";
Mysql_close ();
Echo "<br> ";
Echo "<p align = right> ";
Echo "<a href = poll_input> management </a>"; echo "</p>";?>
-----------------------------------------------------------------------
Poll_input.php // Add a topic
<? $ 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) '> ";
$ Result = mysql_query ($ SQL );
While ($ my = mysql_fetch_row ($ result ))
{
Echo "<tr>"; echo "<td align = center width = 50 bgcolor = 99 aabb style = 'border: 1px solid rgb (255,255,255) '> "; echo $ my [0]; echo "</td> ";
Echo "<td align = center width = 200 bgcolor = 99 aabb 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 = 99 aabb style = 'border: 1px solid rgb (255,255,255) '>"; echo $ my [2]; echo "</td> ";
Echo "</tr> ";
} Echo "</table> ";
?>
<Html>
<Head>
<?
If ($ submit2! = "Add ")
{Echo "<p align = center> ";
Echo "<form action = 'Poll _ input. php' METHOD = 'post'> ";
Echo "<font color = 004080> subject: </font> ";
Echo "<input type = text name = title size = 30 value =''> ";
Echo "<input type = submit name = submit2 value = 'add'> ";
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! = "Valid" & $ submit3! = "Delete ")
{Echo "<p align = center> ";
Echo "<form action = 'Poll _ input. php' METHOD = 'post'> ";
Echo "<font color = 004080> set subject: </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 = 'invalid'> ";
Echo "<input type = submit name = submit3 value = 'delete'> ";
Echo "</p> ";
Echo "</FORM> ";
}
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 "<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 // Add Option
<? $ 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) '> ";
@ $ Result = mysql_query ($ SQL );
While ($ my = mysql_fetch_row ($ result ))
{
Echo "<tr>"; echo "<td align = center width = 50 bgcolor = 99 aabb style = 'border: 1px solid rgb (255,255,255) '> "; echo $ my [0]; echo "</td> ";
Echo "<td align = center width = 200 bgcolor = 99 aabb style = 'border: 1px solid rgb (255,255,255) '> $ my [1] </td> ";
Echo "<td align = center width = 50 bgcolor = 99 aabb style = 'border: 1px solid rgb (255,255,255) '>"; echo $ my [2]; echo "</td> ";
Echo "<td align = center width = 50 bgcolor = 99 aabb style = 'border: 1px solid rgb (255,255,255) '>"; echo $ my [3]; echo "</td> ";
Echo "</tr> ";
} Echo "</table> ";
?>
<Html>
<Head>
<?
If ($ submit2! = "Add ")
{Echo "<p align = center> ";
Echo "<form action = 'fig. php? Id = $ id 'method = 'post'> ";
Echo "<font color = 004080> options: </font> </td> ";
Echo "<input type = text name = title size = 30 value =''> ";
Echo "<input type = submit name = submit2 value = 'add'> ";
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! = "Valid" & $ submit3! = "Invalid ")
{Echo "<p align = center> ";
Echo "<form action = 'fig. php? Id = $ id 'method = 'post'> ";
Echo "<font color = 004080> setting options: </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 = 'invalid'> ";
Echo "<input type = submit name = submit3 value = 'invalid'> ";
Echo "</p> ";
Echo "</FORM> ";
}
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 "<META HTTP-EQUIV = refresh content = '1; URL = pollsele. php? Id = $ id'> ";}
?>
----------------------------------------------------------------------
Pollsee. php // voting result
<? 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) '> ";
While ($ myrow = mysql_fetch_row ($ result ))
{Echo "<tr>"; echo "<td width = 150 bgcolor = 99 aabb style = 'border: 1px solid rgb (255,255,255) '> ";
Echo $ myrow [0]; echo "</td> <td width = 50 bgcolor = 99 aabb style = 'border: 1px solid rgb (255,255,255) '> "; echo $ myrow [1]; echo "</td> </tr>" ;}echo "</table> ";}
Else
{Echo "<font color = red> you cannot leave a blank ticket !!! </Font> ";}
?>
[This article is copyrighted by the author and osuo. If you need to reprint it, please indicate the author and its source]
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
