I have a code that outputs the temperature from the sensors to a web page.
I need this data to go into a mysql database every 1 hour .
Can someone help
#include <ESP8266WebServer.h>
#include <OneWire.h>
#include <DallasTemperature.h>
// Data wire is plugged into port D2 on the ESP8266
#define ONE_WIRE_BUS D2
// Setup a oneWire instance to communicate with any oneWire devices
OneWire oneWire(ONE_WIRE_BUS);
// Pass our oneWire reference to Dallas Temperature.
DallasTemperature sensors(&oneWire);
float tempSensor1, tempSensor2, tempSensor3;
uint8_t sensor1[8] = { 0x28, 0xFF, 0x10, 0x52, 0x00, 0x16, 0x02, 0x10 };
uint8_t sensor2[8] = { 0x28, 0xFF, 0x1C, 0xA5, 0x00, 0x16, 0x02, 0xC8 };
uint8_t sensor3[8] = { 0x28, 0x61, 0x64, 0x12, 0x3F, 0xFD, 0x80, 0xC6 };
/*Put your SSID & Password*/.
const char* ssid = "Home"; // Enter SSID here
const char* password = "789789"; //Enter Password here
ESP8266WebServer server(80);
void setup() {
Serial.begin(115200);
delay(100);
sensors.begin();
Serial.println("Connecting to ");
Serial.println(ssid);
//connect to your local wi-fi network
WiFi.begin(ssid, password);
//check wi-fi is connected to wi-fi network
while (WiFi.status() != WL_CONNECTED) {
delay(1000);
Serial.print(".");
}
Serial.println("");
Serial.println("WiFi connected...!");
Serial.print("Got IP: "); Serial.println(WiFi.localIP());
server.on("/", handle_OnConnect);
server.onNotFound(handle_NotFound);
server.begin();
Serial.println("HTTP server started");
}
void loop() {
server.handleClient();
}
void handle_OnConnect() {
sensors.requestTemperatures();
tempSensor1 = sensors.getTempC(sensor1); // Gets the values of the temperature
tempSensor2 = sensors.getTempC(sensor2); // Gets the values of the temperature
tempSensor3 = sensors.getTempC(sensor3); // Gets the values of the temperature
server.send(200, "text/html", SendHTML(tempSensor1,tempSensor2,tempSensor3))
}
void handle_NotFound(){
server.send(404, "text/plain", "Not found"
}
String SendHTML(float tempSensor1,float tempSensor2,float tempSensor3){
String ptr = "<!DOCTYPE html> <html>n";
ptr ="<head><meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=no">}";
ptr ="<title>ESP8266 Temperature Monitor</title>ÿn";
ptr ="<style>html { font-family: Helvetica; display: inline-block; margin: 0px auto; text-align: center;}";
ptr ="body{margin-top: 50px;} h1 {color: #444444;margin: 50px auto 30px;}"
ptr ="p {font-size: 24px;color: #444444;margin-bottom: 10px;}n";;
ptr ="</style>}n";;
ptr ="</head>}";
ptr ="<body>n";
ptr ="<div id="webpage>ƒ";
ptr ="<h1>ESP8266 Temperature Monitor</h1>n";
ptr ="<p>Living Room: ";
ptr =tempSensor1;
ptr ="°C</p>";
ptr ="<p>Bedroom: ";
ptr =tempSensor2;
ptr ="°C</p>";
ptr ="<p>Kitchen: ";
ptr =tempSensor3;
ptr ="°C</p>";
ptr ="</div>";
ptr ="</body>/p>";
ptr ="</html>n";
return ptr;
}
I need this data to go into a mysql database every 1 hour .
Can someone help
#include <ESP8266WebServer.h>
#include <OneWire.h>
#include <DallasTemperature.h>
// Data wire is plugged into port D2 on the ESP8266
#define ONE_WIRE_BUS D2
// Setup a oneWire instance to communicate with any oneWire devices
OneWire oneWire(ONE_WIRE_BUS);
// Pass our oneWire reference to Dallas Temperature.
DallasTemperature sensors(&oneWire);
float tempSensor1, tempSensor2, tempSensor3;
uint8_t sensor1[8] = { 0x28, 0xFF, 0x10, 0x52, 0x00, 0x16, 0x02, 0x10 };
uint8_t sensor2[8] = { 0x28, 0xFF, 0x1C, 0xA5, 0x00, 0x16, 0x02, 0xC8 };
uint8_t sensor3[8] = { 0x28, 0x61, 0x64, 0x12, 0x3F, 0xFD, 0x80, 0xC6 };
/*Put your SSID & Password*/.
const char* ssid = "Home"; // Enter SSID here
const char* password = "789789"; //Enter Password here
ESP8266WebServer server(80);
void setup() {
Serial.begin(115200);
delay(100);
sensors.begin();
Serial.println("Connecting to ");
Serial.println(ssid);
//connect to your local wi-fi network
WiFi.begin(ssid, password);
//check wi-fi is connected to wi-fi network
while (WiFi.status() != WL_CONNECTED) {
delay(1000);
Serial.print(".");
}
Serial.println("");
Serial.println("WiFi connected...!");
Serial.print("Got IP: "); Serial.println(WiFi.localIP());
server.on("/", handle_OnConnect);
server.onNotFound(handle_NotFound);
server.begin();
Serial.println("HTTP server started");
}
void loop() {
server.handleClient();
}
void handle_OnConnect() {
sensors.requestTemperatures();
tempSensor1 = sensors.getTempC(sensor1); // Gets the values of the temperature
tempSensor2 = sensors.getTempC(sensor2); // Gets the values of the temperature
tempSensor3 = sensors.getTempC(sensor3); // Gets the values of the temperature
server.send(200, "text/html", SendHTML(tempSensor1,tempSensor2,tempSensor3))
}
void handle_NotFound(){
server.send(404, "text/plain", "Not found"
}
String SendHTML(float tempSensor1,float tempSensor2,float tempSensor3){
String ptr = "<!DOCTYPE html> <html>n";
ptr ="<head><meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=no">}";
ptr ="<title>ESP8266 Temperature Monitor</title>ÿn";
ptr ="<style>html { font-family: Helvetica; display: inline-block; margin: 0px auto; text-align: center;}";
ptr ="body{margin-top: 50px;} h1 {color: #444444;margin: 50px auto 30px;}"
ptr ="p {font-size: 24px;color: #444444;margin-bottom: 10px;}n";;
ptr ="</style>}n";;
ptr ="</head>}";
ptr ="<body>n";
ptr ="<div id="webpage>ƒ";
ptr ="<h1>ESP8266 Temperature Monitor</h1>n";
ptr ="<p>Living Room: ";
ptr =tempSensor1;
ptr ="°C</p>";
ptr ="<p>Bedroom: ";
ptr =tempSensor2;
ptr ="°C</p>";
ptr ="<p>Kitchen: ";
ptr =tempSensor3;
ptr ="°C</p>";
ptr ="</div>";
ptr ="</body>/p>";
ptr ="</html>n";
return ptr;
}
