从json编码的字符串转换为[value，value]，[value，value]

Question

I'm trying to chart data from my SQL database using flot, this is gathered using php then json encoded.

Currently looks like:

 [{"month":"February","data":482},{"month":"March","data":0}] 

however for flot to operate the data needs to be in the form of

[X AXIS VALUE, Y AXIS VALUE],[X AXIS VALUE, Y AXIS VALUE],[X AXIS VALUE, Y AXIS VALUE]

ETC..

How might i convert that?

Answer 1

The basic process is to convert the data to an array (or object, if you prefer) and then pull out each plot point's data and shove it into an array. Then, turn that array back into a string. Here's an example:

// SAMPLE DATA
$json_string = '[{"month":"February","data":482},{"month":"March","data":0}]';

// DEFAULT
$all_points_array = array();

// JSON DECODE THE STRING AND TURN IT INTO AN ARRAY
$json_array = json_decode($json_string, true);

// LOOP THROUGH THE PLOT POINTS AND ADD EACH SET TO AN ARRAY
foreach ($json_array AS $plot_points) {
    $all_points_array[] = '['.$plot_points['month'].','.$plot_points['data'].']';
}

// CONVERT THE ARRAY TO A STRING, SEPARATED BY COMMAS
$all_points = implode(',', $all_points_array);

// PRINT OUT YOUR STRING
echo $all_points;