Please help me find a way to do it.
I have looked at the following for sending data Arduino to MySql
But can't seem to find visa-versa.
3
-
2What actions have you taken yet? What does/doesn't work? Is the connection between arduino/php website working or is the problem at php<-mysqlaaa– aaa12/08/2015 19:27:09Commented Dec 8, 2015 at 19:27
-
Sure, why not. If interested let us know a time frame, any of us here would deliver you the way, and quote you accordingly.25mhz– 25mhz01/09/2018 16:19:22Commented Jan 9, 2018 at 16:19
-
Point is that i forgot to check the date of the question, :D replied to a 2yr old question.25mhz– 25mhz01/09/2018 16:21:35Commented Jan 9, 2018 at 16:21
Add a comment
|
2 Answers
There are two things you have to set up for this: 1. Retrieving/parsing websites from your Arduino. 2. Making a dynamic website using PHP (and MySql).
- Try to set up your Arduino as a WebClient, check if you can retrieve a website like google.com or a minimalistic website.
- Try to get your arduino to interpret a string or retrieve values from that website. (I.E: retrieve the day/time from the HTTP message)
IF your arduino can retrieve webpages, you're halfway there (somewhat). And your project is running out of the scope of this arduino.stackexchange.
Now you're going to have to create a dynamic website. You can let PHP reach for values from your MySql database (you should just use a text file first) and display them on your site (in HTML). Your Arduino can now poll your website, to get the HTML content and parse it to the values.
You could develop a REST based service, to make Arduino consume web service using the aRest library.
Following is a tutorial of how to use the aRest API with Arduino: A REST API for Arduino & the CC3000 WiFi Chip.
