Fingerprint and RFID Based Attendance System Using Raspberry Pi and MySQL Database

Introduction: Fingerprint and RFID Based Attendance System Using Raspberry Pi and MySQL Database

About: Newbie frankydachi@gmail.com

Video of This Project

Step 1: Hardware Components

  1. R305 Fingerprint Module
  2. PL2303 USB to TTL
  3. RC522 RFID Module
  4. 20x4 LCD
  5. Raspberry Pi
  6. Ethernet Cable
  7. Push Button (8)
  8. Buzzer
  9. Jumper Wire
  10. SD Card (16 GB)
  11. Potensiometer (10k)

Step 2: Software Components

  1. PC/Laptop
    Install Xampp application in your laptop/PC. Connect your PC/Laptop to the ethernet network that has an DHCP Server. Then, open CMD and run this following command: ipconfig. Look your IP Address (mine is 172.37.40.40) and remember it. Run Xampp, in Module Apache klik Config, select Apache (httpd.conf). Find and edit this command : #Listen 172.37.40.40:80. Remove " # " and then save the httpd.conf file.
  2. Raspberry Pi
    I assume that on the SD Card there is a Raspbian Stretch Operating System. Insert the SD Card to the Raspberry Pi and power on the Raspberry Pi.

Step 3: Hardware Integration

  1. Raspberry Pi and R305 Fingerprint Module
    Follow this link

    https://sicherheitskritisch.de/2015/03/fingerprint...

  2. Raspberry Pi and RC522 RFID Module
    Follow this link

    https://www.raspberrypi-spy.co.uk/2018/02/rc522-rf...

  3. Raspberry Pi and 20x4 LCD Module
    Follow this link

    https://www.raspberrypi-spy.co.uk/2012/08/20x4-lcd...

  4. Raspberry Pi and Push Button
    Desain your PCB layout using Eagle software, you can look the picture attached and follow the pinout picture.
  5. Raspberry Pi and Buzzer
    You can use another available I/O in Raspberry Pi, but for this project I choose pin 40 for buzzer.

Step 4: Software Integration

  • For PC/Laptop
    1. Make sure that your Laptop/PC is connected to an ethernet network that has a DHCP Server. So you can check your Laptop/PC IP Address still same as before (mine is 172.37.40.40).
    2. Run Xampp Software, then klik Start on Apache and MySQL Module.
    3. Run Browser (e.g Mozilla Firefox), then in the Address Bar type this command: 172.37.40.40/phpmyadmin, then enter. You will be directed to phpmyadmin for making database.
    4. Create database same as the picture attached.
  • For Raspberry Pi
    Contact me for code in raspberry pi.

Step 5: Run the System

  1. Power on your Raspberry Pi and connect it to the same ethernet network as PC/Laptop. Make sure that your Raspberry Pi have connected to the same network by run this command in terminal : ifconfig. If connected your Raspberry Pi will have IP Address like 172.37.40.45 or other. To perform this proses, you should have keyboard and mouse, then plug it to Raspberry Pi USB Port.
  2. Run Xampp Application on Laptop/PC. Then klik Start Apache and MySQL Module.
  3. Run the code:
    • If you want to Register a new user, run Register.py on terminal by this command : sudo python Register.py .
    • If you want to Searching a user, run Searching.py on terminal by this comman : sudo python Searching.py .

Be the First to Share

    Recommendations

    • Make it Glow Contest

      Make it Glow Contest
    • First Time Author Contest

      First Time Author Contest
    • PCB Challenge

      PCB Challenge

    23 Discussions

    0
    webi_66
    webi_66

    6 weeks ago

    Hello, this is a very great project! Great description. How can I get the code for the Raspberry?
    Greetings Webi

    0
    recep.kaya
    recep.kaya

    2 months ago

    Hello, I implemented this project on raspberry pi mssql. However, I was able to run RFID and Finger print separately. works smoothly. But I couldn't figure out how to get both of them running at once. Can you help me

    0
    recep.kaya
    recep.kaya

    Question 2 months ago on Step 5

    Hello, I implemented this project on raspberry pi mssql. However, I was able to run RFID and Finger print separately. works smoothly. But I couldn't figure out how to get both of them running at once. Can you help me

    0
    lamsso93
    lamsso93

    4 months ago

    hello, I am an electronics student in Guinea.
    is it possible to have the complete code for the raspberry

    0
    mahdierfaniansamiee
    mahdierfaniansamiee

    Reply 4 months ago

    Can you send it to me?
    I can not start this project
    can you help me?
    I need this project for my lesson

    0
    mahdierfaniansamiee
    mahdierfaniansamiee

    Question 4 months ago

    Hello
    I am an electronics student
    Is it possible to provide me with the complete code of this project?

    0
    sinn_black
    sinn_black

    4 months ago

    wow!! this is a great project. i wanna copy your project.^^

    0
    NarashimhaaK
    NarashimhaaK

    Question 1 year ago

    Sir , this is a nice project. I have a question that, how could we integrate GSM module to give automated sms to the absentees.

    0
    ledatjhi
    ledatjhi

    Answer 1 year ago

    do you know the sms provider? and can u send sample sms using that provider in python language ?

    0
    austine_direct
    austine_direct

    Question 1 year ago on Step 5

    Great work you've done sir, am not an engineering student but how can i verify that the student is present or not please help sir

    0
    CarlosS460
    CarlosS460

    1 year ago

    Hello good afternoon, I am trying to make these methods work with a PIC, I have the connections and some routines already done, however I would like to make the following query.

    The sensor has a limited memory, I want to save the templates in a database, I understand that the process is to take the image "readImage", convert it "convertImage", create a template "createTemplate", then load the saved template again " loadTemplate "and then send that template, or am I wrong?

    How can I send this template? Should it be done with "downloadCharacteristics"?

    According to the code that you show with "Searching.py" it seems that you had the templates saved also in the sensor, or do not know if I'm wrong?

    0
    ledatjhi
    ledatjhi

    Reply 1 year ago

    yup, you are right

    0
    felipemendozapereira
    felipemendozapereira

    Reply 1 year ago

    Tengo la misma duda, la memoria del biométrico es limitada, por lo que depende de la memoria para poder cargar personas en el sistema, lograste no depender de las posiciones de MEMORIA de la huella digital?

    0
    LoanP1
    LoanP1

    1 year ago

    Hi , i'm in an engineering school and working on this project without RFID and buttons and have a lot of issues on it, can we contact ourselves in order to realize it?I have just a few questions about the db connection. Thank's a lot.

    0
    ledatjhi
    ledatjhi

    Reply 1 year ago

    conctact me from email.

    0
    malayalamtank123
    malayalamtank123

    1 year ago

    can you give ur mail or whatts app no

    0
    onegeek
    onegeek

    1 year ago

    Great work. Did you use breadboard for some part of the connections?