The Integration of Arduino Board and RFID cards

The Integration of Arduino Board and RFID cards

December 18, 2022 622 Views


Topics: Excel, url, IoT ESP, Network Tech

Transcript Excerpt

Using an Arduino board and RFID cards, experts created a Login system. The fundamental idea behind this project is to store data by transmitting it from the Arduino to an Excel file. As users can see, the Arduino transmits the card’s data to the Excel sheet as a login to the system when experts scan the cards for the first time on the url. And the Arduino transmits the data to Excel as a logout when specialists scan them once again. really straightforward and practical. However, professionals are specialists. Therefore, experts must make it professional; experts meant by professionals, that experts don’t have to put the card’s data into the Arduino or the ESP code, because it looks obtrusive while changing or updating the user’s data, and experts can’t if users want to calculate the time spent or perform any mathematical operation on the stored data. To make this solution practical and simple to use, professionals used the NodeMCU and some web design. The database comprises two tables, one for storing user data and the other for keeping track of their activity and circumstances. Each card that is scanned provides its ID via the PHP POST method and is verified as a legitimate user in the database. When it is scanned again, the NodeMCU will perform the same thing but store the time as logout and the status of the user instead of setting the log time to the precise time as login if it is present in the users’ table. Users may download the log and transmit it to someone by clicking Export to Excel. Connect the NodeMCU to the computer via a micro-USB cable, then launch the Arduino IDE to add the ESP boards. Then, follow the instructions: From the file, go to preferences and then copy a specific url and paste it into the URL manager, then click ok. Go to the “tools” menu, pick “Board: Boards manager,” scroll down until users locate “ESP8266,” click “install,” and then wait for the installation to be completed. Click “close” if experts have already installed it. Once the boards have been added, open the RFID NodeMCU code that has been inserted, and then enter the WiFi name and password that users want the NodeMCU to use to connect. After updating the code with the setting, users can upload it to NodeMCU by choosing it from the board’s list, then setting the correct port COM and speeding up the upload process. Now, to make the NodeMCU know where the data will be sent, users must put the computer IP instead of this IP. Users can know it either from the WIFI status or from the cmd command line by entering this command IP config then check IPV4. Now submit it and then open the serial monitor to check if the connection has been established. This is the IP of NodeMCU so be sure to save it.