connect_error) {
die('Connection failed: ' . $conn->connect_error);
}
// Handle save
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['constituency_id'])) {
$cid = (int)$_POST['constituency_id'];
$winner = !empty($_POST['winner_candidate_id']) ? (int)$_POST['winner_candidate_id'] : null;
$lead_count = (int)$_POST['lead_count'];
$votes = (int)$_POST['votes'];
$status = $_POST['status'];
if ($winner) {
$stmt = $conn->prepare("UPDATE constituency SET winner_candidate_id = ?, lead_count = ?, status = ? WHERE id = ?");
$stmt->bind_param("iisi", $winner, $lead_count, $status, $cid);
$stmt->execute();
$stmt->close();
$stmt2 = $conn->prepare("UPDATE candidates SET votes = ? WHERE id = ?");
$stmt2->bind_param("ii", $votes, $winner);
$stmt2->execute();
$stmt2->close();
} else {
$stmt = $conn->prepare("UPDATE constituency SET winner_candidate_id = NULL, lead_count = ?, status = ? WHERE id = ?");
$stmt->bind_param("isi", $lead_count, $status, $cid);
$stmt->execute();
$stmt->close();
}
// Generate static HTML
generateResultsHtml($conn);
$_SESSION['saved_id'] = $cid;
header("Location: index.php");
exit;
}
function indianNumberFormat($num) {
$num = (int)$num;
if ($num < 1000) return (string)$num;
$last3 = str_pad($num % 1000, 3, '0', STR_PAD_LEFT);
$rest = (int)($num / 1000);
$parts = [];
while ($rest >= 100) {
$parts[] = str_pad($rest % 100, 2, '0', STR_PAD_LEFT);
$rest = (int)($rest / 100);
}
$parts[] = (string)$rest;
return implode(',', array_reverse($parts)) . ',' . $last3;
}
function generateResultsHtml($conn) {
$result = $conn->query("
SELECT c.id, c.name AS const_name, c.lead_count, c.status,
d.name AS district_name, d.id AS district_id,
ca.name AS candidate_name, ca.votes,
p.name AS party_name, p.logo AS party_logo,
a.name AS alliance_name, a.color AS alliance_color
FROM constituency c
JOIN ref_districts d ON c.district_id = d.id
LEFT JOIN candidates ca ON c.winner_candidate_id = ca.id
LEFT JOIN party p ON ca.party_id = p.id
LEFT JOIN alliance a ON ca.alliance_id = a.id
ORDER BY d.id, c.id
");
$data = [];
while ($row = $result->fetch_assoc()) {
$data[$row['district_id']][] = $row;
}
// Build district tag bar
$html .= "\n\n\n| മണ്ഡലം | \nസ്ഥാനാർത്ഥി | \nപാർട്ടി | \nസ്ഥിതി | \n
\n\n\n";
foreach ($data as $districtId => $rows) {
$distName = htmlspecialchars($rows[0]['district_name']);
$html .= " \n\n";
foreach ($rows as $r) {
$constName = htmlspecialchars($r['const_name']);
if ($r['candidate_name']) {
$color = htmlspecialchars($r['alliance_color'] ?? '#757575');
$allianceLower = strtolower(trim($r['alliance_name'] ?? ''));
if ($allianceLower === 'ldf') $allianceClass = 'party-ldf';
elseif ($allianceLower === 'udf') $allianceClass = 'party-udf';
elseif ($allianceLower === 'nda') $allianceClass = 'party-nda';
else $allianceClass = 'party-others';
if ($r['status'] === 'won') {
$statusHtml = '' . (int)$r['lead_count'] . ' വോട്ടിന് വിജയിച്ചു';
} else {
$statusHtml = '' . (int)$r['lead_count'] . ' വോട്ടുകൾക്ക് മുന്നിൽ';
}
$candName = htmlspecialchars($r['candidate_name']);
$partyName = htmlspecialchars($r['party_name']);
$candName = "{$candName} ({$partyName})";
$logo = htmlspecialchars($r['party_logo'] ?? '');
$logoHtml = $logo ? "![\"{$partyName}\"](\"{$logo}\")
" : '';
$allianceName = htmlspecialchars($r['alliance_name'] ?? 'Others');
$partyHtml = "{$logoHtml}{$allianceName}";
} else {
$candName = '—';
$partyHtml = '—';
$statusHtml = '-';
}
$html .= " \n\n";
$html .= "| {$constName} | \n";
$html .= "{$candName} | \n";
$html .= "{$partyHtml} | \n";
$html .= "{$statusHtml} | \n";
$html .= "
\n";
}
}
$html .= " \n\n
\n";
file_put_contents(__DIR__ . '/electionresult.html', $html);
$key = "8fK2vP9mN4qR7wL1bX5jV0cA3yE6tI8oU9bN4qR7wL1bX5jV0cA3yE6tI8oU9bN4qR";
$timestamp = time(); // current Unix timestamp
$url = "https://janayugomonline.com/electionupdater.php?key=$key&ts=$timestamp";
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_TIMEOUT, 30);
$response = curl_exec($ch);
if (curl_errno($ch)) {
echo 'Error: ' . curl_error($ch);
} else {
echo $response;
}
curl_close($ch);
}
// Fetch districts into array
$districtResult = $conn->query("SELECT id, name FROM ref_districts ORDER BY id");
$allDistricts = [];
while ($d = $districtResult->fetch_assoc()) {
$allDistricts[] = $d;
}
// Fetch all constituencies
$constituencies = $conn->query("SELECT id, name, district_id, winner_candidate_id, lead_count, status FROM constituency ORDER BY id");
$constByDistrict = [];
while ($row = $constituencies->fetch_assoc()) {
$constByDistrict[$row['district_id']][] = $row;
}
// Fetch all candidates grouped by constituency
$candidates = $conn->query("SELECT c.id, c.name, c.constituency_id, c.votes, p.name AS party_name, a.name AS alliance_name FROM candidates c LEFT JOIN party p ON c.party_id = p.id LEFT JOIN alliance a ON c.alliance_id = a.id ORDER BY c.name");
$candByConst = [];
while ($row = $candidates->fetch_assoc()) {
$candByConst[$row['constituency_id']][] = $row;
}
$savedId = isset($_SESSION['saved_id']) ? (int)$_SESSION['saved_id'] : 0;
unset($_SESSION['saved_id']);
?>
Election Results
Election Results Management
| # |
Constituency |
Candidate |
Lead Count |
Status |
Action |
close(); ?>