Speichern von Daten aus NodeMCU PHP MySQL

Ich arbeite derzeit für mein Abschlussprojekt, aber ich habe ein problem. Ich will senden meine sensor-Daten auf MySQL Datenbank mit XAMPP und phpMyAdmin. Ich habe mit NodeMCU für die WiFi-Verbindung. Aber ich bin nicht in der Lage zum senden des Wertes.

Hier ist der vollständige code von meiner Arbeit.

#include <ESP8266HTTPClient.h>
#include <ESP8266WiFi.h>
#include <WiFiEsp.h>
#include <WiFiEspClient.h>

//Sensor 1
int sensorPin1 = 5;
int ledPin1 = 13;

//Sensor 2
int sensorPin2 = 4;
int ledPin2 = 12;

//Sensor 3
int sensorPin3 = 0;
int ledPin3 = 14;

//Wifi Connection
const char* ssid = "xxxxxx";
const char* password = "xxxxx";
const char* web = "192.168.1.69";

int status = WL_IDLE_STATUS;

WiFiServer server(80);

//Initialize the Wifi werver library
WiFiClient client;


void setup(void) {
  //start serial port
  Serial.begin(9600);

  pinMode(ledPin1, OUTPUT);
  pinMode(ledPin2, OUTPUT);
  pinMode(ledPin3, OUTPUT);

  //Connect to 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");
   //Start the server  
   server.begin();  
   Serial.println("Server started");
   //Print the IP address  
   Serial.print("This is your ip address: ");  
   Serial.print(WiFi.localIP());  

}

void loop() {
  //Check if a client has connected  
  WiFiClient client = server.available();  
  if (!client) {    
    return;
  }
  //Wait until the client sends some data  
  Serial.println("new client");
  while(!client.available()){    
    delay(1);  
  }
  //Read the first line of the request  
  String request = client.readStringUntil('\r');  
  Serial.println(request);  
  client.flush(); //Match the request
 if (client.connect(web, 80)) {
  int sensor = digitalRead(sensorPin1);
  int sensor1 = digitalRead(sensorPin2);
  int sensor2 = digitalRead(sensorPin3);
  //connect to the server (your computer or web page)
    Serial.println("--> connection ok\n");
    client.print("POST /smart_parking/sensor.php?"); //This
    client.print("sensor=");
    client.print(sensor);
    client.print("&sensor1=");
    client.print(sensor1);
    client.print("&sensor2=");
    client.print(sensor2);
//   client.print("sensor="); //This
//   client.print("100");
    client.println(" HTTP/1.1");
    client.print("Host: ");
    client.println(web);
    client.println("Connection: close"); //Part of the GET request telling the server that we are over transmitting the message
    client.println();//empty line
    client.println(); //empty line
    client.stop(); //Closing connection to server
    Serial.println("--> finished transmission\n");
   }
    else {
    //If Arduino can't connect to the server (your computer or web page)
    Serial.println("--> connection failed\n");
  }
}
  • Schön, Passwort....
Schreibe einen Kommentar