can you please assist me on python scripts that can import DATA FROM AN RFID READER (MFRC522) TO A MariDB DATABASE using a Raspberry Pi 3 B+?
-
1Please explain what you have tried so far and what did not work. This is not a do my homework site.– joanMay 22, 2020 at 8:13
-
1I am new to the python world and tried my best to write the data to the RFID tag using the MFRC522 module and raspberry pi. However regarding importing of data to the Mariadb database led me to struggle alot so that's why I am requesting for someone's help over here!– Ak282616May 22, 2020 at 8:58
-
1What error message do you get?– IngoMay 22, 2020 at 10:20
-
Ah, let me see. So your homework assignment is in two part: Part 1: read data from MIFARE 1k Classic Card, Part2: import read card data into MariDB. I f you have not comopleted first part, you might like to read the following to get a tip: (1) How can Rpi SPI python read the MFRC522 NFC module? raspberrypi.stackexchange.com/questions/109773/….– tlfong01May 22, 2020 at 11:01
-
1Please read stackoverflow.blog/2010/09/29/good-subjective-bad-subjective then edit your question to give more details of what you've tried, what works, what fails and what you don't understand about the failures.– DougieMay 22, 2020 at 15:48
1 Answer
The answer for your question can't be given that easily. But here, let me try. Follow this flow.
- Install and configure MariaDB
- Install python framework that gives you the connectivity with the database.
- Use pigpio with python and write a program to capture the readings and use the database library to save the data. Last thing , you have to find the SPI pins from specs of RPi. This way you can connect the whole thing togather.
Ask anything if you are stuck.