php - Google chart showing blank using JSON -

-

i've been trying google charts working data on local db. think have got json coming out now.

{     "cols": [         {             "id": "",             "label": "inits",             "pattern": "",             "type": "string"         },         {             "id": "",             "label": "salesval",             "pattern": "",             "type": "number"         }     ],     "rows": [         {             "c": [                 {                     "v": "is",                     "f": null                 },                 {                     "v": "1708.6000",                     "f": null                 }             ]         },         {             "c": [                 {                     "v": "ns",                     "f": null                 },                 {                     "v": "1098.8200",                     "f": null                 }             ]         },         {             "c": [                 {                     "v": "rc",                     "f": null                 },                 {                     "v": "458.8200",                     "f": null                 }             ]         }     ] }

and i'm using html.

<html>   <head>     <!--load ajax api-->     <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 visualization api , piechart package.     google.load('visualization', '1', {'packages':['corechart']});      // set callback run when google visualization api 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 server.       var data = new google.visualization.datatable(jsondata);        // instantiate , draw our chart, passing in options.       var chart = new google.visualization.piechart(document.getelementbyid('chart_div'));       chart.draw(data, {width: 400, height: 240});     }      </script>   </head>    <body>     <!--div hold pie chart-->     <div id="chart_div"></div>   </body> </html>

i've gone on few times , can't see going wrong.

it occurs since salesval column of number type cells contain string values.

according format of constructor's javascript literal data parameter:

type [required] data type of data in column. supports following string values (examples include v: property, described later):

  • 'number' - javascript number value. example values: v:7 , v:3.14, v:-55

having said consider following options:

option 1. modify getdata.php endpoint return valid json data google.visualization.datatable:

"v": "1708.6000" //invalid (current)  "v": 1708.6000   //valid

option 2

ensure data column of number type contain javascript number value demonstrated below:

example

var jsondata = {      "cols": [          {              "id": "",              "label": "inits",              "pattern": "",              "type": "string"          },          {              "id": "",              "label": "salesval",              "pattern": "",              "type": "number"          }      ],      "rows": [          {              "c": [                  {                      "v": "is",                      "f": null                  },                  {                      "v": "1708.6000",                      "f": null                  }              ]          },          {              "c": [                  {                      "v": "ns",                      "f": null                  },                  {                      "v": "1098.8200",                      "f": null                  }              ]          },          {              "c": [                  {                      "v": "rc",                      "f": null                  },                  {                      "v": "458.8200",                      "f": null                  }              ]          }      ]  };      google.load('visualization', '1', { 'packages': ['corechart'] });  google.setonloadcallback(drawchart);    function drawchart() {      var data = new google.visualization.datatable(preparejsondata(jsondata));      var chart = new google.visualization.piechart(document.getelementbyid('chart_div'));      chart.draw(data, { width: 400, height: 240 });  }    function preparejsondata(json) {      json.rows.foreach(function(row) {          row.c[1].v = parsefloat(row.c[1].v);  //ensure number cell value       });      return json;  }
<script type="text/javascript" src="https://www.google.com/jsapi"></script>  <div id="chart_div"></div>


Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more