prepare("SELECT * FROM calon WHERE jawatan_calon = ? ORDER BY undi_calon DESC, nama_calon"); $stmt->execute([$position]); $candidates_by_position[$position] = $stmt->fetchAll(); } $stmt = $pdo->prepare("SELECT COUNT(*) FROM undi"); $stmt->execute(); $total_votes = $stmt->fetchColumn(); // Kira undi untuk setiap jawatan $voted_counts = []; foreach ($positions as $position) { $stmt = $pdo->prepare("SELECT COUNT(*) FROM undi WHERE jawatan_calon = ?"); $stmt->execute([$position]); $voted_counts[$position] = $stmt->fetchColumn(); } // Dapatkan tarikh pengundian untuk semak status $stmt = $pdo->prepare("SELECT nilai_tetapan FROM tetapan WHERE kunci_tetapan = 'tarikh_pengundian'"); $stmt->execute(); $date_json = $stmt->fetchColumn(); $dates = json_decode($date_json, true); $start_date = $dates['mula']; $end_date = $dates['tamat']; $current_date = date('Y-m-d'); $voting_open = ($current_date >= $start_date && $current_date <= $end_date); ?> Sistem Pengundian Jawatankuasa Kelab Badminton

🏆 Keputusan Pengundian

SISTEM PENGUNDIAN JAWATANKUASA KELAB BADMINTON SMJK Chung Ling

Undi Pengerusi

Undi Setiausaha

Undi Bendahari

Undi Jawatankuasa

'Pengerusi', 'setiausaha' => 'Setiausaha', 'bendahari' => 'Bendahari', 'jawatankuasa' => 'Jawatankuasa Lain' ]; foreach ($positions as $position): ?>

Kedudukan

Tiada undi untuk lagi

Jadilah yang pertama mengundi!

$candidate): ?> 0 ? 'class="winner-row"' : ''; ?>>

Kedudukan	Calon	Undi	Peratusan
0): ?> # 0): ?> # 0): ?> # #			0 ? round(($candidate['Undi_calon'] / $position_total) * 100, 1) : 0; echo $percentage . '%'; ?>