<?php
$url = 'https://mikrotechrs.000webhostapp.com/';

$urlTemperature = $_GET['temp'];
$getTemp = $_GET['gettemp'];

$servername = 'localhost';
$username = 'id2058220_mikrotechrs';
$password = 'RS2805375';

$conn = new mysqli($servername, $username, $password);
$conn->select_db("id2058220_temperaturedata");

if (isset($urlTemperature)) {
    if ($urlTemperature != $currentTemperature) {
        $insertTemperatures = "INSERT INTO `temperatures`(`temperature_value`) VALUES ($urlTemperature)";
        $conn->query($insertTemperatures);
    }
} else if (isset($getTemp)) {
    $lastTemperature = $conn->query("SELECT temperature_value FROM temperatures ORDER BY id DESC LIMIT 1");
    $currentTemperature = $lastTemperature->fetch_assoc()["temperature_value"];

    echo json_encode($currentTemperature);
} else {
    $lastTemperature = $conn->query("SELECT temperature_value FROM temperatures ORDER BY id DESC LIMIT 1");
    $currentTemperature = $lastTemperature->fetch_assoc()["temperature_value"];
    echo "<script>
            window.onload = function() {
                setInterval(function() {
                    var promise = fetch('https://mikrotechrs.000webhostapp.com/?gettemp=true').then(function(response) {
                        response.json().then(function(value) {
                            document.getElementsByClassName('temp-text')[0].innerHTML = 'Температура в помещении ' + value + ' °С'
                        })
                    })
                }, 500)

            }
          </script>
          <link href='https://fonts.googleapis.com/css?family=Inconsolata' rel='stylesheet'>
          <style>
          .temp-container {
            display: flex;
            justify-content: center;
            align-items: center;
          }

          .temp-text {
            font-family: 'Inconsolata', monospace;
          }

          </style>
      <div class='temp-container'>
        <h1 class='temp-text'>Температура в помещении $currentTemperature °С</h1>
      </div>";
}
?>