DHT11上傳到mySQL
程式碼
<c>
- include "DHTesp.h"
- include <ESP8266WiFi.h>
//*-- Hardware Serial
- define _baudrate 115200
//*-- IoT Information
- define SSID "stanley_m"
- define PASS "12345678"
- define HOST "tskds213.synology.me" // ThingSpeak IP Address: 184.106.153.149
- define PORT 8087
String GET = "GET /test/dht11.php?api=123"; DHTesp dht; //float temperature,humidity; void setup() {
Serial.begin(9600);
Serial.begin( _baudrate );
Serial.println( "ESP8266 Ready!" );
// Connecting to a WiFi network
Serial.print("Connect to ");
Serial.println( SSID );
WiFi.begin( SSID, PASS );
// 持續等待並連接到指定的 WiFi SSID
while( WiFi.status() != WL_CONNECTED )
{
delay(500);
Serial.print( "." );
}
Serial.println( "" );
Serial.println( "WiFi connected" ); Serial.println( "IP address: " ); Serial.println( WiFi.localIP() ); Serial.println( "" ); // DHT11 dht.setup(2, DHTesp::DHT11); Serial.println( "DHT11 Ready!" ); delay(2000);
}
void loop() {
delay(dht.getMinimumSamplingPeriod());
float humidity = dht.getHumidity();
float temperature = dht.getTemperature();
Serial.println(dht.getStatusString());
Serial.println("Temperature");
Serial.println(temperature);
Serial.println("Humidity");
Serial.println(humidity);
updateDHT11(temperature,humidity);
delay(20000);
}
String updateDHT11(float temperature,float humidity) {
// 設定 ESP8266 作為 Client 端
WiFiClient client;
if( !client.connect( HOST, PORT ) )
{
Serial.println( "connection failed" );
//return;
}
else
{
// 準備上傳到 ThingSpeak IoT Server 的資料
// 已經預先設定好 ThingSpeak IoT Channel 的欄位
// field1:溫度;field2:濕度
String getStr = GET + "&t=" + String(temperature) +
"&h=" + String(humidity) +
" HTTP/1.1\r\n";
Serial.println(getStr);
client.print( getStr );
client.print( "Host: tskds213.synology.me\n" );
client.print( "Connection: close\r\n\r\n" );
delay(10);
//
// 處理遠端伺服器回傳的訊息,程式碼可以寫在這裡!
//
while(client.available()){ //取得資料
String line = client.readStringUntil('\r'); //一列資料
Serial.print(line);
}
client.stop(); }
} </c>