#include <ESP8266WiFi.h>

#ifndef STASSID

#define STASSID "Haging_13"
#define STAPSK "bauernhof13!"
#define LED 2

#endif

const char* ssid = STASSID;
const char* password = STAPSK;

void setup() {

Serial.begin(9600);
pinMode(LED, OUTPUT); // Port als Ausgang schalten
delay(100);

Serial.print("Connect to Wifi ");

WiFi.begin(ssid, password);

while (WiFi.status() != WL_CONNECTED) {

delay(1000);
Serial.print(".");

}

Serial.println("");
Serial.println("WiFi connected");
Serial.println("IP address: ");
Serial.println(WiFi.localIP());
pinMode(LED, OUTPUT); // Port als Ausgang schalten

}

void loop() {

digitalWrite(LED, LOW); //Led port ausschalten
delay(1000); //1 Sek Pause
digitalWrite(LED, HIGH); //Led port einschlaten
delay(1000);
if (WiFi.status() == WL_CONNECTED) {

// Your WiFi-Stuff here :-)

}

}

#include "DHT.h"

#define DHT_Type DHT22
uint8_t DHTPIN = 2; //GPIO 02
DHT dht(DHTPIN, DHT_Type);

float t;
float h;

void setup() {

Serial.begin(9600);
pinMode(DHTPIN, INPUT);
dht.begin();

}

void loop() {

h = dht.readHumidity();
t = dht.readTemperature();

Serial.print("Temperatur: ");
Serial.print(t);
Serial.print("C, Luftfeuchtigkeit: ");
Serial.print(h);
Serial.print("%");

delay(3000);

}

//DHT22 Außenposten, inkl. W-Lan und blinkender LED

#define LED 0 //GPIO00 über 330 Ohm an Masse.

#include <ESP8266WiFi.h>
#include <ESP8266HTTPClient.h>
#include <WiFiClient.h> //kann evtl. raus?
#include <Wire.h> // kann evtl. raus?
#include <Adafruit_Sensor.h> // kann evtl. raus?
#ifndef STASSID
#define STASSID "Haging_13"
#define STAPSK "bauernhof13!"
#endif

const char* ssid = STASSID;
const char* password = STAPSK;
const char* serverName = "http://192.168.178.27/post-outside.php"; //Adresse des Servers mit der SQL-Datenbank und Apache
String apiKeyValue = "tPmAT5Ab3j7F9"; //Sicherheitsspaß, dass nur dieser ESP Daten schicken darf.

#include "DHT.h"
#define DHT_Type DHT22
uint8_t DHTPIN = 2; // Der DHT22 hängt an GPIO 02
DHT dht(DHTPIN, DHT_Type);
float t;
float h;
int timer = 900;


void setup() {

pinMode(LED, OUTPUT); // Port als Ausgang schalten
Serial.begin(9600);
delay(2000);
Serial.print("Connect to Wifi ");
WiFi.begin(ssid, password);

while (WiFi.status() != WL_CONNECTED) { //solange die W-Lan verbindung aufgebaut wird, werden punkte geschrieben

delay(1000);
Serial.print(".");

}

Serial.println("");
Serial.println("WiFi connected");
Serial.print("IP address: ");
Serial.println(WiFi.localIP());

pinMode(DHTPIN, INPUT);
dht.begin();
delay(5000);

}

void loop() {

while (timer < 900) {

digitalWrite(LED, LOW); //Led port ausschalten
delay(1000); //warte 1 sec.
digitalWrite(LED, HIGH); //Led port einschlaten
delay(1000);//warte 1 sec.
timer = timer + 1;

}

Serial.println(timer);
timer = 0;
Serial.println(timer);
if (WiFi.status() == WL_CONNECTED) {

Serial.println("Your WiFi-Stuff here :-)");
WiFiClient client;
HTTPClient http;
http.begin(client, serverName);
Serial.println(serverName);

// Specify content-type header
http.addHeader("Content-Type", "application/x-www-form-urlencoded");

h = dht.readHumidity();
t = dht.readTemperature();
Serial.print("Temperatur: ");
Serial.print(t);
Serial.println(" C");
Serial.print("Luftfeuchtigkeit: ");
Serial.print(h);
Serial.println(" %");

String httpRequestData = "api_key=" + apiKeyValue + "&Luftfeuchtigkeit=" + h + "&Temperatur=" + t;
Serial.print("httpRequestData: ");
Serial.println(httpRequestData);

// Send HTTP POST request
int httpResponseCode = http.POST(httpRequestData);
if (httpResponseCode>0) {

Serial.print("HTTP Response code: ");
Serial.println(httpResponseCode);

}
else {

Serial.print("Error code: ");
Serial.println(httpResponseCode);

}
// Free resources
http.end();

}

}

CREATE TABLE outside (

id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
Luftfeuchtigkeit VARCHAR(25) NOT NULL,
Temperatur VARCHAR(25) NOT NULL,
Timestamp VARCHAR(50) NOT NULL

);

<?php

$servername = "localhost";

// REPLACE with your Database name
$dbname = "wetter";
// REPLACE with Database user
$username = "naj";
// REPLACE with Database user password
$password = "Chilli07";

// Keep this API Key value to be compatible with the ESP32 code provided in the
// project page. If you change this value, the ESP32 sketch needs to match
$api_key_value = "tPmAT5Ab3j7F9";
$Timestamp = date('d.m.Y H:i', time());

$api_key= $Luftfeuchtigkeit = $Temperatur = "";

if ($_SERVER["REQUEST_METHOD"] == "POST") {

$api_key = test_input($_POST["api_key"]);
if($api_key == $api_key_value) {

$Luftfeuchtigkeit = test_input($_POST["Luftfeuchtigkeit"]);
$Temperatur = test_input($_POST["Temperatur"]);
//$Timestamp = test_input($_POST["Timestamp"]);
$Timestamp = $Timestamp;
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO outside (Luftfeuchtigkeit, Temperatur, Timestamp)
VALUES ('" . $Luftfeuchtigkeit . "', '" . $Temperatur . "', '" . $Timestamp . "')";
if ($conn->query($sql) === TRUE) {

echo "New record created successfully";

}
else {

echo "Error: " . $sql . "
" . $conn->error;

}
$conn->close();

}
else {

echo "Wrong API Key provided.";

}

}
else {

echo "No data posted with HTTP POST.";

}
function test_input($data) {

$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;

}
?>

<div align="center">

<?php

$con = mysqli_connect("localhost","naj","Chilli07","wetter");
if (mysqli_connect_errno())
{

echo "Failed" . mysqli_connect_error();

}
$result = mysqli_query($con,"SELECT Datum, Uhrzeit, Wochentag, luftfeuchtigkeit, temperatur FROM tkschrank ORDER BY id DESC LIMIT 25");
echo "<table>";

echo "<caption>Wetterdaten TK-Schrank</caption>";
echo "<thead>";

echo "<tr>";
echo "<th scope='coll'>Datum</th>";
echo "<th scope='coll'>Uhrzeit</th>";
echo "<th scope='coll'>Tag</th>";
echo "<th scope='coll'>rF (%)</th>";
echo "<th scope='coll'>Temp.(°C)</th>";
echo "</tr>";

echo "</thead>";
while( $row = mysqli_fetch_array($result))
{

echo "<tbody>";

echo "<tr>";
echo "<td><div align=center>". $row['Datum']. "</div></td>";
echo "<td><div align=center>". $row['Uhrzeit']. "</div></td>";
echo "<td><div align=center>". $row['Wochentag']. "</div></td>";
echo "<td><div align=center>". $row['luftfeuchtigkeit']. "</div></td>";
echo "<td><div align=center>". $row['temperatur']. "</div></td>";
echo "</tr>";

echo "</tbody>";

}
echo "<tfoot>";

echo "<tr>";
echo "<td class='fuss' colspan='5'>Wetterdaten des DHT22 - Temperatur und Luftfeuchte</td>";
echo "</tr>";

echo "</tfoot>";

echo "</table>";

mysqli_close($con);
?>

</div>

//DHT22 Außenposten, inkl. W-Lan und blinkender LED und Zeit und Restart

#include <ESP8266WiFi.h>
#include <ESP8266HTTPClient.h>
#include <time.h> //time() ctime()
#ifndef STASSID
#define STASSID "Haging_13"
#define STAPSK  "bauernhof13!"
#endif

/*W-LAN und Datenübertragung an Server*/
const char* ssid     = STASSID;
const char* password = STAPSK;
const char* serverName = "http://192.168.178.27/post-outside.php"; //Adresse des Servers mit der SQL-Datenbank und Apache
String apiKeyValue = "tPmAT5Ab3j7F9"; //Sicherheitsspaß, dass nur dieser ESP Daten schicken darf.

/*Globale Variablen Time*/
time_t now;   //this is the epoch (Zeitraum)
tm tm;        // the structure tm holds time information in a more convenient (geeignet, praktisch) way
int sekunden;
int minuten;
int stunden;

/*Configuration LED*/
#define LED 0 //GPIO00 über 330 Ohm an Masse.

/*Configuration for NTP Timeserver*/
#define MY_NTP_SERVER "de.pool.ntp.org"           
#define MY_TZ "CET-1CEST,M3.5.0/02,M10.5.0/03"

#include "DHT.h"
#define DHT_Type DHT22
uint8_t DHTPIN = 2; // Der DHT22 hängt an GPIO 02
DHT dht(DHTPIN, DHT_Type);
float t;
float h;
int timer = 15;// contDown wann Daten übertragen werden sollen


void setup() {
 //Definiert die Zeitzone und den NTP-Server
 configTime(MY_TZ, MY_NTP_SERVER);
  
 pinMode(LED, OUTPUT); // Port als Ausgang schalten
 Serial.begin(9600);
 delay(2000);  
 Serial.print("Connect to Wifi "); 
 WiFi.begin(ssid, password); 
 
 while (WiFi.status() != WL_CONNECTED) {
    delay(1000);
    Serial.print("."); 
 }
   
 Serial.println("");
 Serial.println("WiFi connected");
 Serial.print("IP address: ");
 Serial.println(WiFi.localIP());

 //The ESP8266 tries to reconnect automatically when the connection is lost
  WiFi.setAutoReconnect(true);
  WiFi.persistent(true);

 pinMode(DHTPIN, INPUT);
 dht.begin();
 delay(5000);
}

void Zeit() {
  time(&now);                       // read the current time
  localtime_r(&now, &tm);           // update the structure tm with the current time
}
void loop() {
  Zeit();
  sekunden = tm.tm_sec;
  minuten = tm.tm_min;
  stunden = tm.tm_hour;
  
  if (sekunden % 2 == 0){
  digitalWrite(LED, LOW); //Led port ausschalten
  }
  else
  {
  digitalWrite(LED, HIGH); //Led port einschlaten
    Serial.print(stunden);
    Serial.print(":");
    Serial.print(minuten);
    Serial.print(":");
    Serial.print(sekunden);
    Serial.println(" - Stunden:Minuten:Sekunden");
  } 
  delay(1000); //warte 1 sec

  if (sekunden == 1){
    if (minuten == 0 or minuten == 15 or minuten == 30 or minuten == 45){
      if (WiFi.status() == WL_CONNECTED) {
       Serial.println("Your WiFi-Stuff here :-)");
       WiFiClient client;
       HTTPClient http;
       http.begin(client, serverName);
       Serial.println(serverName);
    
       // Specify content-type header - ohne keine Datenübertragung möglich!
        http.addHeader("Content-Type", "application/x-www-form-urlencoded");
    
        h = dht.readHumidity();
        t = dht.readTemperature();
        Serial.print("Temperatur: ");
        Serial.print(t);
        Serial.println(" C");
        Serial.print("Luftfeuchtigkeit: ");
        Serial.print(h);
        Serial.println(" %");
    
        String httpRequestData = "api_key=" + apiKeyValue + "&Luftfeuchtigkeit=" + h + "&Temperatur=" + t;
        Serial.print("httpRequestData: ");
        Serial.println(httpRequestData);
        
        // Send HTTP POST request
        int httpResponseCode = http.POST(httpRequestData);
        if (httpResponseCode>0) {
          Serial.print("HTTP Response code: ");
          Serial.println(httpResponseCode);
        }
        else {
          Serial.print("Error code: ");
          Serial.println(httpResponseCode);
        }
    // Free resources
    http.end();
    }
  }
  }
  /*Neustart:
  if (minuten  == 5 and sekunden == 5){ 
      Serial.println("Starte neu");
      //ESP.restart();
      ESP.reset();
    }*/
}