https://github.com/yourusername/online-voting-system-php-mysql
if (isset($_POST['login'])) $username = $_POST['username']; $password = $_POST['password'];
The database schema is as follows:
If you found this guide helpful, share it with your fellow developers or students. Visit the official GitHub repository for the by clicking the link below: https://github
CREATE DATABASE IF NOT EXISTS voting_system; USE voting_system; -- 1. Administrators Table CREATE TABLE IF NOT EXISTS administrators ( admin_id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) NOT NULL UNIQUE, password_hash VARCHAR(255) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- 2. Voters Table CREATE TABLE IF NOT EXISTS voters ( voter_id INT AUTO_INCREMENT PRIMARY KEY, voter_sk VARCHAR(100) NOT NULL UNIQUE, -- Unique Student ID or National ID fullname VARCHAR(100) NOT NULL, email VARCHAR(100) NOT NULL UNIQUE, password_hash VARCHAR(255) NOT NULL, has_voted TINYINT(1) DEFAULT 0, status ENUM('active', 'suspended') DEFAULT 'active', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- 3. Positions Table CREATE TABLE IF NOT EXISTS positions ( position_id INT AUTO_INCREMENT PRIMARY KEY, description VARCHAR(100) NOT NULL, max_vote INT DEFAULT 1, -- Maximum candidates a voter can select for this role priority INT NOT NULL UNIQUE -- Controls the display order on the ballot ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- 4. Candidates Table CREATE TABLE IF NOT EXISTS candidates ( candidate_id INT AUTO_INCREMENT PRIMARY KEY, position_id INT NOT NULL, firstname VARCHAR(50) NOT NULL, lastname VARCHAR(50) NOT NULL, photo VARCHAR(255) DEFAULT 'default.png', bio TEXT, FOREIGN KEY (position_id) REFERENCES positions(position_id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- 5. Votes Table (Anonymized) CREATE TABLE IF NOT EXISTS votes ( vote_id INT AUTO_INCREMENT PRIMARY KEY, position_id INT NOT NULL, candidate_id INT NOT NULL, ballot_token VARCHAR(255) NOT NULL, -- Cryptographic hash tying votes in the same ballot together safely created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (position_id) REFERENCES positions(position_id) ON DELETE CASCADE, FOREIGN KEY (candidate_id) REFERENCES candidates(candidate_id) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; Use code with caution. 3. Core Source Code Implementation
One-click CSV/PDF generation of raw, anonymized vote logs. 2. Relational Database Design (MySQL)
A standard PHP/MySQL voting system includes the following essential modules: php-voting-system · GitHub Topics 09-Jul-2024 — Voters Table CREATE TABLE IF NOT EXISTS voters
// Mark user as voted $markVoted = $conn->prepare("UPDATE users SET has_voted = 1 WHERE id = ?"); $markVoted->execute([$_SESSION['user_id']]);
-- Table: positions CREATE TABLE positions ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(100) UNIQUE NOT NULL, max_vote INT DEFAULT 1 );
prepare("SELECT voted_status FROM voters WHERE id = ?"); $stmt->execute([$_SESSION['voter']]); $voter = $stmt->fetch(); if ($voter['voted_status'] == 1) $_SESSION['error'] = "You have already cast your vote."; header("Location: home.php"); exit(); // Start Transaction $conn->beginTransaction(); // Check posted votes if (isset($_POST['votes']) && is_array($_POST['votes'])) foreach ($_POST['votes'] as $position_id => $candidate_id) if (!empty($candidate_id)) $stmt = $conn->prepare("INSERT INTO votes (voter_id, candidate_id, position_id) VALUES (?, ?, ?)"); $stmt->execute([$voter_id, $candidate_id, $position_id]); // Update voter status $update_stmt = $conn->prepare("UPDATE voters SET voted_status = 1 WHERE id = ?"); $update_stmt->execute([$_SESSION['voter']]); // Commit Transaction $conn->commit(); $_SESSION['success'] = "Ballot cast successfully! Thank you for voting."; else throw new Exception("Empty ballot submitted."); catch (Exception $e) $conn->rollBack(); $_SESSION['error'] = "Voting submission failed: " . $e->getMessage(); header("Location: home.php"); exit(); ?> Use code with caution. 🔒 Security Architecture Best Practices Votes Table (Anonymized) CREATE TABLE IF NOT EXISTS
Built using as the server-side scripting language and MySQL as the backend database, this system provides a robust foundation for managing users, candidates, and election results.
-- Table: votes CREATE TABLE votes ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT NOT NULL, candidate_id INT NOT NULL, position_id INT NOT NULL, voted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES users(id), FOREIGN KEY (candidate_id) REFERENCES candidates(id) );
Switch off error output in your production php.ini file ( display_errors = Off ) to prevent internal system path disclosures. Enable log_errors = On instead.