Bring RFID output to mysql

I want to know how I can read RFID tags and import their information to a MySQL database.
The purpose is that students check in their tag when they drink something and The value of their tag goes +1 in a MySQL database
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

That is mostly up to to the RFID reader. When you say that students check in their tag, I'm making an assumption that the tag itself is some kind of fob or RFID card?

There aren't many specifics here, so here's how the general flow goes:

1. You acquire an RFID reader

2. The RFID reader is hooked into a computer that has a network connection which allows it access to the MySQL database (or maybe it hosts the database and isn't network-connected, but that means a manual pull of the database from time to time).

3. The computer runs an application that has an interface to the RFID reader and is running all the time, listening for an event that indicates that the reader has read some kind of fob or proximity card.

4. Once the system is configured, fobs/cards are purchased, typically pre-manufactured with IDs (you sometimes get to specify a site ID, but the manufacturer will take care of programming the cards with the IDs before they ship them to you), and the cards/fobs are distributed to the users (students, in this case).

5. A student swipes his card/fob against the reader.

6. The reader indicates success or failure, and on success, fires an event to the listening application (from #3).

7. The application receives the event, which contains the ID from the card / fob that was read, along with some other contextual information (e.g. reader ID in case there are multiple ones, etc).

8. The application makes a connection to the database if it doesn't have one already and sends an update/insert query.

Because of this overall model, PHP isn't usually the best choice for this kind of thing. Typically, RFID readers tend to be Microsoft-friendly (they provide Windows drivers, etc), which makes it better suited for a .NET application to do the listening and to send the query to the database.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.