ttnlora_env_payloaddata.php

<?php

// DEZE MOET JE FF AANPASSEN
include './ttnlora_env_vars.php';

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$filter_id = NULL;
$filter_from = NULL;
$filter_to = NULL;

if (isset($_GET["id"])) 
{
	$filter_id = $_GET["id"];
	$filter_id = $conn->real_escape_string($filter_id);
}

if (isset($_GET["to"])) 
{
	$filter_to = $_GET["to"];
	$filter_to = $conn->real_escape_string($filter_to);
}
else 
{
	$filter_to = new DateTime();
	$filter_to = $filter_to->format("Y-m-d H:i:s");
}

if (isset($_GET["from"])) 
{
	$filter_from = $_GET["from"];
	$filter_from = $conn->real_escape_string($filter_from);
}
else
{
	$dt = new DateTime();
	$dt->modify("-1 day");
	$filter_from = $dt;
	$filter_from = $filter_from->format("Y-m-d H:i:s");
}

// debug
//echo "// $filter_id \n";
//echo "// $filter_from \n";
//echo "// $filter_to \n";

echo "[\n";

$first = true;

$sql = "SELECT Raw FROM Measurement WHERE DevID = '$filter_id' AND TimeStampUTC >= '$filter_from' AND TimeSTampUTC <= '$filter_to'";

$result = $conn->query($sql);

if (!$result) {
    echo 'Invalid query: ' . $conn->error;
}

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) 
    {
    	if (!$first)
    	{
    		echo ",\n";
    	}
	$first = false;

	$raw = $row["Raw"];

	echo $raw;
        echo "\n";
    }
} 

echo "\n]\n";
$conn->close();
?>