<?php

date_default_timezone_set('Europe/Warsaw');

function wykres($db, $table, $description, $rgbcolor)
{
        echo "<canvas id=\"".$table."\"></canvas>";

        $labels = "";
        $data = "";
        $query = mysqli_query($db, "SELECT * FROM ( SELECT id, data, value FROM `".$table."` ORDER BY id DESC LIMIT 60 ) sub ORDER BY id ASC");
        while ($row = mysqli_fetch_array($query)) {
        $labels .= "\"".date('G:i d-m', $row{'data'})."\",";
        $data .= "".$row{'value'}.",";
        }


        echo "<script>
var ctx = document.getElementById('".$table."').getContext('2d');
var chart = new Chart(ctx, {
    // The type of chart we want to create
    type: 'line',

    // The data for our dataset
    data: {
        labels: [".$labels."],
        datasets: [{
            label: \"".$description."\",
            backgroundColor: 'rgb(".$rgbcolor.")',
            borderColor: 'rgb(".$rgbcolor.")',
            data: [".$data."],
            fill: false,
        }]
    },

    // Configuration options go here
    options: {}
});
</script>";
}
?>