Voting Management Program _php Foundation
Last Update:2017-01-19
Source: Internet
Author: User
Voting management procedures
Table structure
CREATE TABLE Poll (poll_id Int (one) not null Auto_increment,poll_name char (), Poll_del Int (a) DEFAULT ' 0 ', PRIMARY KEY (poll_id))
CREATE TABLE Pollsele (pollsele_id int (one) not null Auto_increment,pollsele_name char (m), Poll_del Int (a) DEFAULT ' 0 ', pollsele_poll_id Int (ten), Pollsele_num Int (ten), PRIMARY KEY (pollsele_id))
-------------------------------------------------------------------------------------------------
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,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= ' vote ' >";
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 theme
? $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>";
?>
?
if ($submit 2!= "add")
{echo "<p align=center>";
echo "<form action= ' poll_input.php ' method= ' post ' >";
echo "<font color=004080> theme:</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 ($submit 1!= "valid" && $submit 3!= "Delete")
{echo "<p align=center>";
echo "<form action= ' poll_input.php ' method= ' post ' >";
echo "<font color=004080> set Theme:</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= ' effective ' >";
echo "<input type=submit name=submit3 value= ' delete ' >";
echo "</p>";
echo "</FORM>";
}
Else
{
if ($submit 1== "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 options
? $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>";
?>
?
if ($submit 2!= "add")
{echo "<p align=center>";
echo "<form action= ' pollsele.php?id= $id ' method= ' post ' >";
echo "<font color=004080> option:</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 ($submit 1!= "valid" && $submit 3!= "Invalid")
{echo "<p align=center>";
echo "<form action= ' pollsele.php?id= $id ' method= ' post ' >";
echo "<font color=004080> set option:</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= ' effective ' >";
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 ($submit 1== "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 results
? 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> you can't vote empty!!! </font> ";}
?>
"This article copyright belongs to the author and the Osso net jointly owns, if needs to reprint, please indicate the author and the origin"