Google chart dont display nothing yet I have data in my php file using json

King Musa

unread,

Sep 2, 2013, 4:43:20 PM9/2/13

to google-visua...@googlegroups.com

This is my php page called getData.php
<?php
$arr = array('Watts' => 1, 'Dollars'=>67, 'Money' => 76);
   $json_table = json_encode($arr);
//echo $json_table;
?>

here is my index page containing gooogle chart
<html>
<head>
    
    <script src="http://code.jquery.com/jquery-latest.js"></script>
    <script type="text/javascript" src="https://www.google.com/jsapi"></script>
    <script type="text/javascript" src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
    <script type="text/javascript">

    // Load the Visualization API and the piechart package.
    google.load('visualization', '1', {'packages':['corechart']});

    // Set a callback to run when the Google Visualization API is loaded.
    google.setOnLoadCallback(drawChart);

    function drawChart() {
      var jsonData = $.ajax({
          url: "getData.php",
          dataType:"json",
          async: false
          }).responseText;

      // Create our data table out of JSON data loaded from server.
      var data = new google.visualization.DataTable(jsonData);

      // Instantiate and draw our chart, passing in some options.
      var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
      chart.draw(data, {width: 400, height: 240});
    }

    </script>
</head>

<body>
    
    <div id="chart_div"></div>
</body>
</html>

asgallant

unread,

Sep 2, 2013, 9:56:54 PM9/2/13

to google-visua...@googlegroups.com

The JSON you are creating in your PHP is not the correct structure for the Visualization API. Try this instead:

$arr = array(
    'cols' => array(
        array('type' => 'number', 'label' => 'Watts'),
        array('type' => 'number', 'label' => 'Dollars'),
        array('type' => 'number', 'label' => 'Money')
    ),
    'rows' => array(
        array('c' => array(array('v' => 1), array('v' => 67), array('v' => 76)))
    )
);

King Musa

unread,

Sep 3, 2013, 12:28:16 AM9/3/13

to google-visua...@googlegroups.com

thanks a lot for your help am gonna try it

--
You received this message because you are subscribed to a topic in the Google Groups "Google Visualization API" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/google-visualization-api/mcYS1Znwqik/unsubscribe.
To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.

King Musa

unread,

Sep 3, 2013, 4:00:11 AM9/3/13

to google-visua...@googlegroups.com

I did it exactly but still It displays nothing I mean it shows a blank page

This is the index.php

this is the getData.php
<?php

$arr = array(

    'cols' => array(
        array('type' => 'number', 'label' => 'Watts'),
        array('type' => 'number', 'label' => 'Dollars'),
        array('type' => 'number', 'label' => 'Money')
    ),
    'rows' => array(
        array('c' => array(array('v' => 1), array('v' => 67), array('v' => 76)))
    )
);

json_encode($arr);

?>

asgallant

unread,

Sep 3, 2013, 9:06:16 AM9/3/13

to google-visua...@googlegroups.com

Open the page in a browser, view the source, and post the javascript.

To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsub...@googlegroups.com.

King Musa

unread,

Sep 3, 2013, 9:31:17 AM9/3/13

to google-visua...@googlegroups.com

Now am confused I think I sent you all the codes php and javascrip which was Json

To unsubscribe from this group and all its topics, send an email to google-visualizati...@googlegroups.com.

asgallant

unread,

Sep 3, 2013, 9:34:21 AM9/3/13

to google-visua...@googlegroups.com

I want to see what the PHP is producing when when it is processed by the server.

To unsubscribe from this group and all its topics, send an email to google-visualization-api+unsubscr...@googlegroups.com.

To post to this group, send email to google-visua...@googlegroups.com.

Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.

Reply all

Reply to author

Forward