Untitled

<?php

    $username="root";
    $password="";
    $database="templog";
    $host="localhost";

    $server = mysqli_connect($host, $username, $password);
    $connection = mysqli_select_db($server, $database);

    $myquery = "SELECT `date`, `Temperature` FROM `temp-at-interrupt`";
    $query = mysqli_query($server, $myquery);

    if ( ! $query ) {
        echo mysqli_connect_error($connection);
        die;
    }

    $data = array();

    for ($x = 0; $x < mysqli_num_rows($query); $x++) {
        $data[] = mysqli_fetch_assoc($query);
    }

    echo json_encode($data);

    mysqli_close($server);
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Chart</title>
    <style>
        #container {
            min-width: 300px;
            max-width: 800px;
            height: 300px;
            margin: 1em auto;
        }
    </style>
</head>
<body>
<div id="container"></div>
<script src="https://code.highcharts.com/highcharts.js"></script>
<script>
    var categories = [];
    var seriesData = [];
    var data = [
        {
            "date": "2017-02-11",
            "Temperature": "14.81"
        }, {
            "date": "2017-02-12",
            "Temperature": "25.75"
        }, {
            "date": "2017-02-13",
            "Temperature": "36.75"
        }
    ];

    for (var index = 0; index < data.length; index++) {
        categories.push(data[index].date);
        seriesData.push(parseFloat(data[index].Temperature));
    }

    Highcharts.chart('container', {

        xAxis: {
            categories: categories
        },

        series: [{
            data: seriesData,
            type: 'column'
        }]

    });

</script>
</body>
</html>