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

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: test_liveworking.php

<?php

session_start();
include("controller/config.php");

$vote_query = "SELECT position.position_name, candidate.fullname, SUM(votes.vote_count) AS total_votes
               FROM votes
               INNER JOIN candidate ON votes.candidate_id = candidate.candidate_id
               INNER JOIN position ON candidate.position_id = position.position_id
               GROUP BY position.position_id, votes.candidate_id
               ORDER BY position.position_name, total_votes DESC"; // Order by total_votes in descending order

$stmt = $conn->prepare($vote_query);
$stmt->execute();
$vote_result = $stmt->get_result();

// Initialize an array to hold the vote data grouped by position
$vote_data = [];

while ($vote = $vote_result->fetch_assoc()) {
    $position_name = $vote['position_name'];
    $fullname = $vote['fullname'];
    $total_votes = $vote['total_votes'];

// Group vote data by position
    if (!isset($vote_data[$position_name])) {
        $vote_data[$position_name] = [];
    }

$vote_data[$position_name][] = [
        'candidate_name' => $fullname,
        'total_votes' => $total_votes
    ];
}

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta content="width=device-width, initial-scale=1.0" name="viewport">
    <title>Index - E-TABULATION</title>
    <meta name="description" content="">
    <meta name="keywords" content="">

<link href="img/logo.png" rel="icon">
    <link href="img/logo.png" rel="apple-touch-icon">

<link href="https://fonts.googleapis.com" rel="preconnect">
    <link href="https://fonts.gstatic.com" rel="preconnect" crossorigin>
    <link href="https://fonts.googleapis.com/css2?family=Open+Sans:ital,wght@0,300;0,400;0,500;0,600;0,700;0,800;1,300;1,400;1,500;1,600;1,700;1,800&family=Poppins:ital,wght@0,100;0,200;0,300;0,400;0,500;0,600;0,700;0,800;0,900;1,100;1,200;1,300;1,400;1,500;1,600;1,700;1,800;1,900&family=Jost:ital,wght@0,100;0,200;0,300;0,400;0,500;0,600;0,700;0,800;0,900;1,100;1,200;1,300;1,400;1,500;1,600;1,700;1,800;1,900&display=swap" rel="stylesheet">

<link href="main/assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
    <link href="main/assets/vendor/bootstrap-icons/bootstrap-icons.css" rel="stylesheet">
    <link href="main/assets/vendor/aos/aos.css" rel="stylesheet">
    <link href="main/assets/vendor/glightbox/css/glightbox.min.css" rel="stylesheet">
    <link href="main/assets/vendor/swiper/swiper-bundle.min.css" rel="stylesheet">

<link href="main/assets/css/main.css" rel="stylesheet">
    <script src="https://cdn.tailwindcss.com"></script>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css">

</head>

<a href="index.php" class="logo d-flex align-items-center me-auto">
                
                <img src="img/logo.png" alt="">
                <h1 class="sitename">E-Tabulation</h1>
            </a>

<nav id="navmenu" class="navmenu">
                <ul>
                    <li><a href="index.php">Home</a></li>
                    <li><a href="live.php" class="active">Live Portal</a></li>
                    <li class="dropdown"><a href="#"><span>Candidates</span> <i class="bi bi-chevron-down toggle-dropdown"></i></a>
                        <ul>
                            <li><a href="#">Congressman</a></li>
                            <li><a href="#">Governor</a></li>
                            <li><a href="#">Vice Governor</a></li>
                            <li><a href="#">Board Members</a></li>
                            <li><a href="mayor.php">Mayor</a></li>
                            <li><a href="#">Vice Mayor</a></li>
                            <li><a href="#">Councilors</a></li>
                        </ul>
                    </li>
                </ul>
                <i class="mobile-nav-toggle d-xl-none bi bi-list"></i>
            </nav>
            <button class="btn-getstarted" data-bs-toggle="modal" data-bs-target="#myModal">Login</button>
        </div>
    </header>

<div class="page-title mb-4" data-aos="fade">
            <div class="container mb-4">

</div>
        </div>

<div class="container mt-5" style="height: 100vh;">
            <div class="row">
                <?php foreach ($vote_data as $position_name => $candidates): ?>
                    <div class="col pb-4">
                        <div class="flex justify-between items-center">
                            <div class="bg-blue-900 text-white px-4 py-2 rounded-t-lg">
                                <h1 class="text-xl text-white font-bold"><?php echo $position_name; ?></h1>
                            </div>
                        </div>
                        <div class="bg-white p-4 rounded-lg shadow-md">
                            <p class="text-gray-600">BASISTA, PANGASINAN</p>
                            <p class="text-gray-500 text-sm">Partial, unofficial results aggregated from Comelec data as of May 13, 2022, 2:47 PM and from 100% of Election Returns</p>
                            <div class="mt-4">
                                <?php foreach ($candidates as $index => $candidate): ?>
                                    <div class="bg-gray-100 p-4 rounded-lg mb-4">
                                        <div class="flex justify-between items-center">
                                            <div class="text-lg font-bold">
                                                <?php
                                                // Display the rank (1st, 2nd, 3rd)
                                                $rank = $index + 1;
                                                echo $rank . "<sup>" . ($rank == 1 ? "st" : ($rank == 2 ? "nd" : "rd")) . "</sup> " . $candidate['candidate_name'];
                                                ?>
                                            </div>
                                            <div class="text-2xl font-bold text-blue-900"><?php echo $candidate['total_votes']; ?> <span class="text-gray-600 text-lg">Votes</span></div>
                                        </div>
                                        <div class="w-full bg-gray-300 h-2 rounded-full mt-2">
                                            <div class="bg-blue-900 h-2 rounded-full" style="width: <?php echo min(100, ($candidate['total_votes'] / 16000) * 100); ?>%;"></div>
                                        </div>
                                    </div>
                                <?php endforeach; ?>
                            </div>
                        </div>
                    </div>
                <?php endforeach; ?>
            </div>
            
        </div>
        </div>

</main>

<div class="modal-header">
                    <h4 class="modal-title">Login</h4>
                    <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
                </div>

<div class="modal-body">
                    <form id="loginForm" action="" method="post">
                        <div class="form-group">
                            <label for="username">Username:</label>
                            <input type="text" class="form-control" name="username" id="username" required>
                        </div>
                        <div class="form-group">
                            <label for="password">Password:</label>
                            <div class="input-group">
                                <input type="password" class="form-control" name="password" id="password" required>
                                <div class="input-group-append">
                                    <span class="input-group-text" id="togglePassword" style="cursor: pointer;">👁️</span>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>

<div class="modal-footer">
                    <button type="button" class="btn btn-primary">Submit</button>
                    <button type="button" class="btn btn-danger" data-bs-dismiss="modal">Close</button>
                </div>

</div>
        </div>
    </div>

<footer id="footer" class="footer">
        <div class="container copyright text-center mt-4">
            <p>© <span>Copyright</span> <strong class="px-1 sitename">E-TABULATION</strong> <span>All Rights Reserved</span></p>
            <div class="credits">
                Designed by <a href="#">ELi-ELi</a>
            </div>
        </div>
    </footer>

<a href="#" id="scroll-top" class="scroll-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>

<div id="preloader"></div>

togglePassword.addEventListener("click", function() {
            // Toggle the password field type
            const type = passwordField.type === "password" ? "text" : "password";
            passwordField.type = type;

// Change the icon to show the current state
            togglePassword.textContent = type === "password" ? "👁️" : "🙈";
        });

// Form validation
        const form = document.getElementById("loginForm");
        form.addEventListener("submit", function(event) {
            const username = document.getElementById("username").value;
            const password = document.getElementById("password").value;

if (!username || !password) {
                event.preventDefault();
                alert("Both username and password are required.");
            }
        });
    </script>

<script src="main/assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
    <script src="main/assets/vendor/php-email-form/validate.js"></script>
    <script src="main/assets/vendor/aos/aos.js"></script>
    <script src="main/assets/vendor/glightbox/js/glightbox.min.js"></script>
    <script src="main/assets/vendor/swiper/swiper-bundle.min.js"></script>
    <script src="main/assets/vendor/waypoints/noframework.waypoints.js"></script>
    <script src="main/assets/vendor/imagesloaded/imagesloaded.pkgd.min.js"></script>
    <script src="main/assets/vendor/isotope-layout/isotope.pkgd.min.js"></script>

<script src="main/assets/js/main.js"></script>

</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: test_liveworking.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation