Smart LMS-Arduino-Python

Smart Library Management System using RFID MFRC522, Arduino, Python Tkinter, DHT11 Sensor, and MySQL.

In this project, RFID-RC522 is interfaced with Arduino and then RFID data is sent to Tkinter GUI and MySQL database using Python.

It also uses sensors like DHT11 to collect, plot on GUI, and save to DB/CSV file all sensed data (Temperature and Humidity).

Project Demos :

• https://www.youtube.com/watch?v=t5eLQYGKfPs
• https://www.youtube.com/watch?v=dDuIIZxRO4I

Components and software used :

Arduino Part :

1 - Arduino Uno and its Arduino IDE : https://www.arduino.cc/en/Main/Software

• Arduino code .ino file : https://github.com/GitTeaching/LMS-Arduino-Python/blob/master/arduino_rfid_sensor/arduino_rfid_sensor.ino

2 - RFID MFRC522 with tags and cards :

• RFID Circuit Diagram :

• RFID RC522 Library : download and include library. Donwload from : https://github.com/miguelbalboa/rfid

3 - Piezo / buzzer for the sound on Arduino digital PIN 2 anf GND.

4 - DHT11 Temperature Humidity Sensor : on Arduino digital PIN 2, GND, and 5V.

• Arduino code .ino file : https://github.com/GitTeaching/LMS-Arduino-Python/blob/master/dht_temp_hum_sensor/dht_temp_hum_sensor.ino

• DHT11 Library : download and include https://www.circuitbasics.com/wp-content/uploads/2015/10/DHTLib.zip

• Circuit Diagram and tutorial : https://www.circuitbasics.com/how-to-set-up-the-dht11-humidity-sensor-on-an-arduino/

5 - Final result :

Python Part :

1 - Python, Tkinter for logic and GUI.

2 - Python pyserial for communication : (pip install pyserial) https://pypi.org/project/pyserial/

3 - WAMP Server for MySQL Database storage. MySQL Connector Python library (pip install mysql-connector-python).

4 - MySQL Database - Table Name : Book(bui, rfid_id, title, authors, description, status, issued_by)

5 - GUI Screenshots :

Instructions :

• Load arduino_rfid_sensor.ino / dht_temp_hum_sensor.ino code to Arduino
• Install all python libraries
• Run app.py / lms_sensing.py