How to Build Raspberry Pi RFID Attendance System

In this tutorial, I will show you How to build Raspberry pi RFID attendance system complete process, Below are some of the things you need to know to complete this project

For Raspberry pi RFID attendance system project, you have to need flowing Equipment

1. 1. Raspberry Pi

1. 1. Micro SD Card

1. 1. Power Supply

1. 1. RC522 RFID Reader

1. 1. Breadboard

1. 1. Breadboard Wire

This book will help you to gain more knowledge about Raspberry Pi

Before we get started with installing MySQL to our Raspberry Pi, we must first update our package list and all installed packages. running the following two commands.

sudo apt update
sudo apt upgrade

sudo apt install mariadb-server

sudo mysql_secure_installation

sudo mysql -u root -p

<span style="font-size: small; font-weight: normal;">sudo apt install phpmyadmin</span>

You have to need to configure PHPMyAdmin to connect to our MYSQL server. We will also need to set up some details so that we can log in to the PHPMyAdmin software.

To do this select “<Yes>” at them all next prompt.

It will now ask you to set a password for PHPMyAdmin itself. It is best to set this password to something different to your root SQL password. Doing this will help secure the server. This password is what PHPMyAdmin will use to connect to the MySQL server.

sudo mysql -u root -p

Now time to run the command below to create a user and permit it to access all databases on the MySQL server.

Make sure you replace “username” with the username of your choice.

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;

sudo nano /etc/apache2/apache2.conf

Include /etc/phpmyadmin/apache.conf

sudo service apache2 restart

<span style="font-weight: normal;">sudo ln -s /usr/share/phpmyadmin /var/www/html</span>

now you able to access your Raspberry Pi’s PHPMyAdmin interface from a web browser using your IP address.

In my case http://169.254.219.186/phpmyadmin

Notice

You have to need read this tutorial for how to Building the RFID RC522 Reader Circuit and how to Enabling the SPI interface go to

How to interface RFID-RC522 with Raspberry Pi

The first thing you need to do is move on from the link above and gain an idea about the RFID.

Raspberry pi to RFID-RC522 wiring

1. SDA connects to Pin 24.
2. SCK connects to Pin 23.
3. MOSI connects to Pin 19.
4. MISO connects to Pin 21.
5. GND connects to Pin 6.
6. RST connects to Pin 22.
7. 3.3v connects to Pin 1.

Now your job is to create a database for the RFID attendance system. I will now show you how to create a database.

Now it is time to load up into the MYSQL command-line tool by running the following command

sudo mysql -u root -p

CREATE DATABASE attendance_system;

CREATE USER 'attendance_admin'@'localhost' IDENTIFIED BY 'your_password';

GRANT ALL PRIVILEGES ON attendance_system.* TO 'attendance_admin'@'localhost';

use attendance_system;

sudo pip3 install mysql-connector-python

import time
import RPi.GPIO as GPIO
from mfrc522 import SimpleMFRC522
import mysql.connector


db = mysql.connector.connect(
  host="localhost",
  user="username",
  passwd="your_password",
  database="attendance_system"
)

cursor = db.cursor()
reader = SimpleMFRC522()

try:
  while True:
    print('Place Card to\nregister')
    id, text = reader.read()
    cursor.execute("SELECT id FROM users WHERE rfid_uid="+str(id))
    cursor.fetchone()

    if cursor.rowcount >= 1:
      print("Overwrite\nexisting user?")
      overwrite = input("Overwite (Y/N)? ")
      if overwrite[0] == 'Y' or overwrite[0] == 'y':
        print("Overwriting user.")
        time.sleep(1)
        sql_insert = "UPDATE users SET name = %s WHERE rfid_uid=%s"
      else:
        continue;
    else:
      sql_insert = "INSERT INTO users (name, rfid_uid) VALUES (%s, %s)"


    print('Enter new name')
    new_name = input("Name: ")

    cursor.execute(sql_insert, (new_name, id))

    db.commit()

    print("User " + new_name + "\nSaved")
    time.sleep(2)
finally:
  GPIO.cleanup()

Recording Attendance

#!/usr/bin/env python
import time
import RPi.GPIO as GPIO
from mfrc522 import SimpleMFRC522
import mysql.connector

db = mysql.connector.connect(
  host="localhost",
  user="username",
  passwd="your_password",
  database="attendance_system"
)

cursor = db.cursor()
reader = SimpleMFRC522()

try:
  while True:
    print('Place Card to\nrecord attendance')
    id, text = reader.read()

    cursor.execute("Select id, name FROM users WHERE rfid_uid="+str(id))
    result = cursor.fetchone()

    if cursor.rowcount >= 1:
      print("Welcome " + result[1])
      cursor.execute("INSERT INTO attendance (user_id) VALUES (%s)", (result[0],) )
      db.commit()
    else:
        print("User does not exist.")
        time.sleep(2)
finally:
  GPIO.cleanup()

Now you can check your Database for update

My Previous project

1. PIR Motion Sensor using Raspberry Pi4 | Interfacing Tutorial
2. PIR Sensor -Email Sending Movement Detector using IFTTT
3. Controlling a DC Motor with Raspberry Pi4
4. How to Use the Raspberry Pi4 Camera And PIR Sensor to Send Emails
5. Raspberry Pi Distance Sensor using the JSN-SR04T
6. How to connect 16×2 LCD with Raspberry pi
7. How to interface RFID-RC522 with Raspberry Pi