Contactless Attendance

Contactless Attendance

Are you still using biometrics or swipe based attendance? If Yes then this solution is for you

  • 4,053 views
  • 2 comments
  • 5 respects

Components and supplies

About this project

Why this solution

This solution is to help companies minimise physical contact to reduce spread of Coronavirus. This will replace existing biometric and swipe based attendance systems with RFID based attendance

Requirements

Integration of hardware can be done with companies' existing attendance database or separate one can be created. Those who want to use existing system they need to update the database access credetials in arduino code otherwise one can create its own database in any tool (I prefer Xampp) to create database and a simple php page to update that database

Solution Logic

The solution uses a very simple logic of updating the database once the staff scans his/her RFID badge and this update in database is done only when it receives a valid employee id and employee name otherwise the database will be filled with invalid entries. This will act as authentication to update the database, no authentication required on hardware level.

Creating Database

The first step is to create a MySQL database using xampp. One can follow this link to understand how a database is created. Once you understand this, create a database and table containing below fields as minimum:

  • Employee ID (varchar)
  • Employee Name (text)
  • Time in (datetime)
  • Time Out (datetime)

Update Database

Next step is to create a php page that updates the database. You can learn how to create php page via link. One you learn this, use the link to understand how to update database using php. This page will update database table based on data received from RFID reader. You need to add below checks before making update:

  • RFID tag (employee id) coming from arduino exists in the database
  • if there is no time in record then add new record and put current time
  • if there is a time in record, it means that the staff is leaving and we should do update to the same record

Create Employee Cards

You can follow the link to understand how to write to RFID tags. Follow this and build cards for your employees containing employee id etc.

Build Hardware

Below wiring for Arduino to RFID reader:

PinWiring to Arduino

SDA------------------------Digital 10

SCK------------------------Digital 13

MOSI----------------------Digital 11

MISO----------------------Digital 12

IRQ------------------------unconnected

GND-----------------------GND

RST------------------------Digital 9

3.3V------------------------3.3V (DO NOT CONNECT TO 5V)

you can connect LEDs to arduino to show you status if system running (say using red LED) and status if RFID is read (using green LED as blink for successful reading).

Code

Attendance hardwareC/C++
Upload this code to Arduino MKR wifi 1010
#include <SPI.h>
#include <WiFiNINA.h>
#include <SPI.h>
#include <MFRC522.h>

IPAddress myAddress = "http://www.mydatabase.com" //update your server here
WiFiClient client;

#define SS_PIN 10
#define RST_PIN 9

MFRC522 mfrc522(SS_PIN, RST_PIN);

void setup()
{
  SPI.begin();
  mfrc522.PCD_Init();
}
void loop(){
  emp_id=read_card();
  if (client.connect(myAddress, 80))
   {
     client.write(myAddress+"/attend.php?emp_id="+emp_id); //update php page name here and also replace emp_id with field name of employee id defined in database table
   }
}

String read_card()
{
  String content= "";
  byte letter;
  for (byte i = 0; i < mfrc522.uid.size; i++) 
  {
     content.concat(String(mfrc522.uid.uidByte[i] < 0x10 ? " 0" : " "));
     content.concat(String(mfrc522.uid.uidByte[i], HEX));
  }
  return content;
}

Comments

Similar projects you might like

Contactless Temp Control of Employees on RFID Pass-Through

Project tutorial by Victor Petin

  • 7,860 views
  • 8 comments
  • 22 respects

Attendance System Using Arduino and RFID with Python

Project tutorial by Embedotronics Technologies

  • 18,370 views
  • 2 comments
  • 26 respects

rfid attendance system using arduino with GSM

Project tutorial by sarful

  • 29,713 views
  • 3 comments
  • 37 respects

I Made A Cap That Doesn't Allows You To Touch Your Face!!!

Project tutorial by Dynamic Innovator

  • 12,641 views
  • 41 comments
  • 57 respects

RFID Based Attendance System Using Arduino

Project tutorial by Asim Zulfiqar and High Voltages

  • 31,289 views
  • 3 comments
  • 29 respects
Add projectSign up / Login