I am working on building a JSON for a morris graph and I am having a couple of problems.
this is the format I need to get:
JavaScript
x
[
{ y: '15:44', a: 123123},
{ y: '15:29', a: 4859},
{ y: '15:14', a: 3830 },
{ y: '14:58', a: 2815 },
{ y: '14:43', a: 1810},
{ y: '14:28', a: 801 },
]
I get these two values looping threw a single array and in every cycle, I can reed both of them.
I am adding this to tell anyone who can find this helpful that the best solution I could find is this:
JavaScript
while($row = mysqli_fetch_array($result))
{
$chart_data .= "{ dt:'".$row["dt"]."', totali:".$row["totali"]."}, ";
}
$chart_data = substr($chart_data, 0, -2);
this $chart_data than can be used as a feeding variable for the chart right away
Advertisement
Answer
JavaScript
$arr = []
$obj = new stdClass();
$obj->y = '15:44';
$obj->a = 123123;
$arr[] = $obj;
$encoded_obj = json_encode($arr);
Just loop through your items and create an empty object. After creating the empty object assign the values to an array and with json_encode make the array a json string