result.php

<?php

session_start();

if (!isset($_SESSION['loggedin'])) {
    header('Location: login.php');
    exit;
}

include 'functions.php';

$pdo = pdo_connect_mysql();

if (isset($_GET['id'])) {
    $stmt = $pdo->prepare('SELECT * FROM polls WHERE id = ?');
    $stmt->execute([$_GET['id']]);
    
    $poll = $stmt->fetch(PDO::FETCH_ASSOC);

    // Check if the poll record exists
    if ($poll) {
        // MySQL Query that will get all the answers from the "poll_answers" table ordered by the number of votes (descending)
        $stmt = $pdo->prepare('SELECT * FROM poll_answers WHERE poll_id = ? ORDER BY votes DESC');
        $stmt->execute([$_GET['id']]);
        
        $poll_answers = $stmt->fetchAll(PDO::FETCH_ASSOC);

        // Total number of votes, will be used to calculate the percentage
        $total_votes = 0;
        foreach ($poll_answers as $poll_answer) {
            $total_votes += $poll_answer['votes'];
        }
    } else {
        die('Poll with that ID does not exist.');
    }
} else {
    die('No poll ID specified.');
}
?>

<?=template_header('Poll Results')?>

<div class="container-fluid content poll-result">
    <h2><?=$poll['title']?></h2>
    <?php
    $stmt = $pdo->query('SELECT username FROM accounts WHERE id = ' . $poll['creator_id']);
    $creator = $stmt->fetch(PDO::FETCH_ASSOC);
    $creator_name = $creator['username'];
    ?>
    <p>Poll created by <?=$creator_name?></p>
    <?php
        if ($poll['desc'] != "") {
            echo '<p>' . $poll['desc'] . '</p>';
        }
    ?>
    <div class="wrapper">
        <?php foreach ($poll_answers as $poll_answer): ?>
        <?php
        $vote_value = 0;
        if ($total_votes != 0) {
            $vote_value = @round(($poll_answer['votes'] / $total_votes) * 100);
        }
        ?>
        <div class="poll-question">
            <p><?=$poll_answer['title']?> <span>(<?=$poll_answer['votes']?> Votes)</span></p>
            <div class="progress" style="height: 20px;">
                <div class="progress-bar bg-success progress-bar-striped progress-bar-animated" role="progressbar" style= "width:<?=$vote_value?>%">
                    <?=$vote_value?>%
                </div>
            </div>
        </div>
        <?php endforeach;?>
    </div>
</div>

<?=template_footer()?>