Project In Php And Mysql Source Code Github Exclusive - Onlinevoting System

Online Voting System Project in PHP and MySQL

Introduction

The online voting system is a web-based application that allows users to cast their votes electronically. The system is designed to provide a secure, transparent, and efficient way of conducting elections online. In this guide, we will provide a comprehensive overview of the online voting system project in PHP and MySQL, along with the source code on GitHub.

System Requirements

• PHP 7.2 or higher
• MySQL 5.6 or higher
• Apache or Nginx web server
• GitHub account

System Features

• User registration and login
• Candidate registration
• Voting system
• Result display
• Admin dashboard

Database Design

The database schema consists of the following tables: Online Voting System Project in PHP and MySQL

• users: stores user information
• candidates: stores candidate information
• votes: stores vote records
• elections: stores election information

CREATE TABLE users (
  id INT PRIMARY KEY AUTO_INCREMENT,
  username VARCHAR(255) NOT NULL,
  password VARCHAR(255) NOT NULL,
  email VARCHAR(255) NOT NULL
);
CREATE TABLE candidates (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  description TEXT
);
CREATE TABLE votes (
  id INT PRIMARY KEY AUTO_INCREMENT,
  user_id INT NOT NULL,
  candidate_id INT NOT NULL,
  election_id INT NOT NULL,
  FOREIGN KEY (user_id) REFERENCES users(id),
  FOREIGN KEY (candidate_id) REFERENCES candidates(id),
  FOREIGN KEY (election_id) REFERENCES elections(id)
);
CREATE TABLE elections (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  start_date DATE NOT NULL,
  end_date DATE NOT NULL
);

PHP Code

The PHP code consists of the following files:

• config.php: database connection settings
• functions.php: common functions
• index.php: homepage
• login.php: login page
• register.php: registration page
• candidates.php: candidate list page
• vote.php: voting page
• results.php: result display page
• admin.php: admin dashboard

// config.php
<?php
$host = 'localhost';
$dbname = 'online_voting';
$username = 'root';
$password = '';
$conn = new mysqli($host, $username, $password, $dbname);
if ($conn->connect_error) 
  die("Connection failed: " . $conn->connect_error);
?>

// functions.php
<?php
function getCandidates() 
  global $conn;
  $query = "SELECT * FROM candidates";
  $result = $conn->query($query);
  return $result->fetch_all(MYSQLI_ASSOC);
function getElectionResults() 
  global $conn;
  $query = "SELECT * FROM votes GROUP BY candidate_id";
  $result = $conn->query($query);
  return $result->fetch_all(MYSQLI_ASSOC);
?>

GitHub Repository

The source code for the online voting system project is available on GitHub:

git clone https://github.com/your-username/online-voting-system.git

Installation

1. Clone the repository using Git.
2. Create a new database and import the database schema.
3. Update the config.php file with your database connection settings.
4. Upload the files to your web server.

Usage

1. Open a web browser and navigate to the homepage (index.php).
2. Register as a new user or log in if you already have an account.
3. View the list of candidates and cast your vote.
4. View the election results.

Security Considerations

• Use prepared statements to prevent SQL injection attacks.
• Validate user input to prevent cross-site scripting (XSS) attacks.
• Use HTTPS to encrypt data transmitted between the client and server.

This guide provides a basic overview of the online voting system project in PHP and MySQL. You can modify and extend the code to suit your specific requirements. Make sure to follow best practices for security and testing to ensure the integrity of the system.

Project Structure

online-voting-system/
│
├── assets/
│   ├── css/
│   ├── js/
│   └── images/
│
├── config/
│   └── database.php
│
├── includes/
│   ├── header.php
│   ├── footer.php
│   └── session.php
│
├── admin/
│   ├── dashboard.php
│   ├── manage_elections.php
│   ├── manage_candidates.php
│   ├── manage_voters.php
│   └── results.php
│
├── voter/
│   ├── index.php
│   ├── vote.php
│   ├── results.php
│   └── profile.php
│
├── index.php (homepage)
├── login.php
├── register.php
├── logout.php
└── README.md

Security:

• SQL injection prevention (PDO prepared statements)
• XSS protection
• Session-based authentication
• CSRF tokens on vote submission

Steps:

1. Clone or Download the Repository

   git clone https://github.com/yourusername/online-voting-system-php-mysql.git
   

   Alternatively, download the ZIP and extract it inside htdocs (for XAMPP) or www (for WAMP).

2. Create the Database

   • Open phpMyAdmin (http://localhost/phpmyadmin).
   • Create a new database named voting_system.
   • Import the database.sql file provided in the repository.

3. Configure Database Connection

   • Navigate to config/db.php (or similar).
   • Update the credentials:

     define('DB_HOST', 'localhost');
     define('DB_USER', 'root');
     define('DB_PASS', '');
     define('DB_NAME', 'voting_system');
     

4. Set Admin Account (First Time)

   • Run the setup_admin.php script from your browser (or use the SQL seed file).
   • Default admin credentials often are:
     • Username: admin
     • Password: admin123 (Change immediately after first login!)

5. Launch the Application

   • Open your browser and go to: http://localhost/online-voting-system-php-mysql/
   • You should see the home page with options to log in as voter or admin.

Table: candidates

| Column Name | Data Type | Description | |-------------|-----------|-------------| | candidate_id | INT(11) PRIMARY KEY | | candidate_name | VARCHAR(100) | | party_name | VARCHAR(100) | | party_symbol | VARCHAR(255) | Image path | | constituency_id | INT(11) | | election_id | INT(11) | Foreign key to elections |

Project Overview

The Online Voting System is a web-based application developed to facilitate voting procedures electronically. The primary goal is to eliminate the drawbacks of traditional paper voting—such as ballot stuffing, manual counting errors, and logistical challenges—by replacing them with a streamlined, secure, and transparent digital workflow.

Built using PHP 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.

The Tech Stack

To keep this project accessible and educational, we use the classic LAMP stack architecture: System Features

• Frontend: HTML5, CSS3, Bootstrap 5 (for a responsive, mobile-friendly UI), and JavaScript for interactivity.
• Backend: PHP (Core PHP or Object-Oriented PHP). PHP is chosen for its ease of deployment and widespread use in academic projects.
• Database: MySQL. The relational database structure is perfect for linking voters to their unique votes.
• Server: XAMPP/WAMP/MAMP (Local development environment).

Project Structure (suggested)

• /public (index.php, CSS, JS)
• /app
  • /controllers (AuthController.php, ElectionController.php)
  • /models (User.php, Election.php, Candidate.php, Vote.php)
  • /views (templates)
• /config (database.php, app.php)
• /migrations (initial SQL)
• /logs
• README.md
• .env.example