RFID data to JSON

I need to build an attendance and automatic door with RFID. I am using Arduino UNO and ESP8266 . I can build the project with writing the authorised cards by hand. But I want to create a server and database which is sql. And I want to read the card's id and than check the database it is authorised or not. Can I do this by JSON, if yes how ? Or do you have any ideas ır suggestions?

@cenkayb

Other post/duplicate DELETED
Please do NOT cross post / duplicate as it wastes peoples time and efforts to have more than one post for a single topic.

Continued cross posting could result in a time out from the forum.

Could you also take a few moments to Learn How To Use The Forum.

Other general help and troubleshooting advice can be found here.
It will help you get the best out of the forum in the future.

Greetings to everyone, I get stuck at a few points in my project that I am planning to do and even moving forward and I need your help. I would be very happy if you could help me with the sample codes, explaining it step by step and showing the source.
I have an entrance and exit door project that works with the Rfid card system. I prepared the local version of this project. In other words, I can make the cards that I write in the code I have determined open the door, so that the others cannot open the door. I can show this visually with the buzzer, lcd screen and leds. But it is very difficult and skillful to insert the card I can give to newcomers to open the door every time and to process it in the code. So I want it to read this data from a database using esp8266. For example, I want to inquire whether there is a new person in the database where I will define a new person and a card, and on the internet with arduino esp8266, but I do not know how to do it. Other than that, if the internet goes out, I want the cards inside the sd card to open the door by using the sd card and reader. If you can help me on this subject, I would be very happy.

Yes, we can probably help. What part do you need help with? Everyone wants free custom code for their project, but that will require MUCH time and effort. Paying for custom code is the best way to go.
Paul

The proper title for this thread - you can correct it in your first post - is "RFID access control". Putting "HELP" and especially in all capitals is simply nonsense and annoys otherwise helpful people who may even decide it is not worth answering.

An ESP8266 is a good choice for this, particularly as it like the MFRC822 module, uses 3.3 V logic and you do not need to perform logic level conversion.

I am using MySQL or MsSQL . But the problem is , how can I read the values in that database and implemented into my code. The other part is the sd card part , how can I read the raid card id's in sd card.

@cenkayb

Other post/duplicate DELETED
Please do NOT cross post / duplicate as it wastes peoples time and efforts to have more than one post for a single topic.

Continued cross posting could result in a time out from the forum.

Could you also take a few moments to Learn How To Use The Forum.

Other general help and troubleshooting advice can be found here.
It will help you get the best out of the forum in the future.

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.