Php/ajax return JSON in same form as javascript array

Question

I am using charts.js plugin to create charts. It is using a javascript array data to generate chart.

var data = {
    labels: ["January", "February", "March", "April", "May", "June", "July"],
    datasets: [
        {
            label: "My First dataset",
            fillColor: "rgba(220,220,220,0.2)",
            strokeColor: "rgba(220,220,220,1)",
            pointColor: "rgba(220,220,220,1)",
            pointStrokeColor: "#fff",
            pointHighlightFill: "#fff",
            pointHighlightStroke: "rgba(220,220,220,1)",
            data: [65, 59, 80, 81, 56, 55, 40]
        },
        {
            label: "My Second dataset",
            fillColor: "rgba(151,187,205,0.2)",
            strokeColor: "rgba(151,187,205,1)",
            pointColor: "rgba(151,187,205,1)",
            pointStrokeColor: "#fff",
            pointHighlightFill: "#fff",
            pointHighlightStroke: "rgba(151,187,205,1)",
            data: [28, 48, 40, 19, 86, 27, 90]
        }
    ]
};

I want to use ajax to return results for different range of time. How can i generate a response with php so that when i read it in ajax success i can use it the same way i am using var datato generate initial chart.

        $.ajax('/chart.php', {
            type: 'POST',
            data: {range: range},
            dataType: 'json',
            success: function(data) {
                console.log(data);
            }
        });

How does the data in your success() function differ from the structure you've shown above? — Alex McMillan
– Alex McMillan, Commented May 28, 2015 at 10:26
It would just have different values in first array "labels" and sub arrays "data" will have the same number of values as "labels" first array. — user4675957
– user4675957, Commented May 28, 2015 at 10:30

Styphon · Accepted Answer · 2015-05-28 11:43:23Z

1

What you want is to create an array of objects, then use json_encode and it should produce what you need. Try this:

$array = array();
$dataset = new stdClass;
$dataset->label = "My first dataset";
// repeat for each field
$array[] = $dataset;
echo json_encode($array);

What we can do to shorten this is rather than declare a new dataset each time we can use an array and typecast it to an object like this:

$datasets = array();
$datasets[] = (object) array(
    'label' => "My First dataset",
    'fillColor' => "rgba(220,220,220,0.2)",
    'strokeColor' => "rgba(220,220,220,1)",
    'pointColor' => "rgba(220,220,220,1)",
    'pointStrokeColor' => "#fff",
    'pointHighlightFill' => "#fff",
    'pointHighlightStroke' => "rgba(220,220,220,1)",
    'data' => [65, 59, 80, 81, 56, 55, 40]
);

Check out this eval.in for a working example.

Update

For your complete structure you need:

$data = (object) [
    'labels' => ["January", "February", "March", "April", "May", "June", "July"],
    datasets => []
];

$data->datasets[] = (object) [
    'label' => "My First dataset",
    'fillColor' => "rgba(220,220,220,0.2)",
    'strokeColor' => "rgba(220,220,220,1)",
    'pointColor' => "rgba(220,220,220,1)",
    'pointStrokeColor' => "#fff",
    'pointHighlightFill' => "#fff",
    'pointHighlightStroke' => "rgba(220,220,220,1)",
    'data' => [65, 59, 80, 81, 56, 55, 40]
];

echo json_encode($data);

edited May 28, 2015 at 11:43

answered May 28, 2015 at 10:27

Styphon

10.5k9 gold badges54 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user4675957 Over a year ago

Thank you for reply. What do i do with labels: ["January", "February", "March", "April", "May", "June", "July"], and how to put both "labels" array and multiple "datasets" in one array?

Collectives™ on Stack Overflow

Php/ajax return JSON in same form as javascript array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related