ESP-01 + DHT11 + LED

ESP8266 ES-01獨立使用

void setup() {} 
void loop() {}

Arduino Uno & ESP-01 線路

void setup() {
pinMode(2, OUTPUT);
}
void loop() {
digitalWrite(2, HIGH); // turn the LED on (HIGH is the voltage level)
delay(1000); // wait for a second
digitalWrite(2, LOW); // turn the LED off by making the voltage LOW
delay(1000); // wait for a second
}

ESP8266 ES-01獨立使用 透過 WebSite 點亮 LED

#include <ESP8266WiFi.h>
#define _baudrate 9600
const char* ssid = "D-Link_DIR-612";//type your ssid
const char* password = "123456789";//type your password
int ledPin = 2; // GPIO2 of ESP8266
WiFiServer server(80);
const char* host = "192.168.20.3";
const int httpPort = 80;
unsigned long time_interval=60000;
void setup() {
Serial.begin( _baudrate );
pinMode(2, OUTPUT);
Serial.println( "ESP8266 Ready!" );
// Connecting to a WiFi network
Serial.print("Connect to... ");
WiFi.begin(ssid, password);
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( "" );
}
String turnx="";
void loop() {
// 設定 ESP8266 作為 Client 端
WiFiClient client;
if (!client.connect(host, httpPort)) {
Serial.println( "connection failed" );
return;
}
delay(1000);
String url = "/iot/turn2.txt";
url+="\r\n";
client.print(String("GET ") + url + " HTTP/1.1\r\n" +
"Host: " + host + "\r\n" +
"Connection: keep-alive\r\n\r\n");
//"Connection: close\r\n\r\n");
delay(1000);
// 讀取所有從 IoT Server 的回應並輸出到串列埠
while(client.available())
{
String line = client.readStringUntil('\r');
//Serial.print(line);
turnx=line;
}
if(turnx=="On")
{
digitalWrite(2, HIGH);
Serial.print("trun="+turnx+"\r\n");
}
else
{
digitalWrite(2, LOW);
Serial.print("Notrun="+turnx+"\r\n");
}
delay(1000);
}

ESP8266 ES-01獨立使用 DHT11 傳送至WebSite

#include <ESP8266WiFi.h>
//DHT
#include <DHT.h>
#define DHTTYPE DHT11
#define DHTPIN  0
//
#define _baudrate   9600
const char* ssid = "D-Link_DIR-612";//type your ssid
const char* password = "123456789";//type your password
 
int ledPin = 2; // GPIO2 of ESP8266
WiFiServer server(80);
const char* host = "192.168.20.3";
const int httpPort = 80;
unsigned long time_interval=60000;
//DHT
DHT dht(DHTPIN, DHTTYPE, 11);    // 11 works fine for ESP8266
float humidity, temp_f;   // 從 DHT-11 讀取的值
unsigned long previousMillis = 0;        // will store last temp was read
const long interval = 2000;              // interval at which to read sensor
void setup() {
Serial.begin( _baudrate );
pinMode(ledPin, OUTPUT);
  Serial.println( "ESP8266 Ready!" ); 
  // Connecting to a WiFi network
  Serial.print("Connect to... ");
  WiFi.begin(ssid, password);
  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( "" );
  // Start the server
  //server.begin();
}
String turnx="";
void loop() {
  // 設定 ESP8266 作為 Client 端
  WiFiClient client;
 if (!client.connect(host, httpPort)) {
    Serial.println( "connection failed" );
    return;
  }
  delay(1000);
  
 String url = "/iot/turn2.txt";
  url+="\r\n";
  client.print(String("GET ") + url + " HTTP/1.1\r\n" +
               "Host: " + host + "\r\n" + 
               "Connection: keep-alive\r\n\r\n");
               //"Connection: close\r\n\r\n"); 
  delay(1000);
 
        // 讀取所有從 IoT Server 的回應並輸出到串列埠
         while(client.available())
        {
            String line = client.readStringUntil('\r');
            //Serial.print(line);
            turnx=line;
        }
        
  if(turnx=="On")
    {
      digitalWrite(ledPin, HIGH); 
      Serial.print("trun="+turnx+"\r\n");
    }
    else
    {
      digitalWrite(ledPin, LOW);
      Serial.print("Notrun="+turnx+"\r\n");
    }   
    
  delay(1000);
  gettemperature();//DHT偵測  
}
void gettemperature() {
  // 量測間等待至少 2 秒
  unsigned long currentMillis = millis();
 
  if(currentMillis - previousMillis >= interval) {
    // 將最後讀取感測值的時間紀錄下來 
    previousMillis = currentMillis;   
    // 讀取溫度大約 250 微秒!
    humidity = dht.readHumidity();          // 讀取濕度(百分比)
    temp_f = dht.readTemperature(true);     // 讀取溫度(華氏)
    
    // 檢查兩個值是否為空值
    if (isnan(humidity) || isnan(temp_f)) {
      Serial.println("Failed to read from DHT sensor!");
      return;
    }
    else
    {
      WiFiClient client;
  if (!client.connect(host, httpPort)) {
    Serial.println( "connection failed" );
    return;
  }
  delay(1000);
  
        //Serial.print(temp_f);
         String url = "/iot/insert.php?t=";
         url+=temp_f;
         url+="&h=";
         url+=humidity;
         url+="\r\n";
        client.print(String("GET ") + url + " HTTP/1.1\r\n" +
               "Host: " + host + "\r\n" + 
               "Connection: close\r\n\r\n"); 
         Serial.println("Send DHT sensor ok!");
        delay(1000);
    }
    }
}

<?php
//資料庫 設定 
 $db_host = "localhost"; //路徑
 $db_username = "root"; //帳號
 $db_password = "1234"; //密碼
 $db_name = "iot20211008"; 
 //pdo -> mysql連線
 try{
	 $db_link = new PDO("mysql:host={$db_host};dbname={$db_name};charset=utf8",$db_username,$db_password);
 }catch(PDOException $e){
	 print "資料庫連結失敗...Msg:{$e->getMessage()}<br/>";
	 die();
 }
 
$data = [$_GET["t"],
		 $_GET["h"]
		];
$query_insert = "INSERT INTO sensor2 (temperature,humidity ,datex) VALUES (?,?, NOW())";
$stmt = $db_link->prepare($query_insert);
$stmt->execute($data);
?>

資料庫結構