RFID Authenticated against DB plus more

Projects General Guidance
1

Hello Everyone,

Just getting started Arduino and having a lot of fun.

I have managed to build a RFID Door Access with LED's, and LCD to enable access using a key fob.

I'm trying not to bite off more than I can chew and am short on experience. I am working on a project that has multiple facets and want to build sections one at a time.

The utimate goal is to have a user approach a kiosk that has a screen with a couple of buttons (Could be a touch tft) or key pad next to it. (Step 1- Done)The user scans their card or key fob, (Step 2),gets authenticated by the database, (Step 3) The user is prompted by a message on the TFT Screen to select from a list of 10-20 30 second advertisements which are stored on an SD Card. The user picks one, and when the advert has finished playing, the the arduino sends a response back to the db. (Step 4) In the DB, when the State Change has gone from lets say, "Watched Video=0" to "Watched Video=1" a response is sent back to arduino to open a lock.

I'm pretty certain that I can't simply use the UNO so would need a recommendation on another Arduino. Need an SD Shield to store the video. I see that Adafruit has an ethernet/SD shield. Not sure if it serves the needed purpose.

Would appreciate any help to get the DB authentication going first.

Robert

2

budnikasr:
The utimate goal is to have a user approach a kiosk that has a screen with a couple of buttons (Could be a touch tft) or key pad next to it. (Step 1- Done)The user scans their card or key fob, (Step 2),gets authenticated by the database, (Step 3) The user is prompted by a message on the TFT Screen to select from a list of 10-20 30 second advertisements which are stored on an SD Card. The user picks one, and when the advert has finished playing, the the arduino sends a response back to the db. (Step 4) In the DB, when the State Change has gone from lets say, "Watched Video=0" to "Watched Video=1" a response is sent back to arduino to open a lock.

I'm pretty certain that I can't simply use the UNO so would need a recommendation on another Arduino. Need an SD Shield to store the video. I see that Adafruit has an ethernet/SD shield. Not sure if it serves the needed purpose.

Would appreciate any help to get the DB authentication going first.

Robert

An Arduino can't play videos. It doesn't have the bandwidth. You could use one to control a video player.
I don't think an SD card is fast enough to playback videos, but you can check that out.
Your database could be on an Arduino, if there are only 20 items in it.
Your best bet would be to use a Raspberry Pi.