distance_php

<?php
$page = $_SERVER['PHP_SELF'];
$sec = "5";
header("Refresh: $sec; url=$page");

$servername = "localhost";
$username = "id8804958_user";
$password = "taimekasvatamine";
$dbname = "id8804958_taimekasvatamine";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
if(!empty($_GET['distance']) || !empty($_GET['light']) ){
$sql = "INSERT INTO Distance (Distance, Light)
VALUES (".htmlspecialchars($_GET["distance"]).",".htmlspecialchars($_GET["light"]).")";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";

} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
}
else{
$sql2 = "SELECT Light FROM Distance ORDER BY ID DESC LIMIT 1";
$lightresult = $conn->query($sql2);
 while($row = $lightresult->fetch_assoc()) {
        echo  $row["Light"]. " valgusühikut. <br> <br>Skaalal 1-5 (valgest-pimedani). <br><br>";
        if(floatval($row["Light"]) < 1){
            echo  " Liiga valge lambi jaoks <br>";
            $myfile = fopen("led.txt", "w") or die("Unable to open file!");
            $txt = "OFF";
            fwrite($myfile, $txt);
            fclose($myfile);
        } else {

            echo " Vajuta värvi vahetamiseks nuppu <br>";

            $myfile = fopen("led.txt", "w") or die("Unable to open file!");
            $txt = "green";
            if (isset( $_POST['OFF'])){
            $txt = "OFF";
            }else if(isset($_POST['rainbow'])){
            $txt = "rainbow";
            }else if(isset($_POST['red'])){
            $txt = "red";
            }else if(isset($_POST['blue'])){
            $txt = "blue";
            }else if(isset($_POST['green'])){
            $txt = "green";
            }else if(isset($_POST['yellow'])){
            $txt = "yellow";
            }else if(isset($_POST['purple'])){
            $txt = "purple";
            }else if(isset($_POST['aqua'])){
            $txt = "aqua";
            }
            fwrite($myfile, $txt);

            fclose($myfile);
        }
    }
}

$sql3 = "SELECT Date(Time) as kuupaev, (SELECT Distance FROM Distance AS D2 WHERE Date(Time)=Date(D1.Time) GROUP BY Distance ORDER BY COUNT(*) DESC LIMIT 1) AS pikkus From Distance as D1 GROUP BY Date(D1.Time)";
$result = $conn->query($sql3); //ÕIGE

$csvfile = fopen('plantheight.csv', 'w');
if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        fputcsv($csvfile, $row);
    }
} else {
   // echo "0 results";
}
fclose($csvfile);

$conn->close();
?>
<!DOCTYPE html>
<html>
<body>
<h3>Tulukesed</h3>
<form action="" method="POST">
<input type="submit" name="OFF">Väljas <br>
<input type="submit" name="rainbow">Vikerkaar <br>
<input type="submit" name="red">Punane <br>
<input type="submit" name="blue">Sinine <br>
<input type="submit" name="green">Roheline <br>
<input type="submit" name="yellow">Kollane <br>
<input type="submit" name="purple">Lilla <br>
<input type="submit" name="aqua">Aqua
</form>

</body>
</html>