Introduction: Fingerprint and RFID Based Attendance System Using Raspberry Pi and MySQL Database
Video of This Project
Step 1: Hardware Components
- R305 Fingerprint Module
- PL2303 USB to TTL
- RC522 RFID Module
- 20x4 LCD
- Raspberry Pi
- Ethernet Cable
- Push Button (8)
- Buzzer
- Jumper Wire
- SD Card (16 GB)
- Potensiometer (10k)
Step 2: Software Components
- 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. - 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.- Install fingerprint library to your Raspberry Pi by following this link
Install RC522 RFID library to your Raspberry Pi by following this link
- 20x4 LCD Module Control using Python by following this link
Step 3: Hardware Integration
- Raspberry Pi and R305 Fingerprint Module
Follow this link - Raspberry Pi and RC522 RFID Module
Follow this link - Raspberry Pi and 20x4 LCD Module
Follow this link - Raspberry Pi and Push Button
Desain your PCB layout using Eagle software, you can look the picture attached and follow the pinout picture. - 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
- 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).
- Run Xampp Software, then klik Start on Apache and MySQL Module.
- 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.
- Create database same as the picture attached.
- For Raspberry Pi
Contact me for code in raspberry pi.
Step 5: Run the System
- 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.
- Run Xampp Application on Laptop/PC. Then klik Start Apache and MySQL Module.
- 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 .