Go Down

Topic: Arduion+WiFly+PHP+Mysql (Read 1 time) previous topic - next topic

Apr 29, 2012, 02:20 am Last Edit: Apr 29, 2012, 04:18 pm by camilo-nunez Reason: 1
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: [Select]
#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;

}

flico

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

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

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

Go Up
 


Please enter a valid email to subscribe

Confirm your email address

We need to confirm your email address.
To complete the subscription, please click the link in the email we just sent you.

Thank you for subscribing!

Arduino
via Egeo 16
Torino, 10131
Italy