data_maandgrafiek.php

<?php
$con = mysql_connect("localhost","p1logger","p1logger");

if (!$con) {
  die('Could not connect: ' . mysql_error());
}

mysql_select_db("p1", $con);

$query = mysql_query("SELECT DATE(time) as day, e_hoog, e_laag, e_totaal, verbruik_g FROM dagtotalen WHERE time BETWEEN CURDATE() - INTERVAL 2 WEEK AND CURDATE() ORDER BY day ASC");

$category = array();
$category['name'] = 'day';

$series1 = array();
$series1['name'] = 'Elektra hoog tarief';

$series2 = array();
$series2['name'] = 'Elektra laag tarief';

$series3 = array();
$series3['name'] = 'Elektra TOTAAL';

$series4 = array();
$series4['name'] = 'Gas';

while($r = mysql_fetch_array($query)) {
    $category['data'][] = $r['day'];
    $series1['data'][] = $r['e_hoog'];
    $series2['data'][] = $r['e_laag'];
    $series3['data'][] = $r['e_totaal'];
    $series4['data'][] = $r['verbruik_g'];
}

$result = array();
array_push($result,$category);
array_push($result,$series1);
array_push($result,$series2);
array_push($result,$series3);
array_push($result,$series4);

print json_encode($result, JSON_NUMERIC_CHECK);

mysql_close($con);
?>