1#@!#!123s

D7net
: / var / www / ipwdn / administrator /
Filename : getData.php
back
<?php
define('_JEXEC', 1);
define('JPATH_BASE', dirname(__FILE__));
define('DS', DIRECTORY_SEPARATOR);
require_once JPATH_BASE.DS.'includes'.DS.'defines.php';
require_once JPATH_BASE.DS.'includes'.DS.'framework.php';

	$db =& JFactory::getDBO();
	// $query1 = "SELECT * FROM #__meteo_data WHERE id IN (SELECT MAX(id) FROM #__meteo_data GROUP BY device) ORDER BY id DESC";
    // DS: wczytanie danych z tabelki przechowującej najnowsze dane dla każdego urzadzenia
	$query1 = "SELECT * FROM #__meteo_data_current WHERE id IN (SELECT MAX(id) FROM #__meteo_data_current GROUP BY device) ORDER BY id DESC";
	$db->setQuery( $query1);
	$rows = $db->loadAssocList();
	$json_rows = json_encode($rows, JSON_FORCE_OBJECT);
    echo $json_rows;
?>