NodeMCU ESP8266连接WiFi与MySQL后无法执行digitalWrite控制内置LED问题求助

Let's break down why your built-in LED isn't reacting even though you're correctly fetching the payload from your MySQL database, and fix it step by step:

1. Check the Built-in LED's Level Logic (Most Likely Culprit) #

NodeMCU ESP8266 boards have their built-in LED (GPIO2 / D4) reverse-wired—meaning:

• digitalWrite(LED_BUILTIN, HIGH) turns the LED OFF
• digitalWrite(LED_BUILTIN, LOW) turns the LED ON

Looking at your code:

if (payloadGet == "1") {
  digitalWrite(LED_BUILTIN, HIGH); // This actually TURNS THE LED OFF
}
if (payloadGet == "0") {
  digitalWrite(LED_BUILTIN, LOW); // This TURNS THE LED ON
}

Your logic is inverted! Fix it by swapping the HIGH/LOW values to match your intended behavior:

if (payloadGet == "1") {
  digitalWrite(LED_BUILTIN, LOW); // Now this lights up the LED
}
if (payloadGet == "0") {
  digitalWrite(LED_BUILTIN, HIGH); // This turns it off
}

2. Fix String Matching Issues (Hidden Characters in Payload) #

Your PHP script might be returning extra hidden characters (like newlines, spaces, or whitespace) along with "1" or "0". This makes payloadGet == "1" fail even if it looks correct in the serial monitor.

Quick Fixes: #

• Trim the payload to remove extra whitespace before comparison:

  payloadGet.trim(); // Removes spaces, newlines, tabs from start/end
  if (payloadGet == "1") {
    // ... your LED logic
  }
  

• Convert to integer for more reliable comparison:

  int ledStatus = payloadGet.toInt(); // Converts string to integer
  if (ledStatus == 1) {
    digitalWrite(LED_BUILTIN, LOW);
  } else if (ledStatus == 0) {
    digitalWrite(LED_BUILTIN, HIGH);
  }
  

• For debugging, print the payload length to check for extra characters:

  Serial.print("Payload length: ");
  Serial.println(payloadGet.length()); // If length >1, there's extra characters
  

3. Verify Pin Access After WiFi Connection #

While rare, WiFi initialization can sometimes interfere with GPIO pins. Add a quick test in your setup() to confirm the LED is responsive after WiFi connects:

// After WiFi connects successfully
digitalWrite(LED_BUILTIN, LOW);
delay(1000);
digitalWrite(LED_BUILTIN, HIGH);
delay(1000);

If the LED blinks here, the pin is working—so the issue is definitely with your payload comparison or logic.

4. Isolate the Problem #

To confirm it's not a WiFi/database side issue:

• Temporarily comment out all WiFi/HTTPClient code
• Hardcode payloadGet = "1"; in your loop
• Check if the LED responds as expected. If it does, the problem is in how you're handling the payload from the server.

内容的提问来源于stack exchange，提问作者premium Pertamax