How to connect Arduino with MySQL database using WiFi shield?
Mjp 2012-07-26 15:27:32 13386 Views4 Replies Hi, I want my Arduino mega bord to connect to the MySQL database using the DFRobot WiFi shield V2.1. So that the Arduino would read and send data to the database wirelessly. Is there anyone who had an experience of doing this? I would be very thankful if someone could show me some example codes or some hints please?
Kind regards,
Mjp
Kind regards,
Mjp
2012-07-27 19:46:32 MJP:
It is possible to use wifi shield to communicate with sql database. One of the possible way is to set up a web service that can communicate with sql server as data interface.
The wifi shield will allow arduino to exchange data with sql database via the web service.
Best
Ricky
R2D2C3PO
It is possible to use wifi shield to communicate with sql database. One of the possible way is to set up a web service that can communicate with sql server as data interface.
The wifi shield will allow arduino to exchange data with sql database via the web service.
Best
Ricky
R2D2C3PO 2012-07-27 19:28:57 MJP,
With the Wifi shield this is the only way to communicate; through serial.
Go ahead and try, my understanding is that the wifi shield will make the interpretation for you. But I have not tried to work with the wifi shield beyond setting it up.
Hector
With the Wifi shield this is the only way to communicate; through serial.
Go ahead and try, my understanding is that the wifi shield will make the interpretation for you. But I have not tried to work with the wifi shield beyond setting it up.
Hector 2012-07-27 12:59:56 [quote="Hector"]
I did find a discussion about this though.
[/quote]
Thank u Hector, I also read this before. Do u know that whether I can use Serial.println instead of client.println in the Arduino code shows in the discussion? (like Serial.println (" HTTP/1.1") instead of client.println (" HTTP/1.1") ). As there is no WiFi library for this shield. :'(
Yours sincerely,
Mjp Mjp
I did find a discussion about this though.
[/quote]
Thank u Hector, I also read this before. Do u know that whether I can use Serial.println instead of client.println in the Arduino code shows in the discussion? (like Serial.println (" HTTP/1.1") instead of client.println (" HTTP/1.1") ). As there is no WiFi library for this shield. :'(
Yours sincerely,
Mjp
Mjp 2012-07-26 23:51:38 Hi MJP,
I don't have too much experience with MySQL. I did find a discussion about this though. Hector
I don't have too much experience with MySQL. I did find a discussion about this though.
Hector 