Hi,
Ik heb een Poll systeem maar als je bijvoorbeeld een stem uitbrengt dan zijn al de keuzes op 100%
Wie kan me helpen?
Voorbeeld
Code
PHP
<?php
$pollSql = $core->mysql->query("SELECT
*
FROM
poll");
if($core->mysql->num_rows($pollSql))
{
$pollFetch = $core->mysql->fetch($pollSql);
$gestemdSql = $core->mysql->query("SELECT
poll_id,
lid_id,
stem_antwoord
FROM
poll_stemmen
WHERE
poll_id = '".$core->mysql->escape($pollFetch['id']) . "'
AND
lid_id = '".$core->leden->ledeninfo['eigen']['id']."'");
if($core->leden->ingelogd == TRUE)
{
if(isset($_POST['submit']))
{
if((isset($_POST['antwoord'])) && (ctype_digit($_POST['antwoord'])))
{
if(!empty($pollFetch['antwoord' . $core->entities($_POST['antwoord'])]))
{
if($core->mysql->num_rows($gestemdSql) == 0)
{
$core->mysql->query("INSERT INTO
poll_stemmen
(
poll_id,
lid_id,
stem_antwoord
) VALUES (
'".$core->mysql->escape($pollFetch['id']) . "',
'".$core->leden->ledeninfo['eigen']['id']."',
'".$core->mysql->escape($_POST['antwoord']) . "'
)");
$gestemdSql = $core->mysql->query("SELECT
stem_antwoord
FROM
poll_stemmen
WHERE
poll_id = ".$core->mysql->escape($pollFetch['id'])."
AND
lid_id = ".$core->mysql->escape($core->leden->ledeninfo['eigen']['id']));
}
}
}
}
}
echo '<strong>' . $core->entities($pollFetch['vraag']) . '</strong><br />';
$votes_sql = $core->mysql->query("SELECT
COUNT(1) AS total_votes
FROM
poll_stemmen
WHERE
poll_id = '" . $core->mysql->escape($pollFetch['id']) . "'");
$votes = $core->mysql->fetch($votes_sql);
if($core->mysql->num_rows($gestemdSql))
{
$gestemdFetch = $core->mysql->fetch($gestemdSql);
}
if($core->mysql->num_rows($gestemdSql) == 0 && $core->leden->ingelogd == TRUE)
{
?>
<form action="" method="post">
<?php
}
echo '<table>';
for($i = 1; $i <= 10; $i++)
{
if(!empty($pollFetch['antwoord' . $i]))
{
$antwoord_votes_sql = $core->mysql->query("SELECT
COUNT(1) AS antwoord_votes
FROM
poll_stemmen`
WHERE
poll_id = '".$core->mysql->escape($pollFetch['id']) . "'
AND
stem_antwoord = '".$core->mysql->escape($i) . "'");
$antwoord_votes = $core->mysql->fetch($antwoord_votes_sql);
if($votes['total_votes'] != 0)
{
$percentage = ((round(($antwoord_votes['antwoord_votes'] / $votes['total_votes']), 4)) * 100);
}
else
{
$percentage = 0;
}
echo '<tr>';
if($core->mysql->num_rows($gestemdSql) == 0 && $core->leden->ingelogd == TRUE)
{
?>
<td><input type="radio" name="antwoord" value="<?php echo $core->entities($i); ?>" /></td>
<?php
}
echo '<td>';
if($gestemdFetch['stem_antwoord'] == $i)
{
echo '<i>' . $core->entities($pollFetch['antwoord' . $i]) . '</i>';
}
else
{
echo $core->entities($pollFetch['antwoord' . $i]);
}
echo '</td>
<td><div style="background: url(\''.ROOT.'img/poll_bar.png\') no-repeat bottom left; width: ' . $percentage . 'px; height: 15px; float: left; margin: 1px 0 0 0;"></div></div></td><td><i>' . $percentage . '%</i></td></tr>';
}
}
echo '</table>';
if($core->mysql->num_rows($gestemdSql) == 0 && $core->leden->ingelogd == TRUE)
{
?>
<input type="submit" value="Stem" class="inputVeld" name="submit" />
</form>
<?php
}
echo 'Totaal aantal stemmen: ' . $core->entities($votes['total_votes']);
}
?>