<?php
function poll($poll)
{
if(isset($poll))
{
if($_REQUEST['submit'])
{
$sql = "SELECT * FROM poll WHERE id=".$poll."";
$query = mysql_query($sql) or die(mysql_error());
$result = mysql_fetch_array($query) or die(mysql_error());
if($_POST['ant1'] == true)
{
$ant1 = $result['ant1'];
$total = $result['totaal'];
$total++;
$ant1++;
$sql = "UPDATE poll SET ant1=".$ant1.",totaal=".$total." WHERE id=".$result['id']."";
mysql_query($sql) or die(mysql_error());
}
elseif($_POST['ant2'] == true)
{
$ant2 = $result['ant2'];
$ant2++;
$total = $result['totaal'];
$total++;
$sql = "UPDATE poll SET ant2=".$ant2.",totaal=".$total." WHERE id=".$result['id']."";
mysql_query($sql) or die(mysql_error());
}
elseif($_POST['ant3'] == true)
{
$ant3 = $result['ant3'];
$ant3++;
$total = $result['totaal'];
$total++;
$sql = "UPDATE poll SET ant3=".$ant3.",totaal=".$total." WHERE id=".$result['id']."";
mysql_query($sql) or die(mysql_error());
}
elseif($_POST['ant4'] == true)
{
$ant4 = $result['ant4'];
$ant4++;
$total = $result['totaal'];
$total++;
$sql = "UPDATE poll SET ant4=".$ant4.",totaal=".$total." WHERE id=".$result['id']."";
mysql_query($sql) or die(mysql_error());
}
else
{
echo"error u moet wel iets invullen";
}
$sql = "SELECT * FROM poll WHERE id=".$poll."";
$query = mysql_query($sql) or die(mysql_error());
$result = mysql_fetch_array($query) or die(mysql_error());
$p1 = ($result['ant1'] * 100) / $result['totaal'];
$p1 = round($p1,2);
$p2 = ($result['ant2'] * 100) / $result['totaal'];
$p2 = round($p2,2);
$p3 = ($result['ant3'] * 100) / $result['totaal'];
$p3 = round($p3,2);
$p4 = ($result['ant4'] * 100) / $result['totaal'];
$p4 = round($p4,2);
echo "<table>
<tr>
<td colspan='2'>".$result['vraag']."</td>
</tr>
<tr>
<td>".$result['optie1']."</td><td>".$result['ant1']." stemmen $p1%</td>
</tr>
<tr>
<td>".$result['optie2']."</td><td>".$result['ant2']." stemmen $p2%</td>
</tr>
<tr>
<td>".$result['optie3']."</td><td>".$result['ant3']." stemmen $p2%</td>
</tr>
<tr>
<td>".$result['optie4']."</td><td>".$result['ant4']." stemmen $p4%</td>
</tr>
<tr>
<td colspan='2'>Er is totaal ".$result['totaal']." keer gestemd</td>
</tr>
</table>";
}
else
{
$sql = "SELECT * FROM poll WHERE id=".$poll."";
$query = mysql_query($sql) or die(mysql_error());
$result = mysql_fetch_array($query) or die(mysql_error());
if ($result['zichtbaar'] == 1)
{
echo "<ul id=\"menu\"><li><h2>Poll</h2></li>";
echo "<li>Vraag:".$result['vraag']."</li>";
echo "<li>".$result['datum']."</li>";
echo "<form method='post' action='?pagina=polls&id=$poll'>";
if($result['optie1'] != "")
{
echo "<input type='radio' name='ant1'/>".$result['optie1']."<br/>";
}
if($result['optie2'] != "")
{
echo "<input type='radio' name='ant2'/>".$result['optie2']."<br/>";
}
if($result['optie3'] != "")
{
echo "<input type='radio' name='ant3'/>".$result['optie3']."<br/>";
}
if($result['optie4'] != "")
{
echo "<input type='radio' name='ant4'/>".$result['optie4']."<br/>";
}
echo "<input type='submit' value='stem' /><br/></form>";
echo "<li><a href=\"?pagina=polls\">ga terug naar het overzicht</a></li>";
echo "</ul>";
}
}
}
else
{
echo "<h2 class='content'>Polls</h2>
<table class='content'>";
$sql = "SELECT * FROM poll ORDER BY id DESC";
$query = mysql_query($sql) or die(mysql_error());
while($result = mysql_fetch_array($query) or die(mysql_error()))
{
if ($result['zichtbaar'] == 1)
{
echo"<tr class='updateTitle'>
<td>".$result['vraag']."</td><td>".$result['datum']."</td>
</tr>
<tr>
<td><form>
<input type='button' value='bekijken' onclick=\"goTo('?pagina=polls&id=".$result['id']."')\" />
</from>
</td>
</tr>";
}
}
}
}
?>
alvast bedankt