Arduino+WiFly+PHP+Mysql help please !

Wireless & IoT
1

hello friends, I need your help to create a code to send from my Arduino board THROUGH Wifly data on two sensors, temperature and humidity, then send poems to a Wi-Fi Mysql database. Something like this:

Sensor 1 and 2 -----> arduino --------> Wifly -------->PHP---------> Mysql

The code of the sensors is this:

#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;
 
}

excuse my English, my language is the Spanish :slight_smile:

2

try to make a code to send from the client through a special Wifly a php page that goes directly to the database

#include "WiFly.h"
#include "Credentials.h"
 
Client client( "www.cnf.cl", 80 );
 
int looped = 0;
 
void setup()
{
  Serial.begin( 9600 ); 
  WiFly.begin();
   
  if( !WiFly.join( ssid, passphrase ) ) 
  {
    Serial.println( "Association failed." );
     
    while( 1 ) 
    {
      // Hang on failure.
    }
  }
}
 
void loop()
{
  String dato1 = "dato1=123123123123";
   
  if( client.connect() ) 
  {
    Serial.println( dato1 );
 
    client.println( "GET /arduino/agregar.php? HTTP/1.1" );
    client.println( "Host: www.cnf.cl" );
    client.println( "Content-Type: application/x-www-form-urlencoded" );
    client.println();
    client.print( dato1 );
    client.println();
    client.print( "Content-Length: " );
    client.println( dato1.length() );
    client.println( "Connection: close" );
  }
   
  delay( 20000 );
}
3

I do not know anything about the Arduino, but I have code that uses the Propeller(SPIN) that will send data from the processor>WiflyRn134>LAN to a webserver with a PHP page that connects to mysql and reads or writes what you want. I do not use Wifly in the mode that you put in the remote webserver and store it is as preset. I tell the Wifly everything from the Propeller. No info gets stored in the Wifly, I do not like that mode. If you think that the Propeller code and the PHP will help you, I can post examples of both. This is very easy to do.