current.php

<?php
include 'database.php';
header('content-type: application/json; charset=utf-8');
header("access-control-allow-origin: *");

$con = new mysqli(DbSettings::$Address,DbSettings::$Username,DbSettings::$Password,DbSettings::$Schema);

// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$result = $con->query('call GETRECENTOBS');
$fieldcount = mysqli_num_fields($result);

echo "{ "; // Open document object
echo "\r\n\t\"WeatherObservations\" : {"; // Open weather observations object

if ($result->num_rows > 0) {
    $fields = array();
    while ($fieldinfo = mysqli_fetch_field($result)) {
        array_push($fields, $fieldinfo->name);
    }

    $numberOfRows = 0;
    while($row = mysqli_fetch_array($result)) { // Rows
	   $numberOfRows++;

        if ($numberOfRows > 1) {
            echo ", ";
        }

        echo "\r\n\t\t\"Observation" . $numberOfRows . "\" : {";
        
        if ($numberOfRows == 1) {
            $feelsLike = calculateFeelsLike($row["AMBIENT_TEMPERATURE"], $row["HUMIDITY"], $row["WIND_SPEED"]);
            if (!Settings::$showMetricAndCelsiusMeasurements == "1") {
                $feelsLike = convertCelsiusToFahrenheit($feelsLike);
            }
            echo "\r\n\t\t\t\"FEELS_LIKE\" : " . "\"" . $feelsLike . "\",";
        }
        
        for ($i = 0; $i < $fieldcount; $i++) {   // Columns
            $fieldName = $fields[$i];
            $fieldValue = $row[$i];
            
            if (strpos($fieldName, "_TEMPERATURE")) {
                if (Settings::$showMetricAndCelsiusMeasurements == "1") {
                    echo "\r\n\t\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $fieldValue . "° C\",";
                }
                else {
                    $fieldValue = convertCelsiusToFahrenheit($fieldValue);
                    echo "\r\n\t\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $fieldValue . "° F\",";
                }
            }
            
            if ($fieldName == "DEWPOINT") {
                if (Settings::$showMetricAndCelsiusMeasurements == "1") {
                    echo "\r\n\t\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $fieldValue . "° C\",";
                }
                else {
                    $fieldValue = convertCelsiusToFahrenheit($fieldValue);
                    echo "\r\n\t\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $fieldValue . "° F\",";
                }
            }

            if ($fieldName == "RAINFALL") {
                if (Settings::$showMetricAndCelsiusMeasurements == "1") {
                    echo "\r\n\t\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $fieldValue . " mm\",";
                }
                else {
                    $fieldValue = convertMillibarsToInches($fieldValue);
                    echo "\r\n\t\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $fieldValue . " in\",";
                }
            }

            if ($fieldName == "HUMIDITY") {
                echo "\r\n\t\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $fieldValue . " %\",";
            }

            if (strpos($fieldName, "_SPEED")) {
                if (Settings::$showMetricAndCelsiusMeasurements == "1") {
                    echo "\r\n\t\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $fieldValue . " Km/H\",";
                }
                else {
                    $fieldValue = convertKilometersToMiles($fieldValue);
                    echo "\r\n\t\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $fieldValue . " MPH\",";
                }
            }

            if (strpos($fieldName, "_PRESSURE")) {
                
                $mslp = calculateMeanSeaLevelPressure($fieldValue, Settings::$stationElevationInMeters);
                
                if (Settings::$showPressureInMillibars == "1") {
                    echo "\r\n\t\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $mslp . " mb\",";
                }
                else {
                    $fieldValue = convertMillibarsToInches($mslp);
                    echo "\r\n\t\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $fieldValue . " in\",";
                }
            }

            echo "\r\n\t\t\t\"" . $fieldName . "\" : " . "\"" . $fieldValue . "\"";

            if ($i+1 < $fieldcount) {
                    echo ",";
            }
        }
        
        echo "\r\n\t\t}";
    }
    
    $result->close();
    $con->next_result();
}
echo "\r\n\t}"; // Close weather observations object

$result = $con->query('call GETDAILYRECORDS');
$fieldcount = mysqli_num_fields($result);
echo ",\r\n\t\"DailyStats\" : {"; // Open daily stats object

if ($result->num_rows > 0) {
    $fields = array();
    while ($fieldinfo = mysqli_fetch_field($result)) {
        array_push($fields, $fieldinfo->name);
    }

    $row = mysqli_fetch_array($result); // Only one row of data
    for ($i = 0; $i < $fieldcount; $i++) {   // Columns
        $fieldInfo = mysqli_fetch_field($result);
        $fieldName = $fields[$i];
        $fieldValue = $row[$i];

        if (($fieldName == "LowSinceMidnight") || ($fieldName == "HighSinceMidnight")) {
            if (Settings::$showMetricAndCelsiusMeasurements == "1") {
                echo "\r\n\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $fieldValue . "° C\",";
            }
            else {
                $fieldValue = convertCelsiusToFahrenheit($fieldValue);
                echo "\r\n\t\t\"" . $fieldName . "_STRING\" : " . "\"" . $fieldValue . "° F\",";
            }
        }
        
        echo "\r\n\t\t\"" . $fieldName . "\" : " . "\"" . $fieldValue . "\"";

        if ($i+1 < $fieldcount) {
            echo ",";
        }
    }
}
echo "\r\n\t}"; // Close daily stats object

echo ",\r\n\t\"Settings\" : {"; // Open settings object
echo "\r\n\t\t\"showMetricAndCelsiusMeasurements\" : " . "\"" . Settings::$showMetricAndCelsiusMeasurements . "\",";
echo "\r\n\t\t\"showPressureInMillibars\" : " . "\"" . Settings::$showPressureInMillibars . "\"";

echo "\r\n\t}"; // Close settings object

echo "\r\n}"; // Close document object

$result->close();
mysqli_close($con);

?>