i will need show the data in webpage(html) and store the database(xampp server ) using esp8266. but not show the data in web page and data base. can you help me. thank you
esp8266 code
//#include <ESP8266HTTPClient.h>
#include <ESP8266WiFi.h> //esp 2.7.4 board manager
#include <SoftwareSerial.h>
#include <ArduinoJson.h>
#include <WiFiClient.h>
#include <ESP8266WebServer.h>
#include <ESP8266mDNS.h>
#include <SPI.h>
//D6 = Rx & D5 = Tx
SoftwareSerial nodemcu(12, 14);
const char* ssid = "redmi_9";
const char* password = "amila1234";
char server1[] = "192.168.43.116"; //my ip address amila pc
WiFiClient client;
WiFiServer server(80);
String header;
String pump1_State = "off";
String pump2_State = "off";
const int pump_1 = 0; //d3
const int pump_2 = 2; //d4
unsigned long currentTime = millis();
// Previous time
unsigned long previousTime = 0;
// Define timeout time in milliseconds (example: 2000ms = 2s)
const long timeoutTime = 2000;
void setup() {
Serial.begin(115200);
nodemcu.begin(9600);
while (!Serial) continue;
pinMode(pump_1, OUTPUT);
pinMode(pump_2, OUTPUT);
digitalWrite(pump_1, LOW);
digitalWrite(pump_2, LOW);
// Connect to Wi-Fi network with SSID and password
Serial.print("Connecting to ");
Serial.println(ssid);
WiFi.begin(ssid, password);
while (WiFi.status() != WL_CONNECTED) {
delay(500);
Serial.print(".");
}
// Print local IP address and start web server
Serial.println("");
Serial.println("WiFi connected.");
Serial.print("IP address : ");
Serial.println(WiFi.localIP());
// server.begin();
//Firebase.begin (FIREBASE_HOST, FIREBASE_AUTH);
}
void loop(){
int humidity1 = 15;//dht.readHumidity();
int temperature1 = 22;//dht.readTemperature();
int soilmoisture1 = 55;
int humidity2 = 23;//dht.readHumidity();
int temperature2 = 33;//dht.readTemperature();
int soilmoisture2 = 43;
StaticJsonBuffer<1000> jsonBuffer;
JsonObject& data = jsonBuffer.parseObject(nodemcu);
if (data == JsonObject::invalid()) {
//Serial.println("Invalid Json Object");
jsonBuffer.clear();
return;
}
// int ehum1 = data["humidity1"];
// Serial.println(ehum1);
// int etem1 = data["temperature1"];
// Serial.println(etem1);
// int esoil1 =data["soil1"];
// Serial.println(esoil1);
//
// int ehum2 = data["humidity2"];
// Serial.println(ehum2);
// int etem2 = data["temperature2"];
// Serial.println(etem2);
// int esoil2 =data["soil2"];
// Serial.println(esoil2);
WiFiClient client = server.available(); // Listen for incoming clients
if (client) { // If a new client connects,
Serial.println("New Client"); // print a message out in the serial port
String currentLine = "";
// int hum1= 88; //dht.readHumidity();// make a String to hold incoming data from the client
// int temp1 =33; // dht.readTemperature();
// int soil1 = 444;
//
// int hum2 = 99;
// int temp2 = 22;
// int soil2 = 555;
currentTime = millis();
previousTime = currentTime;
while (client.connected() && currentTime - previousTime <= timeoutTime) { // loop while the client's connected
currentTime = millis();
if (client.available()) { // if there's bytes to read from the client,
char c = client.read(); // read a byte, then
Serial.write(c); // print it out the serial monitor
header += c;
if (c == '\n') { // if the byte is a newline character
// if the current line is blank, you got two newline characters in a row.
// that's the end of the client HTTP request, so send a response:
if (currentLine.length() == 0) {
// HTTP headers always start with a response code (e.g. HTTP/1.1 200 OK)
// and a content-type so the client knows what's coming, then a blank line:
client.println("HTTP/1.1 200 OK");
client.println("Content-type:text/html");
client.println("Connection: close");
client.println();
// turns the LEDs on and off
if (header.indexOf("GET /1/on") >= 0) {
Serial.println("LED 1 on");
pump1_State = "on";
digitalWrite(pump_1, HIGH);
} else if (header.indexOf("GET /1/off") >= 0) {
Serial.println("pump 1 off");
pump1_State = "off";
digitalWrite(pump_1, LOW);
} else if (header.indexOf("GET /2/on") >= 0) {
Serial.println("pump 2 on");
pump2_State = "on";
digitalWrite(pump_2, HIGH);
} else if (header.indexOf("GET /2/off") >= 0) {
Serial.println("pump 2 off");
pump2_State = "off";
digitalWrite(pump_2, LOW);
}
// Display the HTML web page
client.println("<!DOCTYPE html><html>");
client.println("<head><meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">");
client.println("<link rel=\"icon\" href=\"data:,\">");
client.println("<style>html { font-family: Helvetica; display: inline-block; margin: 0px auto; text-align: center;}");
client.println(".head { position: fixed; left: 0; top: 0; width: 100%; background-color: #34495e; font-size:35px; font-weight: bold; color: white; text-align: center; }");
client.println(".footer { position: fixed; left: 0; bottom: 0; background-color: #ffff; width: 100%; color: white; text-align: center;}");
client.println(".button { background-color: #1b33d1; border: none; color: #191b26; padding: 16px 40px; width: 150px;");
client.println("text-decoration: none; font-size: 30px; margin: 2px; cursor: pointer;}");
client.println(".button2 {background-color: #e0b1bb; width: 150px;}");
//client.println("thead { font-size: 35px;background-color: #33ABF4 ;border-style: solid;border-color: red;font-weight: bold;");
//client.println("tbody { font-size: 35px;background-color: #33ABF4 ;border-style: solid;border-color: red;font-weight: bold;");
client.println("table{ font-size: 30px;background-color: #49EFCE ;border-style: solid;border-color: red;font-weight: bold;border-collapse: collapse;align:center;width: 100%;text-align: left;</style></head>");
// Web Page Heading
client.println("<div class=\"head\"> <p>Smart irrigation system</p> </div></br></br></br></br></br></br></br>");
// client.println("<img src =\" https://en.wikipedia.org/wiki/File:Light_sensor.png "/>");
client.println("<pre>");
client.println("<table border =1>");
client.println("<thead >");
client.println("<tr>");//row 1 start
client.println("<th colspan = 2 >");
client.println("FIELD 1 DATA");
client.println("</th>");
client.println("<th colspan = 2 >");
client.println("FIELD 2 DATA");
client.println("</th>");
client.println("</tr>");
client.println("</thead>");
client.println("<tbody>");
client.println("<tr>");//
client.println("<td>");
client.print("Humidity 1(%) : ");
client.println("</td>");
client.println("<td>");
client.println((int)humidity1);
client.println("</td>");
client.println("<td>");
client.print("Humidity 2 (%) : ");
client.println("</td>");
client.println("<td>");
client.println((int)humidity2);
client.println("</td>");
client.println("</tr>");//row 2 end
client.println("<tr>");//row 3 start
client.println("<td>");
client.print("Temperature 1 (°C) : ");
client.println("</td>");
client.println("<td>");
client.println((int)temperature1);
client.println("</td>");
client.println("<td>");
client.print("Temperature 2 (°C) : ");
client.println("</td>");
client.println("<td>");
client.println((int)temperature2);
client.println("</td>");
client.println("</tr>");//row3 end
client.println("<tr>");
client.println("<td>");
client.print("Soil moisture 1 : ");
client.println("</td>");
client.println("<td>");
client.println((int)soilmoisture1);
client.println("</td>");
client.println("<td>");
client.print("Soil moisture 2 : ");
client.println("</td>");
client.println("<td>");
client.println((int)soilmoisture2);
client.println("</td>");
client.println("</tr>");
client.println("</tbody>");
client.println("</table>");
client.println("</pre>");
client.println("<h3>pump 1</h3>");
// If the pump1_State is off, it displays the ON button
if (pump1_State=="off") {
client.println("<p><a href=\"/1/on\"><button class=\"button button2\">OFF</button></a></p>");
} else {
client.println("<p><a href=\"/1/off\"><button class=\"button\">ON </button></a></p>");
}
// Display current state, and ON/OFF buttons for GPIO 4
client.println("<h3>pump 2</h3>");
// If the pump2_State is off, it displays the ON button
if (pump2_State=="off") {
client.println("<p><a href=\"/2/on\"><button class=\"button button2\">OFF</button></a></p>");
} else {
client.println("<p><a href=\"/2/off\"><button class=\"button \">ON </button></a></p>");
}
client.println("</body></html>");
client.println();
break;
} else {
currentLine = "";
}
} else if (c != '\r') { // if you got anything else but a carriage return character,
currentLine += c; // add it to the end of the currentLine
}
}
}
// Clear the header variable
header = "";
// Close the connection
client.stop();
Serial.println("Client disconnected.");
Serial.println("");
}
if (client.connect(server1, 80)) {
Serial.println("connected");
client.print("GET /testcode/dht.php?humidity1="); //YOUR URL
client.print(humidity1);
client.print("&temperature1=");
client.print(temperature1);
client.print("&soilmoisture1=");
client.print(soilmoisture1);
client.print("&humidity2=");
client.print(humidity2);
client.print("&temperature2=");
client.print(temperature2);
client.print("&soilmoisture2=");
client.print(soilmoisture2);
client.print(" "); //SPACE BEFORE HTTP/1.1
client.print("HTTP/1.1");
client.println();
client.println("Host: 192.168.43.116 ");
client.println("Connection: close");
client.println();
} else {
Serial.println("connection failed");
}
}
thank you