关键点说明:
原文地址:
ESP32/ESP8266 Insert Data into MySQL Database using PHP and Arduino IDE
完成项目的步骤:
软件部分:
1,使用phpstudu_pro架构建立php+mysqlh服务器
2,使用ARDUINO IDE在ESP8266或ESP12F上编写WIFICLIENT
硬件部分:
ESP8266/ESP32/ESP12F等带数据线
DO IT:
服务器制作部分这里就不再赘述了,这个得自己弄,简单点的就用phpstudy_pro,很快就搞定了。
我们说说ESP这边。
#include <ESP8266WiFi.h>
const char* ssid = "your-ssid";
const char* password = "your-password";
const char* host = "your host ip address";
const String apiKeyValue = "tPmAT5Ab3j7F9";
const String sensorName = "BME280";
const String sensorLocation = "Office";
const int httpPort = 80;
const String url = "/replace with your serve page location that post-html-data.php";
void setup() {
Serial.begin(115200);
delay(10);
// We start by connecting to a WiFi network
Serial.println();
Serial.println();
Serial.print("Connecting to ");
Serial.println(ssid);
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.