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: submit_vote.php

<?php

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

if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $precinct_id = $_POST['precinct_id'];
    $votes = $_POST['votes'];

// Loop through each position and candidate, then insert the vote count
    foreach ($votes as $position_id => $candidates) {
        foreach ($candidates as $candidate_id => $vote_count) {
            // Check if the candidate_id exists in the candidates table
            $check_candidate_query = "SELECT * FROM candidate WHERE candidate_id = ?";
            $stmt = $conn->prepare($check_candidate_query);
            $stmt->bind_param("i", $candidate_id);
            $stmt->execute();
            $candidate_result = $stmt->get_result();

if ($candidate_result->num_rows > 0) {
                // Candidate exists, proceed with inserting/updating vote count
                // Check if a vote already exists for this candidate and precinct
                $check_vote_query = "SELECT * FROM votes WHERE candidate_id = ? AND precinct_id = ?";
                $stmt = $conn->prepare($check_vote_query);
                $stmt->bind_param("ii", $candidate_id, $precinct_id);
                $stmt->execute();
                $result = $stmt->get_result();

if ($result->num_rows > 0) {
                    // Update the vote count if a record exists
                    $update_vote_query = "UPDATE votes SET vote_count = vote_count + ? WHERE candidate_id = ? AND precinct_id = ?";
                    $stmt = $conn->prepare($update_vote_query);
                    $stmt->bind_param("iii", $vote_count, $candidate_id, $precinct_id);
                } else {
                    // Insert a new record if no vote exists
                    $insert_vote_query = "INSERT INTO votes (candidate_id, precinct_id, vote_count) VALUES (?, ?, ?)";
                    $stmt = $conn->prepare($insert_vote_query);
                    $stmt->bind_param("iii", $candidate_id, $precinct_id, $vote_count);
                }

// Execute the query
                if ($stmt->execute()) {
                    echo "Vote submitted successfully for candidate $candidate_id!";
                    header('location: index.php');
                } else {
                    echo "Error: " . $stmt->error;
                }
            } else {
                // Candidate does not exist in the candidates table
                echo "Error: Candidate with ID $candidate_id does not exist!";
            }
        }
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: submit_vote.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation