lastUpdate.php

<?php


if (isset($_POST["param"])){
include("../include/config.php");
require_once("../classes/SQL.php");

	$sql = new SQL($DBHOST, $DBUSER, $DBPASS, $DBNAME);
	$link = $sql->getLink();

	$query = "SELECT ".$TBL_DATA.".id as id, ".$TBL_PARAMETER.".param as param, ".$TBL_DATA.".value as value, DATE_FORMAT(".$TBL_DATA.".timestamp, '%d.%m.%Y %H:%i:%s') as date FROM (".$TBL_REGISTER." INNER JOIN ".$TBL_PARAMETER." ON ".$TBL_REGISTER.".id = ".$TBL_PARAMETER.".fid_register) INNER JOIN ".$TBL_DATA." ON ".$TBL_PARAMETER.".id = ".$TBL_DATA.".fid_parameter WHERE ".$TBL_DATA.".fid_parameter = ".$_POST["param"]." ORDER BY ".$TBL_DATA.".id DESC LIMIT 1";

	$result = $link->query($query);
        while($row = $result->fetch_assoc()) {
        	echo '{"update":"'.$row["date"].'", "value":"'.$row["value"].'"}';
        }

}

?>