PHP get_poll_results Exemples

Exemple #1

Fichier : get_poll_yes_results.php Projet : kwaiidan/PopDoxa-1

<?php

include 'get_connection.php';
try {
    if (PHP_SAPI === 'cli') {
        $poll_id = $argv[1];
        // $opin_id = $argv[2];
        // $stance = $argv[3];
        // $vote = $argv[4];
    } else {
        $poll_id = $_GET['poll_id'];
        // $opin_id = $_GET['opin_id'];
        // $stance = $_GET['stance'];
        // $vote = $_GET['vote'];
    }
    get_poll_results($conn, $poll_id);
    //, $opin_id, $stance, $vote);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
    return;
}
$conn = null;
function get_poll_results($conn, $poll_id)
{
    $query = "SELECT id from opinions";
    $query = $conn->prepare($query);
    $query->execute();
    $opinions = $query->fetchall();
    for ($i = 1; $i <= count($opinions); $i++) {
        $query = "\n\t\t\tSELECT op.opin_descrip, uo.opinion, count(uo.user_id)\n\t\t\tfrom user_opin as uo\n\t\t\tjoin opinions as op\n\t\t\ton uo.opin_id = op.id\n\t\t\tjoin poll_results as pr\n\t\t\ton pr.id = :poll_id\n\t\t\twhere uo.opin_id = " . $i . "\n\t\t\tand uo.opinion = 'f'\n\t\t\tand pr.vote = 'y'\n\t\t\tUNION\n\t\t\tSELECT op.opin_descrip, uo.opinion, count(uo.user_id)\n\t\t\tfrom user_opin as uo\n\t\t\tjoin opinions as op\n\t\t\ton uo.opin_id = op.id\n\t\t\tjoin poll_results as pr\n\t\t\ton pr.id = :poll_id\n\t\t\twhere uo.opin_id = " . $i . "\n\t\t\tand uo.opinion = 'a'\n\t\t\tand pr.vote = 'y'\n\t\t\tUNION\n\t\t\tSELECT op.opin_descrip, uo.opinion, count(uo.user_id)\n\t\t\tfrom user_opin as uo\n\t\t\tjoin opinions as op\n\t\t\ton uo.opin_id = op.id\n\t\t\tjoin poll_results as pr\n\t\t\ton pr.id = :poll_id\n\t\t\twhere uo.opin_id = " . $i . "\n\t\t\tand uo.opinion = 'n'\n\t\t\tand pr.vote = 'y';\n\t\t\t";
        $query = $conn->prepare($query);

Exemple #2

Fichier : get_detailed_poll_results.php Projet : kwaiidan/PopDoxa-1

<?php

include 'get_connection.php';
try {
    if (PHP_SAPI === 'cli') {
        $poll_id = $argv[1];
        $opin_id = $argv[2];
        $stance = $argv[3];
        $vote = $argv[4];
    } else {
        $poll_id = $_GET['poll_id'];
        $opin_id = $_GET['opin_id'];
        $stance = $_GET['stance'];
        $vote = $_GET['vote'];
    }
    get_poll_results($conn, $poll_id, $opin_id, $stance, $vote);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
    return;
}
$conn = null;
function get_poll_results($conn, $poll_id, $opin_id, $stance, $vote)
{
    $query = "\n\t\tSELECT op.opin_name, count(uo.user_id), uo.opinion, pr.vote\n\t\tfrom user_opin as uo\n\t\tjoin poll_results as pr\n\t\ton uo.user_id = pr.user_id\n\t\tjoin opinions as op\n\t\ton uo.opin_id = op.id\n\t\twhere uo.opin_id = :opin_id\n\t\tand uo.opinion = :stance\n\t\tand pr.poll_id = :poll_id\n\t\tand pr.vote = :vote;\n\t\t";
    $query = $conn->prepare($query);
    $query->bindparam(':opin_id', $opin_id);
    $query->bindparam(':poll_id', $poll_id);
    $query->bindparam(':stance', $stance);
    $query->bindparam(':vote', $vote);
    $query->execute();
    $results = $query->fetchAll();