<?php
include 'Database.php';
$database = new Database();
$con = $database->getConnection();
$sql = "SELECT id_wasp,sensor, value, MAX(timestamp) as max_data from sensorparser GROUP BY id_wasp, sensor";
$result = $con->query($sql)->fetchAll(PDO::FETCH_ASSOC);
header("content-type:application/json");
$value = str_replace("filename", "fileName", json_encode($result));
$value = str_replace("folderdirectory", "folderDirectory", $value);
$value = str_replace("lastchange", "lastChange", $value);
echo $value;
$database->closeConnection();
$database = null;
$con = null;
exit();
Partager