Hello for my school project I'm making a fingerprint attendance system using an Arduino Uno and FPM10A fingerprint sensor.
Basically, the system helps keep track of the student's attendance
I want to know what is the easiest way to make a database and connect it to Arduino,
where I can store different fingerprints from students.
also, I wanted to know if I could only use the arduino USB cable to connect Arduino to pc/database without the need to use wifi shield or ethernet cable
I will not do your project for you. Show us your work and what you have accomplished with your research? You need to define your database and how you plan on connecting it. Yes you can connect it to the PC. Post a prototype schematic of your system showing all interconnections.
To push you in the right direction, we need to identify a few things,..
How many students?
How many readers ?
Distance from readers to computer(s)…
If the need for extended data exists, decide on a database for your PC. Access, or something free/ self developed…
Depending on these, you may keep the fingerprint data in the readers, authenticating users within the reader station, or sending data back & forth to the computer for validation.
After all this, are you allowing any access, or simply logging their presence / time stamps?
Do individual users, or groups of users ‘expire’ or raise alerts to the administrators?
Once you have all this tied together, there’s a good chance you’ll want to generate output / reports…
And don’t forget C R U D support to add, read, delete and edit the enrolled members in your database - and super users that can manage the system parameters.
it's just a small attendance system with 3 students to attend and one teacher basically it's just for one small class of one teacher and three students.
the sensor will be attached to the computer directly at a very short distance since it's just a prototype.
I made a button that allows a new student to register his fingerprint to the database
then when it comes to practice students scan their fingerprint at the start of a class lets say at 8:00 am after 15min 8:15 am any students who just arrived at 8,15 will be classified as LATE after that a list is sent to the computer showing all students who have attended and all the late one and all the one who have not .
I was thinking of using MySQL database for this projet
If you want to connect the Arduino via USB you will need to write a program on the PC to receive serial data from the Arduino and apply it to the database.
If you're going to do that, I'm not sure the Arduino is necessary - just have the PC read the fingerprint module itself.
can I connect it directly to the MySQL database?
This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.