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

[{“box”:0,”content”:”[if 992 equals=”Open Access”]n

n

n

n

Open Access

nn

n

n[/if 992]n

n

Year : June 14, 2024 at 3:34 pm | [if 1553 equals=””] Volume :01 [else] Volume :01[/if 1553] | [if 424 equals=”Regular Issue”]Issue[/if 424][if 424 equals=”Special Issue”]Special Issue[/if 424] [if 424 equals=”Conference”][/if 424] : 02 | Page : 23-28

n

n

n

n

n

n

By

n

[foreach 286]n

n

n

Aman Kumar, Sushil Agrwal, Aman Tiwari, Mashkoor Ahmad

n

    n t

  • n

n

n[/foreach]

n

n[if 2099 not_equal=”Yes”]n

    [foreach 286] [if 1175 not_equal=””]n t

  1. Student, Professor, Student, Student Department of Electrical Engineering, Bansal Institute of Engineering and Technology Lucknow, Department of Electrical Engineering, Bansal Institute of Engineering and Technology Lucknow, Department of Electrical Engineering, Bansal Institute of Engineering and Technology Lucknow, Department of Electrical Engineering, Bansal Institute of Engineering and Technology Lucknow Uttar Pradesh, Uttar Pradesh, Uttar Pradesh, Uttar Pradesh India, India, India
  2. n[/if 1175][/foreach]

n[/if 2099][if 2099 equals=”Yes”][/if 2099]n

n

Abstract

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

n

n

n

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

n[if 424 equals=”Regular Issue”][This article belongs to International Journal of Radio Frequency Innovations(ijrfi)]

n

[/if 424][if 424 equals=”Special Issue”][This article belongs to Special Issue under section in International Journal of Radio Frequency Innovations(ijrfi)][/if 424][if 424 equals=”Conference”]This article belongs to Conference [/if 424]

n

n

n

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. April 30, 2024; 01(02):23-28.

n

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. April 30, 2024; 01(02):23-28. Available from: https://journals.stmjournals.com/ijrfi/article=April 30, 2024/view=0

nn[if 992 equals=”Open Access”] Full Text PDF Download[/if 992] n[if 992 not_equal=”Open Access”]

[/if 992]n[if 992 not_equal=”Open Access”] n


nn[/if 992]nn[if 379 not_equal=””]n

Browse Figures

n

n

[foreach 379]n

n[/foreach]n

n

n

n[/if 379]n

n

References

n[if 1104 equals=””]n

  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

nn[/if 1104][if 1104 not_equal=””]n

    [foreach 1102]n t

  1. [if 1106 equals=””], [/if 1106][if 1106 not_equal=””],[/if 1106]
  2. n[/foreach]

n[/if 1104]

nn


nn[if 1114 equals=”Yes”]n

n[/if 1114]

n

n

[if 424 not_equal=””]Regular Issue[else]Published[/if 424] Subscription Review Article

n

n

[if 2146 equals=”Yes”][/if 2146][if 2146 not_equal=”Yes”][/if 2146]n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n

n[if 1748 not_equal=””]

[else]

[/if 1748]n

n

n

Volume 01
[if 424 equals=”Regular Issue”]Issue[/if 424][if 424 equals=”Special Issue”]Special Issue[/if 424] [if 424 equals=”Conference”][/if 424] 02
Received April 10, 2024
Accepted April 20, 2024
Published April 30, 2024

n

n

n

n

n

n function myFunction2() {n var x = document.getElementById(“browsefigure”);n if (x.style.display === “block”) {n x.style.display = “none”;n }n else { x.style.display = “Block”; }n }n document.querySelector(“.prevBtn”).addEventListener(“click”, () => {n changeSlides(-1);n });n document.querySelector(“.nextBtn”).addEventListener(“click”, () => {n changeSlides(1);n });n var slideIndex = 1;n showSlides(slideIndex);n function changeSlides(n) {n showSlides((slideIndex += n));n }n function currentSlide(n) {n showSlides((slideIndex = n));n }n function showSlides(n) {n var i;n var slides = document.getElementsByClassName(“Slide”);n var dots = document.getElementsByClassName(“Navdot”);n if (n > slides.length) { slideIndex = 1; }n if (n (item.style.display = “none”));n Array.from(dots).forEach(n item => (item.className = item.className.replace(” selected”, “”))n );n slides[slideIndex – 1].style.display = “block”;n dots[slideIndex – 1].className += ” selected”;n }n”}]