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

By
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 .