Database Trouble

Projects Programming
1

I'm trying to link arduino mega with a mysql amazon server to read and write information. My overall project will ask users to scan their rfid card, once card is scanned, if it is accepted, I want their information to be uploaded to the arduino from the server so they can select from a list of option i created in the server. From there I want whatever they select to be uploaded to the external database so i can save that information. And once they finished i want them to re-prompted to rescan their rfid card. How would i go about doing so?? I've attached my code below to show you what i have so far.

Example1.ino (5.6 KB)

2 
String read_rfid;
String ok_rfid_1 = "5d6a748";
String ok_rfid_2 = "abbf96ea";

You know how many characters in an RFID tag. Quit pissing away resources on the String class.

int pump0 = 9; //Whiskey
int pump1 = 10; //Vodka
int pump2 = 11; //Coke
int pump3 = 12; //Redbull
int pump4 = 13; //Sprite
int pump5 = 14; //CO2

Use an array!

   //check card authorization
   if(read_rfid = ok_rfid_1 = ok_rfid_2)

I don't know what you think that is doing, but it isn't.

    while(read_rfid = ok_rfid_1 = ok_rfid_2)

Nor is that.

      //setting up input from user
      input = Serial.parseInt();

Why not use a keypad to allow users to make an entry?

What, specifically, do you want to store in a database? Where is that database? How will you communicate with it? Typically, the second answer involves a server, and the third answer involves an Ethernet shield.

3

Start with a much simpler program that just sends one or two pre-programmed character strings to the database.

When that works you can then extend the program to get input from the user.

Don't try to build the whole complex program as a single entity. Have a look at Planning and Implementing a Program

...R