query($query);
$error = $db->errorInfo();
if (!is_null($error[2])) {
var_dump($error);
}
if ($result->rowcount() > 0 ) {
// TODO: fix bug where ballots display left/right incorrect when rightid is < leftid
$ballfound="true";
$i=0;
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
// these things are same on both. Don't bother with array
$bdpquote = $row['dpquote'];
$vcomment = $row['comment'];
$vuseragent = $row['useragent'];
$voter_id = $row['voter_id'];
$bal_time = $row['bal_time'];
$bias = $row['bias'];
$left_id = $row['left_id'];
$right_id = $row['right_id'];
$vote_time = $row['vote_time'];
$won_id = $row['won_id'];
// these things are per-candidate.
$cdate[$i]['id'] = $row['id'];
$cdate[$i]['path'] = $row['path'];
$cdate[$i]['name'] = $row['name'];
$cdate[$i]['upvotes'] = $row['upvotes'];
$cdate[$i]['downvotes'] = $row['downvotes'];
$i++;
}
// TODO: the following sets c0 and c1 in sql return order, not in left/right order
if ($left_id == $cdate[0]['id']) {
$clpathp=dirname($cdate[0]['path']);
$clpathf=basename($cdate[0]['path']);
$clpath=$clpathp ."/" .urlencode($clpathf);
$clname=$cdate[0]['name'];
$clid=$cdate[0]['id'];
$crpathp=dirname($cdate[1]['path']);
$crpathf=basename($cdate[1]['path']);
$crpath=$crpathp ."/" .urlencode($crpathf);
$crname=$cdate[1]['name'];
$crid=$cdate[1]['id'];
} else {
$clpathp=dirname($cdate[1]['path']);
$clpathf=basename($cdate[1]['path']);
$clpath=$clpathp ."/" .urlencode($clpathf);
$clname=$cdate[1]['name'];
$clid=$cdate[1]['id'];
$crpathp=dirname($cdate[0]['path']);
$crpathf=basename($cdate[0]['path']);
$crpath=$crpathp ."/" .urlencode($crpathf);
$crname=$cdate[0]['name'];
$crid=$cdate[0]['id'];
}
// echo "$clpath,$crpath,$bdpquote \n"; // debug
// TODO: dpquotes should be in the DB. (the numbers by which they're referenced here are stored in the DB afterall)
$dpquote = [
["First, it is slightly cheaper; and secondly it has the words", "inscribed in large friendly letters on its cover.", "The Hitchhiker's Guide to the Galaxy. Prologue", "0"],
["...the snug plastic cover it fitted into had the words", "printed on it in large friendly letters.", "The Hitchhiker's Guide to the Galaxy. Ch 3", "1"],
["...and written on it, in large friendly letters, the words", "", "So Long, and Thanks for All the Fish. Ch 20", "2"],
["Feebly glowing on its cover, in response to her touch, were some large friendly letters. They said", "", "Mostly Harmless. Ch 16", "3"],
];
} else {
$ballfound="false";
}
// close DB resources
$result->closeCursor();
$db = null;
// ////
// HTML
// ////
echo "
Don't Panic - Ballot $bid
