Enhancing Attendance Recording: Python and Arduino Integration for RFID Data Transmission to MySQL

Year : 2024 | Volume :01 | Issue : 02 | Page : 23-28
By

Aman Kumar

Sushil Agrwal

Aman Tiwari

Mashkoor Ahmad

  1. Student Department of Electrical Engineering, Bansal Institute of Engineering and Technology Lucknow Uttar Pradesh India
  2. Professor Department of Electrical Engineering, Bansal Institute of Engineering and Technology Lucknow Uttar Pradesh India
  3. Student Department of Electrical Engineering, Bansal Institute of Engineering and Technology Lucknow Uttar Pradesh India
  4. Student Department of Electrical Engineering, Bansal Institute of Engineering and Technology Lucknow Uttar Pradesh

Abstract

The suggested attendance system is used to control attendance from a central unit in vast, branching factories or universities. It is made up of a central unit and terminal units. A Raspberry Pi, a screen GUI, an RFID reader, a transponder card for each user (such as a student), and a GSM board make up each terminal unit. A PC, a GSM board, and an Arduino make up the main unit. Every unit has a unique program in place to accomplish its goals. The terminal unit is in charge of connecting to a transponder card to retrieve its IDs, compare those IDs with the names stored in the SQL server database to retrieve the names of the absent students, and then use a GSM message to transmit those students’ serial numbers. As the hub of the system, the central unit is in charge of gathering all data from the terminal units, presenting it, and doing additional processing to determine which individuals whose absences over the threshold line will be excluded.

Keywords: Attendance system, RFID, GSM, Arduino, MySQL.

[This article belongs to International Journal of Radio Frequency Innovations(ijrfi)]

How to cite this article: Aman Kumar, Sushil Agrwal, Aman Tiwari, Mashkoor Ahmad. Enhancing Attendance Recording: Python and Arduino Integration for RFID Data Transmission to MySQL. International Journal of Radio Frequency Innovations. 2024; 01(02):23-28.
How to cite this URL: Aman Kumar, Sushil Agrwal, Aman Tiwari, Mashkoor Ahmad. Enhancing Attendance Recording: Python and Arduino Integration for RFID Data Transmission to MySQL. International Journal of Radio Frequency Innovations. 2024; 01(02):23-28. Available from: https://journals.stmjournals.com/ijrfi/article=2024/view=150891

References

  1. Lim, T.S., Sim, S.C. and Mansor, M.M., 2009, October. RFID based attendance system. In 2009 IEEE Symposium on Industrial Electronics & Applications (Vol. 2, pp. 778–782). IEEE.
  2. Joshi, A., Ahmad, A., Saxena, A. and Juneja, P., 2021. RFID based attendance system. J. Modern Trends Sci. Tech, 7, pp.40–43
  3. Nainan, S., Parekh, R. and Shah, T., 2013. RFID technology based attendance management system. arXiv preprint arXiv:1306.5381.
  4. Agrawal, A. and Bansal, A., 2013. Online attendance management system using RFID with object counter. International Journal of Information and Computation Technology, 3(3), pp.131–138.
  5. Singhal, E.Z. and Gupta, E.A., 2012. RFID: unique identification technique for attendance system. IJREAS, 2(2).
  6. Silva, F., Filipe, V. and Pereira, A., 2008, October. Automatic control of students’ attendance in classrooms using RFID. In 2008 Third International Conference on Systems and Networks Communications (pp. 384–389). IEEE.
  7. Ramani, S. Valarmathy, S. Selvaraju and P. Niranjan, ―Bank Locker Security System based on RFID and GSM Technology‖ International Journal of Computer Applications (0975 – 8887) Volume 57– No.18, November 2012.
  8. Salunke, P., Malle, P., Datir, K. and Dukale, J., 2013. Automated toll collection system using RFID. IOSR Journal of Computer Engineering (IOSR-JCE), 9(2), pp.61–66.
  9. Dhanalakshmi, M. and Mamatha, U., 2009. RFID based library management system. Proceedings of ASCNT, pp.227–234.
  10. Aysha Qaiser and Shoab a Khan, ―Automation of Time and Attendance using RFID Systems‖ 2nd International Conference on Emerging Technologies, Peshawar, Pakistan, November 2006.13–14.
  11. Patel, R., Patel, N. and Gajjar, M., 2012. Online students’ attendance monitoring system in classroom using radio frequency identification technology: a         proposed          system framework. International journal of emerging technology and advanced engineering, 2(2), pp.61–66.
  12. Singhal, Z. and Gujral, R.K., 2012. Anytime anywhere-remote monitoring of attendance system based on RFID using GSM network. International Journal of Computer Applications, 39(3), pp.37–41.
  13. Agrawal, A. and Bansal, A., 2013. Online attendance management system using RFID with object counter. International Journal of Information and Computation Technology, 3(3), pp.131–138.
  14. Molloy, D., 2016. Exploring Raspberry Pi: interfacing to the real world with embedded Linux. John Wiley & Sons.
  15. Arulogun, O.T., Olatunbosun, A., Fakolujo, O.A. and Olaniyi, O.M., 2013. RFID-based students attendance management system.
  16. Charles Bell, 2013, Beginning Sensor Networks with Arduino and Raspberry Pi Apress.
  17. Karthikeyan, C.S. and Murugeswari, S., 2013. Anytime anyplace-remote monitoring of Students attendance based on RFID and GSM network. International Journal of Advanced Research in Electrical, Electronics and Instrumentation Engineering, 2, pp.6154–6159.
  18. Orient Display. What is LCD Display Arduino? (Online). Orient Display. Available From.https://www.orientdisplay.com/knowledge-base/lcd-basics/what-is-lcd-display-arduino/
  19. Project Hub (2024). Soil Moisture Sensor with Arduino[Online].PROJECT HUB. Available From.https://projecthub.arduino.cc/Aswinth/soil-moisture-sensor-with-arduino-91c818
  20. Project Hub (2024). SmartPhone Controlled Arduino Based Bluetooth Car[Online].PROJECT HUB. Available From.https://projecthub.arduino.cc/Aswinth/smartphone-controlled-arduino-based-bluetooth-car-b2c5c2
Regular Issue Subscription Review Article
Volume 01
Issue 02
Received April 10, 2024
Accepted April 20, 2024
Published April 30, 2024
Views: 24