$dbhost = '127.0.0.1'; $dbuser = 'prognozer'; $dbpass = 'M9sXk21yLOzqkcS!sW'; $dbname = 'prognozer'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Greška pri spajanju na MySQL bazu'); mysql_select_db($dbname) or die(mysql_error()); mysql_query("SET NAMES 'utf8'"); if($_GET['spotmaps']=='1') { $upit=mysql_query("SELECT * FROM vrijeme WHERE regijaRed='317' ORDER BY datum DESC LIMIT 1") or die(mysql_error()); $red=mysql_fetch_array($upit); print("
|
$regije=array(301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323);
$parametri=array("temperatura","vlaga","tlak","smjer","oborine24");
if(in_array($_GET['stanica'],$regije) && in_array($_GET['parametar'],$parametri))
{
$par=$_GET['parametar'];
$upit=mysql_query("SELECT * FROM vrijeme WHERE regijaRed='".mysql_real_escape_string($_GET['stanica'])."' ORDER BY datum DESC LIMIT 1") or die(mysql_error());
$red=mysql_fetch_array($upit);
if($par=="temperatura") print($red['temperatura']." °C");
elseif($par=="vlaga") print($red['vlaga']." %");
elseif($par=="tlak") print($red['tlak']." hPa");
elseif($par=="smjer") print($red['smjer']." ".$red['brzina']." mps"); elseif($par=="oborine24") print($red['oborine24']." mm"); } ?> |