Hello, I have managed to store data in MySQL database using python (with mysqldb). It basically reads an RFID card and gets the user's choice using pushbuttons. RFID card's UID number and button name is stored in the database.
Now, the Arduino should check the database if the card has been used before. I don't have an Ethernet shield. Is it possible without a shield ?
I have found similar posts but all of them are using ethernet (or other) shields.
(I am using Arduino UNO)
Can you use the regular USB cable to connect the Arduino to the PC that has the Python program?
If so this Python - Arduino demo may help. Also look at Serial Input Basics which was written more recently.
...R
How do you plan to make the connection to the computer running the MySQL server in the first place?
Robin2:
Can you use the regular USB cable to connect the Arduino to the PC that has the Python program?If so this Python - Arduino demo may help. Also look at Serial Input Basics which was written more recently.
...R
Yes, I will use a USB cable for communication. I was just checking your post. Thanks.
wvmarle:
How do you plan to make the connection to the computer running the MySQL server in the first place?
Using USB cable. Sorry, forgot to mention that.
In that case indeed Serial is your solution.
Have some application running on your computer that connects to the USB port, then reads the commands from the Arduino, queries the database, and returns the result.