// Standard Source view option check function check_sourceview () { global $SITE; if (isset($_GET['view']) && $_GET['view'] == 'sce') { $filenameReal = __FILE__; $download_size = filesize($filenameReal); header('Pragma: public'); header('Cache-Control: private'); header('Cache-Control: no-cache, must-revalidate'); header('Content-type: text/plain'); header('Accept-Ranges: bytes'); header("Content-Length: $download_size"); header('Connection: close'); readfile($filenameReal); exit; } } // Just list the PHP source? check_sourceview(); // get the input parameters if (isset($_GET["mm"])) { $month = intval($_GET["mm"]); } else { die("No 'mm' parameter supplied"); } if ($month == "") { die("Invalid 'mm' parameter supplied"); } // get the input parameters if (isset($_GET["yy"])) { $year = intval($_GET["yy"]); } else { die("No 'yy' parameter supplied"); } if ($year == "") { die("Invalid 'yy' parameter supplied"); } // Connect to the database $con=@mysql_connect($dbhost='meteosegrr2.mysql.db', $dbuser='meteosegrr2', $dbpassword='Patrick19', $database='meteosegrr2'); if (!$con) { echo "failed to connect to the database server"; exit(); } if (!mysql_select_db($database,$con)) { echo "Failed to connect to the database on the server"; exit(); } # # The db querys # /*$CreateQuery = "CREATE TABLE $param_table (LogDate date NOT NULL ,HighWindGust decimal(4,1) NOT NULL,HWindGBear varchar(3) NOT NULL,THWindG varchar(5) NOT NULL,MinTemp decimal(5,1) NOT NULL,TMinTemp varchar(5) NOT NULL,MaxTemp decimal(5,1) NOT NULL,TMaxTemp varchar(5) NOT NULL," . "MinPress decimal(6,2) NOT NULL,TMinPress varchar(5) NOT NULL,MaxPress decimal(6,2) NOT NULL,TMaxPress varchar(5) NOT NULL,MaxRainRate decimal(4,1) NOT NULL,TMaxRR varchar(5) NOT NULL,TotRainFall decimal(6,2) NOT NULL,AvgTemp decimal(4,2) NOT NULL,TotWindRun decimal(5,1) NOT NULL," . "HighAvgWSpeed decimal(3,1),THAvgWSpeed varchar(5),LowHum varchar(3),TLowHum varchar(5),HighHum varchar(3),THighHum varchar(5),TotalEvap decimal(5,2),HoursSun decimal(2,1),HighHeatInd decimal(4,1),THighHeatInd varchar(5),HighAppTemp decimal(4,1),THighAppTemp varchar(5),LowAppTemp decimal(4,1)," . "TLowAppTemp varchar(5),HighHourRain decimal(4,1),THighHourRain varchar(5),LowWindChill decimal(4,1),TLowWindChill varchar(5),HighDewPoint decimal(4,1),THighDewPoint varchar(5),LowDewPoint decimal(4,1),TLowDewPoint varchar(5),DomWindDir varchar(3),HeatDegDays decimal(4,1),CoolDegDays decimal(4,1)," . "HighSolarRad varchar(5),THighSolarRad varchar(5),HighUV varchar(2),THighUV varchar(5),HWindGBearSym varchar(3),DomWindDirSym varchar(3),PRIMARY KEY(LogDate) ) COMMENT = \"Dayfile from Cumulus\""; */ $result = mysql_query("SET time_zone='+1:00';"); if (!$result) { printf ("ERROR - TZ Statement"); exit; } $query = "SELECT MAX(MaxTemp), MIN(MinTemp), AVG(AvgTemp), MAX(HighHum), MIN(LowHum), SUM(TotRainFall), MAX(HighWindGust), SUM(TotWindRun), MIN(MinPress), MAX(MaxPress), SUM(CoolDegDays), SUM(HeatDegDays), AVG(DomWindDir), MAX(MaxRainRate), MAX(HighSolarRad) FROM Dayfile WHERE DATE_FORMAT(LogDate, '%Y') = ".$year." and DATE_FORMAT(LogDate, '%m') = ".$month.""; $result = mysql_query($query); if (!$result) { printf ("ERROR - Bad Select Statement"); exit; } while($row = mysql_fetch_row($result)) { $TMaxM = (float)$row[0]; $TMinM = (float)$row[1]; $TAvgM = number_format((float)$row[2],1); $HMaxM = (float)$row[3]; $HMinM = (float)$row[4]; $PTotM = (float)$row[5]; $VMaxM = (float)$row[6]; $VTotM = (float)$row[7]; $PMaxM = (float)$row[8]; $PMinM = (float)$row[9]; $CDjuM = (float)$row[10]; $HDjuM = (float)$row[11]; $VDirM = (float)$row[12]; $PDebM = (float)$row[13]; $SRadM = (float)$row[14]; } $query = "SELECT DATE_FORMAT(LogDate, '%d') AS LogDate, MaxTemp, MinTemp, AvgTemp, HighHum, LowHum, TotRainFall, HighWindGust, TotWindRun, MinPress, MaxPress, CoolDegDays, HeatDegDays, DomWindDir, MaxRainRate, HighSolarRad FROM Dayfile WHERE DATE_FORMAT(LogDate, '%Y') = ".$year." and DATE_FORMAT(LogDate, '%m') = ".$month." ORDER BY LogDate ASC"; $result = mysql_query($query); if (!$result) { printf ("ERROR - Bad Select Statement"); exit; } // import the rows and put the data into arrays while($row = mysql_fetch_row($result)) { $title[] = $row[0]; $TMax[] = (float)$row[1]; $TMin[] = (float)$row[2]; $TAvg[] = (float)$row[3]; $HMax[] = (float)$row[4]; $HMin[] = (float)$row[5]; $PTot[] = (float)$row[6]; $VMax[] = (float)$row[7]; $VTot[] = (float)$row[8]; $PMax[] = (float)$row[9]; $PMin[] = (float)$row[10]; $CDju[] = (float)$row[11]; $HDju[] = (float)$row[12]; $VDir[] = (float)$row[13]; $PDeb[] = (float)$row[14]; $SRad[] = (float)$row[15]; } $query = " SELECT DATE_FORMAT(LogDate, '%d') AS LogDate, HighHourRain FROM Dayfile WHERE DATE_FORMAT(LogDate, '%Y') = ".$year." and DATE_FORMAT(LogDate, '%m') = ".$month." and HighHourRain = (SELECT MAX(HighHourRain) FROM Dayfile WHERE DATE_FORMAT(LogDate, '%Y') = ".$year." and DATE_FORMAT(LogDate, '%m') = ".$month.")"; //print_r($query); $result = mysql_query($query); if (!$result) { printf ("ERROR - Bad Select Statement"); exit; } while($row = mysql_fetch_row($result)) { $HRainM[0] = $row[1]; $HRainM[1] = $row[0]; } // put into a single array // Have to add an offset of 10 minutes to the start-date for some reason?! $rows =array('jour' => $title, 'tmin' => $TMin, 'tmax' => $TMax, 'tavg' => $TAvg, 'cdd' => $CDju, 'hdd' => $HDju, 'hmin' => $HMin, 'hmax' => $HMax, 'pluie' => $PTot, 'averse' => $PDeb, 'ventr' => $VMax, 'ventt' => $VTot, 'vdir' => $VDir, 'pmin' => $PMin, 'pmax' => $PMax, 'srad' => $SRad, 'tminM' => $TMinM, 'tmaxM' =>$TMaxM, 'tavgM' =>$TAvgM, 'cddM' => $CDjuM, 'hddM' => $HDjuM, 'hmaxM' =>$HMaxM, 'hminM' =>$HMinM, 'pluieM' =>$PTotM, 'averseM' => $PDebM, 'ventrM' => $VMaxM, 'venttM' => $VTotM, 'vdirM' => $VDirM, 'pminM' => $PMinM, 'pmaxM' => $PMaxM, 'sradM' => $SRadM, 'pluie1HM' => $HRainM); header("Content-type: text/json"); echo json_encode($rows); //print_r($rows); ?>