I managed to store data into my database table from arduino using ESP8266-01. The php file that handle the http request supposed to echo a short message after storing the data. Currently I'm clueless on how to retrieve the massage and display it on my arduino. I've tried readStringUntil() but no luck. Really need help here...
[codeString test = "ABCDEFG";
String http = "GET /test/test_echo.php?abc=";
http += test;
http += " HTTP/1.1\r\n";
http +="Host: ";
http += ADDR;
http +=":";
http += PORT;
http +="\r\n";
http +="Connection: Close";
http +="\r\n\r\n";
int L = http.length();
esp8266.print("AT+CIPSEND=");
esp8266.println(L);
Serial.print("AT+CIPSEND=");
Serial.println(L);
Serial.println(F("waiting >"));
delay(200);
if(esp8266.find(">")){
Serial.println(F("> received"));
esp8266.println(http);
delay(5000);
if(!esp8266.find("SEND OK")){
Serial.println("SEND OK not found");
}else{
Serial.println("Data sent");
//show echo from server
}
}else{
Serial.println(F("> NOT received, something wrong!"));
}]
[/code]
php file
<?php
include_once("config/config.php");
$flag = "temp";
//from module
$abc = mysqli_real_escape_string($dbc, $_GET['abc']);
//update table with value from module
$sql = "UPDATE sometable SET abc = '$abc' WHERE flag = '$flag'";
mysqli_query($dbc, $sql);
echo "Hello";
?>