variables between PHP and the API

[maxweb59]

Hello ! I would like to use the google charts API for my website, but
i've one enormous problem: my data (these who i need to make a chart)
are found in my DataBase (MySQL) by PHP, and are in PHP vars, but the
API want the vars directly in the javascript function. How can I put
my PHP vars into the javascript function of the API ?
Thanks for your help.

(and sorry for my english, i'm french :) )

[Jérôme]

you need to transform your SQL data into a json file, with a structure recognized by google API.

You have an example there :

https://developers.google.com/chart/interactive/docs/php_example 

[asgallant]

I posted a code snippet I use for transforming database output from PHP into JSON that the charts can understand: https://groups.google.com/d/msg/google-visualization-api/Gy18YdVSSfQ/tKdtzSfqKlcJ

You can either echo that output into the constructor of the DataTable - ie:

var data = new google.visualization.DataTable(<?php echo $json_encoded_data; ?>); 

or you can use that code as a data source and make AJAX calls to it, putting the returned json into the DataTable constructor, ie:

​google.load('visualization', '1.0', {'packages': ['corechart']});
google.setOnLoadCallback(init);

function init () {
    // get parameters to submit to data source
    var params;
    
    // get data w/ AJAX call
    $.ajax({
        url: '/path/to/data_query.php',
        data: params,
        type: json,
        success: function (json) {
            var data = new google.visualization.DataTable(json);
            var chart = new google.visualization.ChartType(document.getElementById('chart_div'));
            chart.draw(data, {/*options*/});
        }
    });
}