I have a few questions.
All I am looking for this to do is connect to the db and read a value from column "status" and if the value of this is 1 then turn on an led and or play a sound I need it to look and see if there is any new entries in the db every 60sec.
Can this be done with what i have picked out?
Kelly:
I have a few questions.
- Can the arduino read a value (ie: 1 or 0) from a MySql db, The database will be on my website NOT a local server.
- I am looking into the arduino uno and Ethernet shield.
All I am looking for this to do is connect to the db and read a value from column "status" and if the value of this is 1 then turn on an led and or play a sound I need it to look and see if there is any new entries in the db every 60sec.
Can this be done with what i have picked out?
You can do that, if you have a web server to handle the connection to the mysql database, and then return the result.
Kelly:
Can this be done with what i have picked out?
Yes.
The simplest way would be to have a PHP page which does the database fetch and turns the value into something simple (eg. a single line of text). Now you just read the PHP page and look at that.
Hey guys
thank you for the input, I have a website that has a mysql db on it so that wont be a problem.
fungus
you said the "simplest way would be to have a PHP page which does the database fetch and turns the value into something simple (eg. a single line of text)."
are you saying have PhP display the data from the MySql db on to a page (eg read.html) and just have text that only the arduino will read?