EmPowerYou
Registered
Как мога да преработя следния скрипт, така че като се гласува след това да показва резултатите, а не да ми показва пак формата за гласуване. Става въпрос за една анкета. Ето скрипта, който извежда резултатите от дб във формата за гласуване:
Ето и скрипта, който проверява дали е гласувано и извежда резултатите:
Опитвах се да го направя сам, но не става. Не мисля, че е толко сложно, ама кой квото е научил, нали знаете.
Код:
<?php
include('incsec/incconn.php');
$result = mysql_query($sql);
while ($mypoll = mysql_fetch_array($result)){
$pollid=$mypoll["pollid"];
$pollexplanation=$mypoll["pollexplanation"];
$showexplanation=$mypoll["showexplanation"];
$pollquestion=$mypoll["pollquestion"];
$polllayout=$mypoll[polllayout];
$pollclosingdate = $mypoll["pollclosingdate"];
$pollheadercolour = $mypoll["pollheadercolour"];
$pollheadertextcolour = $mypoll["pollheadertextcolour"];
$pollfootercolour = $mypoll["pollfootercolour"];
$pollfootertextcolour = $mypoll["pollfootertextcolour"];
$pollbackcolour = $mypoll["pollbackcolour"];
$pollchoicestextcolour = $mypoll["pollchoicestextcolour"];
echo "<h3>$pollquestion</h3>";
echo "<center><hr width=\"50%\">";
echo "<form action=\"pollvoteinsert.php\" method = \"POST\">";
echo "<table cellpadding=\"1\" cellspacing=\"0\" WIDTH=\"500\">";
echo "<TR BGCOLOR=\"$pollheadercolour\">";
if ($polllayout==1){//radio buttons
$sqlchoices="SELECT * FROM tblpollchoices WHERE pollidf = $pollid";
$choicesresult = mysql_query($sqlchoices);
while ($mychoices = mysql_fetch_array($choicesresult)){
$pollchoiceid=$mychoices["pollchoiceid"];
$pollchoicetext=$mychoices["pollchoicetext"];
$pollchoicecolour=$mychoices["pollchoicecolour"];
echo "<TR BGCOLOR=\"$pollbackcolour\"><TD>";
echo "<input type=\"radio\" name=\"voterpollchoice\" value=\"$pollchoiceid\">";
echo " <font color=\"$pollchoicestextcolour\">$pollchoicetext</font></td>";
}
}else{//2 for select list
echo "<TR BGCOLOR=\"$pollbackcolour\"><TD>";
$sqlchoices="SELECT * FROM tblpollchoices WHERE pollidf = $pollid";
$choicesresult = mysql_query($sqlchoices);
echo "<select name=\"voterpollchoice\" type=\"text\" width = \"120\">";
while ($mychoices = mysql_fetch_array($choicesresult)){
$pollchoiceid=$mychoices["pollchoiceid"];
$pollchoicetext=$mychoices["pollchoicetext"];
$pollchoicecolour=$mychoices["pollchoicecolour"];
echo "<option value=$pollchoiceid>$pollchoicetext</option>";
}
echo "</select>";
}
echo "</td></tr>";
echo "<TR BGCOLOR=\"$pollfootercolour\"><TD>";
echo "<input name=\"btnvote\" value=\"Гласувай\" type=\"submit\" class=\"submit\" /> <input name=\"reset\" value=\"Изчисти\" type=\"reset\" class=\"submit\" />";
echo "</td></tr>";
echo "<tr><td align=\"center\">";
echo "<a href=\"poll.php?page=pollresults&pollid=$pollid\">View Results</font></a>";
echo "</td></tr>";
echo "</table></form>";
}
?>
Ето и скрипта, който проверява дали е гласувано и извежда резултатите:
Код:
<?php
if ((!$_GET[pollchoiceid]) AND (!$_GET[pollid]) AND (!$pollid)){
die ("Error: Please select a Poll<br><br><a href=\"pollvote.php\">Click here to try again</a>");
}
//initialize variables
if ($_GET[pollchoiceid]) {
if (checkid($_GET[pollchoiceid])==0){
echo "Грешка при избора на анкета<br />";
echo "<a href=\"poll.php?page=pollvote\">Опитайте отново</a>";
die();
}else{
$pollchoiceid = $_GET[pollchoiceid];
}
//Get info about the poll
$field="pollidf";
$table="tblpollchoices";
$criteria="WHERE pollchoiceid = $pollchoiceid";
$pollid=dlookup($field,$table,$criteria);
}
if ($_GET[pollid]) {
if (checkid($_GET[pollid])==0){
echo "Грешка при избора на анкета<br />";
echo "<a href=\"poll.php?page=pollvote\">Опитайте отново</a>";
die();
}else{
$pollid=$_GET[pollid];
}
}
//end initialising
$field="pollquestion";
$table="tblpolls";
$criteria="WHERE pollid = $pollid";
$pollquestion = dlookup($field,$table,$criteria);
$field="pollexplanation";
$pollexplanation = dlookup($field,$table,$criteria);
$field="showexplanation";
$showexplanation = dlookup($field,$table,$criteria);
$field="pollheadercolour";
$pollheadercolour = dlookup($field,$table,$criteria);
$field="pollbackcolour";
$pollbackcolour = dlookup($field,$table,$criteria);
$field="pollheadertextcolour";
$pollheadertextcolour= dlookup($field,$table,$criteria);
$field="pollchoicestextcolour";
$pollchoicestextcolour= dlookup($field,$table,$criteria);
$field="shownumberofvotes";
$shownumberofvotes= dlookup($field,$table,$criteria);
$field="resultlayout";
$resultlayout= dlookup($field,$table,$criteria);
$field="pollfootercolour";
$pollfootercolour = dlookup($field,$table,$criteria);
$field="pollfootertextcolour";
$pollfootertextcolour= dlookup($field,$table,$criteria);
//Get Total Number of Votes
$sqltotalvotes ="SELECT tblpollchoices.pollidf, tblvotes.voteid
FROM tblpollchoices INNER JOIN tblvotes ON tblpollchoices.pollchoiceid = tblvotes.pollchoiceidf
WHERE pollidf = $pollid";
$result = mysql_query($sqltotalvotes);
$totalnumofvotes = mysql_num_rows($result);
//get choices
$sql="SELECT * FROM tblpollchoices WHERE pollidf = $pollid";
$result = mysql_query($sql);
$numofpollchoices = mysql_num_rows($result);
if ($resultlayout==1){//Horizontal bars
$colspan = $shownumberofvotes==1?4:3;//1 means show vote count, so show an extra column
}else{//vertical
$colspan = $numofpollchoices;
}
//
echo "<table cellpadding=\"1\" cellspacing=\"1\" border=\"0\" width=\"60%\">\n";
echo "<tbody>";
if ($showexplanation==1){//show explanation
echo "<tr>";
echo "<td valign=\"top\" colspan=\"$colspan\" align=\"center\" bgcolor=\"$pollheadercolour\">";
echo "<b><font color = \"$pollheadertextcolour\">$pollexplanation</font></b>";
echo "</td></tr>";
}
echo "<tr>";
echo "<td valign=\"top\" colspan=\"$colspan\" align=\"center\" bgcolor=\"$pollheadercolour\">";
echo "<b><font color = \"$pollheadertextcolour\">$pollquestion</font></b>";
echo "</td></tr>";
$counter=0;
while ($myrow = mysql_fetch_array($result)){
$pollchoiceid = $myrow[pollchoiceid];
$pollchoicetext = $myrow["pollchoicetext"];
$pollchoicecolour = $myrow["pollchoicecolour"];
$sqlcountvotes = "SELECT COUNT(voteid) AS countedvotes FROM tblvotes WHERE pollchoiceidf = $pollchoiceid";
//$sqlcountvotes = "SELECT voteid FROM tblvotes WHERE pollchoiceidf = $pollchoiceid";
$result2 = mysql_query($sqlcountvotes);
$votesrow = mysql_fetch_array($result2);
$votesforthischoice=$votesrow[countedvotes];
if ($totalnumofvotes==0){
$percentage=0;
}else{
$percentage=($votesforthischoice/$totalnumofvotes)*100;
}
///
$arraybarheights[$counter]=$percentage;
$arrayvotes[$counter]=$votesforthischoice;
$arraytext[$counter]=$pollchoicetext;
$arraybarcolour[$counter]=$pollchoicecolour;
$counter=$counter+1;
if ($resultlayout==1){//Horizontal bars
echo "<tr bgcolor=\"$pollbackcolour\">";
echo"<td width = \"30%\"><font color = \"$pollchoicestextcolour\">$pollchoicetext</font></td>";
if ($shownumberofvotes==1){
echo"<td width = \"10%\"><font color = \"$pollchoicestextcolour\">$votesforthischoice</font></td>";
}
echo"<td width = \"15%\"><font color = \"$pollchoicestextcolour\">". number_format($percentage, 2)."%</font></td>";
echo "<td>";
echo "<table cellpadding=\"1\" cellspacing=\"1\" border=\"0\" width=\"$percentage%\" bgcolor=\"$pollchoicecolour\">";
echo "<tbody><tr><td><br></td></tr></tbody></table>";
echo "</td>";
echo "</tr>";
}
}
///////////////////////////////////////////////////////////////////
if ($resultlayout==2){
if ($numofpollchoices==0){
$numofpollchoices = 1;
}
$columnwidth=100/$numofpollchoices;
$graphspaceheight=150;
//Draw the bars
$counter=0;
echo "<tr bgcolor=\"$pollbackcolour\" align=\"center\">";
while ($counter < $numofpollchoices){
$percentage=$arraybarheights[$counter];
$blankspace=100-$percentage;
$pollchoicecolour=$arraybarcolour[$counter];
if ($percentage==0){
$pollchoicecolour=$pollbackcolour;
}
echo "<td width = \"$columnwidth%\" height = \"$graphspaceheight\" valign=\"bottom\" align=\"center\">";
//echo "<table cellpadding=\"1\" cellspacing=\"1\" border=\"0\" width = \"25\" height=\"$percentage%\" bgcolor=\"$pollchoicecolour\" align=\"center\">";
//echo "<tbody><tr><td><br></td></tr></tbody></table>";
echo "<table height = \"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" width = \"25\" align=\"center\">";
echo "<tbody><tr height=\"$blankspace%\"><td ><br></td></tr>";
echo "<tr height=\"$percentage%\" bgcolor=\"$pollchoicecolour\"><td> </td></tr></tbody></table>";
echo "</td>";
$counter=$counter+1;
}
echo "</tr>";
//Show the poll choice text
$counter=0;
echo "<tr bgcolor=\"$pollbackcolour\">";
while ($counter < $numofpollchoices){
$pollchoicetext=$arraytext[$counter];
echo "<td width = \"$columnwidth%\" align=\"center\">";
echo "<font color=\"$pollchoicestextcolour\">$pollchoicetext </font>";
echo "</td>";
$counter=$counter+1;
}
echo "</tr>";
if ($shownumberofvotes==1){
//Show the votes
$counter=0;
echo "<tr bgcolor=\"$pollbackcolour\">";
while ($counter < $numofpollchoices){
$votesforthischoice =$arrayvotes[$counter];
echo "<td width = \"$columnwidth%\" align=\"center\">";
echo "<font color=\"$pollchoicestextcolour\">$votesforthischoice</font>";
echo "</td>";
$counter=$counter+1;
}
echo "</tr>";
}
//Show the percentages
$counter=0;
echo "<tr bgcolor=\"$pollbackcolour\">";
while ($counter < $numofpollchoices){
$percentage=$arraybarheights[$counter];
echo "<td width = \"$columnwidth%\" align=\"center\">";
echo "<font color=\"$pollchoicestextcolour\">". number_format($percentage, 2)."%</font>";
echo "</td>";
$counter=$counter+1;
}
echo "</tr>";
}//end if for result layout
/////////////////////////////////////////////////////////////////
echo "<tr>";
echo "<td valign=\"top\" colspan=\"$colspan\" align=\"center\" bgcolor=\"$pollfootercolour\">";
if ($shownumberofvotes==1){
echo "<b><font color = \"$pollfootertextcolour\">Total votes: $totalnumofvotes</font></b>";
}else{
echo "<br>";
}
echo "</td></tr>";
echo "</tbody></table>";
?>
Опитвах се да го направя сам, но не става. Не мисля, че е толко сложно, ама кой квото е научил, нали знаете.