Jag vill ha data i följande format:
Dvs med hakparanteser. Men hur jag än bär mig åt så blir det dubbelfnuttar inblandade:[{"name":"Golvv\u00e4rme","data":[[1380578400000,3.9],[1380664800000,4.5]]},{"name":"V\u00e4rmepump","data":[[1380578400000,3.3],[1380664800000,4.4]]}]
Här är ett exempel på hur jag hämtar data och bygger ihop arrayer:[{"name":"Golvv\u00e4rme","data":["1380578400000,3.9","1380664800000,4.5"]},{"name":"V\u00e4rmepump","data":["1380578400000,3.3","1380664800000,4.4"]}]
Kod: Markera allt
<?php
$con = mysql_connect("localhost","user","pwd");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("db", $con);
$sql = mysql_query("select UNIX_TIMESTAMP(concat(datum, ' 00:00:00'))*1000 datum, llvp, gv from elforbrukning_dygn where datum between '".$_GET["dateStart"]."' and '".$_GET["dateEnd"]."'");
$series1 = array();
$series1['name'] = 'Golvvärme';
$series2 = array();
$series2['name'] = 'Värmepump';
while($r = mysql_fetch_array($sql)) {
$series1['data'][] = $r['datum'].",".$r['gv'];
$series2['data'][] = $r['datum'].",".$r['llvp'];
}
$result = array();
array_push($result,$series1);
array_push($result,$series2);
print json_encode($result, JSON_NUMERIC_CHECK);
mysql_close($con);
?>
Kod: Markera allt
<?php
$con = mysql_connect("localhost","user","pwd");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("db", $con);
$sql = mysql_query("select concat('[', UNIX_TIMESTAMP(concat(datum, ' 00:00:00'))*1000, ',', llvp, ']') llvp, concat('[', UNIX_TIMESTAMP(concat(datum, ' 00:00:00'))*1000, ',', gv, ']') gv from elforbrukning_dygn where datum between '".$_GET["dateStart"]."' and '".$_GET["dateEnd"]."'");
$series1 = array();
$series1['name'] = 'Golvvärme';
$series2 = array();
$series2['name'] = 'Värmepump';
while($r = mysql_fetch_array($sql)) {
$series1['data'][] = $r['gv'];
$series2['data'][] = $r['llvp'];
}
$result = array();
array_push($result,$series1);
array_push($result,$series2);
print json_encode($result, JSON_NUMERIC_CHECK);
mysql_close($con);
?>
Har ni några sköna tips?[{"name":"Golvv\u00e4rme","data":["[1380578400000,3.9]","[1380664800000,4.5]"]},{"name":"V\u00e4rmepump","data":["[1380578400000,3.3]","[1380664800000,4.4]"]}]