DHT11上傳到mySQL

出自TSK WIKI
於 2020年6月18日 (四) 22:52 由 Unknown user​(留言) 所做的修訂 (已建立頁面,內容為 "==程式碼== <c> #include "DHTesp.h" #include <ESP8266WiFi.h> //*-- Hardware Serial #define _baudrate 115200 //*-- IoT Information #define SSID "stanley_m" #…")
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

程式碼

<c>

  1. include "DHTesp.h"
  2. include <ESP8266WiFi.h>

//*-- Hardware Serial

  1. define _baudrate 115200

//*-- IoT Information

  1. define SSID "stanley_m"
  2. define PASS "12345678"
  3. define HOST "tskds213.synology.me" // ThingSpeak IP Address: 184.106.153.149
  4. 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>