ESP8266收集温湿度上传mysql，并搭建局域网服务器

最新推荐文章于 2023-04-07 22:43:06 发布

在邯郸睡大觉

最新推荐文章于 2023-04-07 22:43:06 发布

阅读量1.1k

点赞数 2

分类专栏： ESP8266 文章标签： mysql 服务器

本文链接：https://blog.csdn.net/m0_46521000/article/details/121739266

版权

ESP8266 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

实验设计：

ESP8266收集温湿度，web局域网显示

所包含的头文件大致分为三类，DHT的驱动、8266web服务、mysql操作

#include <ESP8266WiFi.h>           // Use this for WiFi instead of Ethernet.h
#include <MySQL_Connection.h>
#include <MySQL_Cursor.h>
#include <DHT.h>
#include <NTPClient.h>
#include <WiFiUdp.h>
#include<Hash.h>
#include<ESPAsyncTCP.h>
#include<ESPAsyncWebServer.h>
#include<Adafruit_Sensor.h>
#include<Arduino.h>
#define DHTTYPE DHT11   // DHT 11
#define DHTPIN  2
DHT dht(DHTPIN, DHTTYPE);
IPAddress server_addr(81,70,50,21);  // IP of the MySQL *server* here
AsyncWebServer server(80);
char user[] = "MY_IOT";              // MySQL user login username
char password[] = "88888888";        // MySQL user login password

char INSERT_SQL[] = "INSERT INTO  my_iot.data(timer,temp,humi) VALUES ('%s',%f,%f)";
char buff[128];

String timer;

char ssid[] = "xxx";         // your SSID
char pass[] = "xxxxxxx";     // your SSID Password

WiFiUDP ntpUDP;
NTPClient timeClient(ntpUDP);

WiFiClient client;                 // Use this for WiFi instead of EthernetClient
MySQL_Connection conn(&client);
MySQL_Cursor* cursor;
float t=0.0;
float h=0.0;
unsigned long previousMillis=0;

const char interval=10000;

const char index_html[] PROGMEM = R"rawliteral(
<!DOCTYPE HTML><html>
<head>
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.7.2/css/all.css" integrity="sha384-fnmOCqbTlWIlj8LyTjo7mOUStjsKC4pOpQbqyi7RrhN7udi9RwhKkMHpvLbHG9Sr" crossorigin="anonymous">
  <style>
    html {
     font-family: Arial;
     display: inline-block;
     margin: 0px auto;
     text-align: center;
    }
    h2 { font-size: 3.0rem; }
    p { font-size: 3.0rem; }
    .units { font-size: 1.2rem; }
    .dht-labels{
      font-size: 1.5rem;
      vertical-align:middle;
      padding-bottom: 15px;
    }
  </style>
</head>
<body>
  <h2>ESP8266 DHT Server</h2>
  <p>
    <i class="fas fa-thermometer-half" style="color:#059e8a;"></i> 
    <span class="dht-labels">Temperature</span> 
    <span id="temperature">%TEMPERATURE%</span>
    <sup class="units">&deg;C</sup>
  </p>
  <p>
    <i class="fas fa-tint" style="color:#00add6;"></i> 
    <span class="dht-labels">Humidity</span>
    <span id="humidity">%HUMIDITY%</span>
    <sup class="units">%</sup>
  </p>
</body>
<script>
setInterval(function ( ) {
  var xhttp = new XMLHttpRequest();
  xhttp.onreadystatechange = function() {
    if (this.readyState == 4 && this.status == 200) {
      document.getElementById("temperature").innerHTML = this.responseText;
    }
  };
  xhttp.open("GET", "/temperature", true);
  xhttp.send();
}, 10000 ) ;

setInterval(function ( ) {
  var xhttp = new XMLHttpRequest();
  xhttp.onreadystatechange = function() {
    if (this.readyState == 4 && this.status == 200) {
      document.getElementById("humidity").innerHTML = this.responseText;
    }
  };
  xhttp.open("GET", "/humidity", true);
  xhttp.send();
}, 10000 ) ;
</script>
</html>)rawliteral";

// Replaces placeholder with DHT values
String processor(const String& var){
  //Serial.println(var);
  if(var == "TEMPERATURE"){
    return String(t);
  }
  else if(var == "HUMIDITY"){
    return String(h);
  }
  return String();
}


void setup()
{
  Serial.begin(115200);
  
  while (!Serial); // wait for serial port to connect. Needed for Leonardo only

  // Begin WiFi section
  Serial.printf("\nConnecting to %s", ssid);
  WiFi.begin(ssid, pass);
  while (WiFi.status() != WL_CONNECTED) {
    delay(500);
    Serial.print(".");
  }

  // print out info about the connection:
  Serial.println("\nConnected to network");
  Serial.print("My IP address is: ");
  Serial.println(WiFi.localIP());

  Serial.print("Connecting to SQL...  ");
  if (conn.connect(server_addr, 3306, user, password))
    Serial.println("OK.");
  else
    Serial.println("FAILED.");
  
  // create MySQL cursor object
  cursor = new MySQL_Cursor(&conn);
  dht.begin();
  timeClient.begin();
   Serial.println(WiFi.localIP());
  Serial.println(WiFi.gatewayIP());
  Serial.println(WiFi.subnetMask());
   server.on("/", HTTP_GET, [](AsyncWebServerRequest *request){
    request->send_P(200, "text/html", index_html, processor);
  });
  server.on("/temperature", HTTP_GET, [](AsyncWebServerRequest *request){
    request->send_P(200, "text/plain", String(t).c_str());
  });
  server.on("/humidity", HTTP_GET, [](AsyncWebServerRequest *request){
    request->send_P(200, "text/plain", String(h).c_str());
  });

  // Start server
  server.begin();
}

void loop()
{ 
  unsigned long currentMillis = millis();
  if (currentMillis - previousMillis >= interval)
  {
     previousMillis = currentMillis;
    t = dht.readTemperature();  
   h = dht.readHumidity();
    }
   delay(2000);
   timeClient.update();
   timer=timeClient.getFormattedTime();
   Serial.println(timer);
   float t = dht.readTemperature();  
   float h = dht.readHumidity();
   Serial.print("temperature:");
   Serial.print(t);
   Serial.print("humidity:");
   Serial.println(h);
   sprintf(buff,INSERT_SQL,timer.c_str(),t,h);
   if (conn.connected())
    cursor->execute(buff);
  delay(3000);
}

在邯郸睡大觉

关注

2
点赞
踩
20

收藏

觉得还不错? 一键收藏
5
评论
ESP8266收集温湿度上传mysql，并搭建局域网服务器

Arduino IDE进行编程。物联网系统最基础的就是数据采集，数据存储，数据处理。而ESP01S便是一款十分便宜的wifi芯片，ESP01S(4RMB),DHT11(4RMB)就可以实现数据采集，数据上传，数据存储，数据显示等功能。话不多说先上代码。#include <ESP8266WiFi.h> // Use this for WiFi instead of Ethernet.h#include <My...
复制链接

扫一扫