START of ARDUINO CODE ************************* #include #include
int bstate = 0; // This is the variable we will send, but it will be formated as String first. String txData =""; // This is the Data that will be sent to the PHP page. It wil l have variable names and data in it. // Local Network Settings // My mac 90-A2-DA-0D-83-9D Must be unique on local network // (should be on the back of ethernet shield) byte mac[] = { 0x90, 0xA2, 0xDA, 0x0D, 0x83, 0x9D }; byte ip[] = { 192, 168, 1, byte gateway[] = { 192, 168, 1, you need them byte subnet[] = { 255, 255, 255, e you need them
199 }; // Must be unique on local network 1 }; // I left these in for reference in case 0 }; // I left these in for reference in cas
void setup() { Ethernet.begin(mac, ip); // Mine works with just the mac and ip. Gateway and D NS may be needed. //Depending on your router setup, you may need to // reference http://arduino.cc/en/ Reference/EthernetBegin Serial.begin(9600); // Just for output so we can see if its working delay(1000); } void loop() { bstate++; // This just adds one to the variable "bstate" each time thru the loo p. I just did this for testing // I send the data as a String. I read about some havi ng difficulties sending integers. // 'txData' is a string that is sent to the PHP page. txData = "BUTTON_STATE="+ (String (bstate)); // 'BUTTON_STATE' is the POST varia ble that the PHP page is looking for. // The '+' puts the string parts to gether. //
'(String (bstate))' formats 'bs
tate' from a numerical value to a string. // Multiples would look like //txData = "VARIABLE1="+ (String (v ar1))+"&VARIABLE2=" (String(var2)); EthernetClient client;
//("yourwebsite.com",80) could also be, I think an IP, (xxx.xxx.xxx.xxx,80) or // you could define a variable 'server ' like we did with 'ip' and 'mac' // like this, 'byte server[] = { xxx, xxx, xxx, xxx }' // then this line would look like 'if (client.connect(server,80))' if (client.connect("yourwebsite.com",80)) { Serial.println("Connected to yourwebsite..."); // This isn't required, just for feedback Serial.println(); // HERE IS THE MEAT AND GRAVEY // The '/update/update.php' is the d irectory and file you are sending to // if the file is in the root of th e domain it would just be '/update.php' client.print("POST /update/update.php HTTP/1.1\n"); //
yourwebsite.com, domain where t
he php file is hosted client.print("Host: yourwebsite.com\n"); client.print("Connection: close\n"); client.print("Content-Type: application/x-www-form-urlencoded\n"); client.print("Content-Length: "); // Remember our variable txData? It has all of the info we are sen ding // to the PHP page, 'update.php'. BUT, the PHP page needs to know how many characters // are comming. We give it by using 'txData.length()' client.print(txData.length()); client.print("\n\n"); client.print(txData); // after all of the required junk we send the data } else { Serial.println("Connection Failed."); // Again the Serial is for feedback. Serial.println(); } delay(5000); //this delay was for my test to send a number every 5 sec } *********************** END of ARDUINO CODE ***************************************************************************** Next... Make a PHP file called config.php. START of PHP CODE for config.php *********************************************
$dbhost = 'localhost'; //mysql server address, it can be an ip address typically it is 'localhost' // It could look like 'mysqlserv er.mydomain.com' // To access the mysql datab ase you need a username and password $dbuser = 'mydatabase_username'; $dbpass = 'mydatabase_password'; $dbname = 'mydatabase_name'; //This is the name of your database on the mysql se rver $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to my sql'); mysql_select_db($dbname); ?> ******************************************* END of PHP CODE for config.php *******************************************
AND 'DEN... Make a file called update.php START of PHP CODE for update.php ********************************************** ******************************************* END of PHP CODE for update.php ******************************************* NOTES Multiple variables being posted might look like $query = "INSERT INTO MY_TABLE(VAR1, VAR2, VAR3) VALUES('$_POST[VAR1]','$_POST[VAR2]','$_POST[VAR3]')"; In PHP, you can break lines for readability. End of line/statement is denoted by the semicolon.
