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

实验设计：

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 Passwor