function getTotalCandidateCount() { //getCandidates $election_id = getCurrentElectionID(); $categoryResult = getCategories($election_id); $count = 0; while ($category = $categoryResult->fetch_assoc()) { //mysql_fetch_array($categoryResult)){ $id = $category['id']; $result = getCandidates($id); $count += $result->num_rows; //mysql_numrows($result); } return $count; }
<?php include "SaveElection.php"; session_start(); $election_id = getCurrentElectionID(); //get all districts $query = "Select * from election_districts JOIN districts where election_districts.election_id = {$election_id} and "; $query .= "election_districts.district_id = districts.id"; $result = runQuery($query); while ($district = $result->fetch_assoc()) { //mysql_fetch_array($result)){ $machineCount = $district['machine_count']; $name = $district['name']; $district_id = $district['id']; if (districtComplete($district_id) == true) { echo "<br><div class='highlight'>"; } else { echo "<br><div class='lowlight'>"; } echo "District {$name}</div>"; $election_district_id = getElectionDistrictID($district_id); for ($m = 1; $m <= $machineCount; $m++) { $districtMachineString = "{$district_id}.{$m}"; //echo "$districtMachineString <br>"; echo "<button class='link' onclick='showInfo({$districtMachineString})'>"; if (dataEntered($election_district_id, $m) == true) { echo "<div class='highlight'>"; } else { echo "<div class='lowlight'>"; } if (is_numeric($name)) {
function showVoteInput($q) { //Not editable if prior election $canEdit = $_SESSION['is_active']; //Can't edit if readonly user if (!(stripos($_SESSION['privilege'], 'read') === false)) { $canEdit = false; } $info = explode(".", $q); $district = $info[0]; $machine = $info[1]; //get name of district $query = "Select * from districts where id = {$district}"; //$result = mysql_query($query) or die("Query Failed!" . $query); $result = runQuery($query); $districtInfo = $result->fetch_assoc(); //mysql_fetch_array($result); $name = $districtInfo['name']; echo "<center><h1 class='title'>Enter Election Results for District: <span class='big'>{$name}</span>, Machine: <span class='big'>{$machine}</span></h1></center>"; echo "<form action = './saveInputs.php' method ='post'>"; //get categories $election_id = getCurrentElectionID(); $categoriesResult = getCategories($election_id); $count = 0; $categoryCount = 0; echo "<table><tr><td class='category'>"; while ($category = $categoriesResult->fetch_assoc()) { //get candidates $id = $category['id']; //echo " ID = {$id} "; $candidates = getCandidates($id); echo "<h1> {$category['question']}</h1><table>"; while ($candidate = $candidates->fetch_assoc()) { $hidden = "candidateID" . $count++; echo "<tr><td width = 25px></td><td>{$candidate['response']}</td><td>"; echo "<input type ='number' id='{$candidate['id']}' name='{$candidate['id']}' value = "; echo "'"; echo getElectionResults($district, $machine, $candidate['id']); echo "'"; if ($canEdit) { echo " oninput='ajaxGetInfo(this.value, this.name)' min=0>"; } else { //READONLY echo " READONLY>"; } echo "</td></tr>"; echo "<input type=hidden name = {$hidden} METHOD='POST' value='{$candidate['id']}'>"; // echo "<input type=hidden name = 'candidateID' METHOD='POST' value='{$candidate['candidate_id']}'>"; } echo "</table>"; echo "<input type=hidden id = 'district' value='{$district}'>"; echo "<input type=hidden id = 'machine' value='{$machine}'>"; if ($categoryCount % 3 == 2) { echo "</td><td style='padding-left:45px'>"; } $categoryCount++; } echo "</td></tr></table>"; echo "<input type=hidden name = 'maxCount' value='{$count}'>"; // echo "<input type=hidden name = 'maxCategoryCount' value='{$categoryCount}'>"; }