Poll
Question: necesito ayuda con Arduion+MiFly+Mysql  para enviar datos
WiFly - 0 (0%)
Mysql - 2 (100%)
Total Voters: 2

Pages: [1]   Go Down
Author Topic: Arduion+WiFly+PHP+Mysql  (Read 1343 times)
0 Members and 1 Guest are viewing this topic.
Offline Offline
Newbie
*
Karma: 0
Posts: 26
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

hola amigos, necesito de su ayuda para poder crear un codigo para enviar desde mi placa Arduino atraves de la placa WiFly datos sobre dos sensores, de temperatura y humedad, luego mandarlos poe Wi-Fi a una base de datos Mysql. Algo asi :
Sensor 1 y 2----->arduino-------->WiFly-------->PhP----->Mysql

El condigo del sensor es este:
Code:
#include <OneWire.h>

int sensorPin = A0;    // select the input pin for the potentiometer
int sensorValue = 0;  // variable to store the value coming from the sensor
int DS18S20_Pin = 2; //DS18S20 Signal pin on digital 2

//Temperature chip i/o
OneWire ds(DS18S20_Pin); // on digital pin 2
 
void setup() {
  // declare the ledPin as an OUTPUT:
   Serial.begin(9600);  
}
 
void loop(void) {
  // read the value from the sensor:
  sensorValue = analogRead(sensorPin);    
  delay(1000);          
  Serial.print("sensor de humedad 1 = " );                      
  Serial.println(sensorValue);


 float temperature = getTemp();
 Serial.print("sensor de temperatura 1 = " );
 Serial.println(temperature);
 
 delay(1000); //just here to slow down the output so it is easier to read
  
  
 Serial.print("----------------------------" );                      
 Serial.println(" ");
}


float getTemp(){
 //returns the temperature from one DS18S20 in DEG Celsius

 byte data[12];
 byte addr[8];

 if ( !ds.search(addr)) {
   //no more sensors on chain, reset search
   ds.reset_search();
   return -1000;
 }

 if ( OneWire::crc8( addr, 7) != addr[7]) {
   Serial.println("CRC is not valid!");
   return -1000;
 }

 if ( addr[0] != 0x10 && addr[0] != 0x28) {
   Serial.print("Device is not recognized");
   return -1000;
 }

 ds.reset();
 ds.select(addr);
 ds.write(0x44,1); // start conversion, with parasite power on at the end

 byte present = ds.reset();
 ds.select(addr);  
 ds.write(0xBE); // Read Scratchpad

 
 for (int i = 0; i < 9; i++) { // we need 9 bytes
  data[i] = ds.read();
 }
 
 ds.reset_search();
 
 byte MSB = data[1];
 byte LSB = data[0];

 float tempRead = ((MSB << 8) | LSB); //using two's compliment
 float TemperatureSum = tempRead / 16;
 
 return TemperatureSum;
 
}
« Last Edit: April 29, 2012, 09:18:13 am by camilo-nunez » Logged

0
Offline Offline
Edison Member
*
Karma: 8
Posts: 1040
Arduino rocks
View Profile
 Bigger Bigger  Smaller Smaller  Reset Reset

Arduino no puede conectar con Mysql directamente, tienes que hacerlo mediante PHP y de aqui a Mysql
Logged

Trabajando en ...

    * Control Domotico (En montaje ...)
    http://casitadomotica.blogspot.com/
 

[url=https://bitbucket.org/fmalpartida

Pages: [1]   Go Up
Jump to: