You changed your date format, what you had before was correct for using the
JSON data table representation. Other than that, your data seems to be in
the correct format (see example with a truncated set of your data and fixed
dates here: http://jsfiddle.net/asgallant/2nFWK/). Fix the dates and test
again. If it still doesn't work, then post your js code and I'll take a
look at that.
On Wednesday, November 14, 2012 4:22:18 AM UTC-5, sam wrote:
>
> attached json output I get, can you check it? I am pretty sure it's
> correct though.
> thanks
>
> On Tuesday, November 13, 2012 4:06:53 AM UTC-5, asgallant wrote:
>>
>> To debug the json, add colsole.log(json); in the AJAX query, and then
>> check the developer's console in Chrome/Firefox to see what comes out.
>> Make sure that you are using the json to create a new DataTable and not
>> with the addRows method; it should be var data = new
>> google.visualization.DataTable(json); in the success callback.
>>
>> On Monday, November 12, 2012 10:16:20 PM UTC-5, sam wrote:
>>>
>>> I did update my .php file according to code you provided, and get jason
>>> in proper format,
>>>
>>> commented out addColumn in .html still no luck
>>>
>>> On Monday, November 12, 2012 8:34:35 PM UTC-5, asgallant wrote:
>>>>
>>>> Sorry, that's a typo, should have been $r.
>>>>
>>>> On Monday, November 12, 2012 8:22:17 PM UTC-5, sam wrote:
>>>>>
>>>>> in this particular cod snippet, where did $i come from?
>>>>>
>>>>> $sth = mysql_query("SELECT * FROM testpower WHERE datetime > 0");
>>>>> $rows = array();
>>>>> $flag = true;
>>>>>
>>>>> $table = array();
>>>>>
>>>>> $table['cols'] = array(
>>>>>
>>>>> array('label' => 'date', 'type' => 'datetime'),
>>>>>
>>>>> array('label' => 'power', 'type' => 'number')
>>>>>
>>>>> );
>>>>>
>>>>> $rows = array();
>>>>> while($r = mysql_fetch_assoc($sth)) {
>>>>> $temp = array();
>>>>>
>>>>> $temp[] = array('v' => $i['datetime']); // you will probably need to
>>>>> transform this into the Date object format
>>>>> $temp[] = array('v' => (float) $i['power']); // typecast to int,
>>>>> float, whatever - if you don't, it will be interpreted as a string
>>>>>
>>>>> $rows[] = array('c' => $temp);
>>>>> }
>>>>>
>>>>> $table['rows'] = $rows;
>>>>>
>>>>> $jsonTable = json_encode($table);
>>>>>
>>>>>
>>>>> On Monday, November 12, 2012 7:41:01 PM UTC-5, asgallant wrote:
>>>>>>
>>>>>> Yes, that's the format you need. Here's a basic bit of PHP code that
>>>>>> shows how to build it:
>>>>>> https://groups.google.com/d/msg/google-visualization-api/GK0zwNbIwUo/i9DhpOUSKMEJ
>>>>>>
>>>>>> On Monday, November 12, 2012 7:32:06 PM UTC-5, sam wrote:
>>>>>>>
>>>>>>> are you talking about sampleData.json format?
>>>>>>>
>>>>>>> same as in this example ?
>>>>>>> https://developers.google.com/chart/interactive/docs/php_example
>>>>>>>
>>>>>>> On Monday, November 12, 2012 6:46:31 PM UTC-5, asgallant wrote:
>>>>>>>>
>>>>>>>> Hmmm...I don't see anything wrong with the code, can you post a
>>>>>>>> link to the live version on your school's server?
>>>>>>>>
>>>>>>>> Incidentally, the data in the JSON won't work. Your numbers have
>>>>>>>> to be unquoted, and the dates won't work as is. That date format is
>>>>>>>> correct if you are using the JSON implementation of a DataTable, but
>>>>>>>> not
>>>>>>>> for using the addRows method. Given how you are fetching the data,
>>>>>>>> you'll
>>>>>>>> either have to process it in javascript before passing it to addRows,
>>>>>>>> or
>>>>>>>> change the data structure to use the full DataTable JSON structure.
>>>>>>>>
>>>>>>>> On Monday, November 12, 2012 6:01:37 PM UTC-5, sam wrote:
>>>>>>>>>
>>>>>>>>> thanks for reply asgallant, I built everything by reading all your
>>>>>>>>> previous comments history, I was testing everything locally on my
>>>>>>>>> laptop
>>>>>>>>> using xampp got the 405 error, moved everything to my school provided
>>>>>>>>> space
>>>>>>>>> on .edu, same error.
>>>>>>>>> all your previous comments on other threads are really helpful.
>>>>>>>>>
>>>>>>>>> my .php file output sample, it's really big file, just showed a
>>>>>>>>> few lines, from echo json_encode($output);
>>>>>>>>>
>>>>>>>>> [["Date(2012,04,12,12,50,02)","15662","5589","7999","2074","1488","425"],["Date(2012,04,12,1,00,03)","15662","5589","7999","2074","1488","425"],["Date(2012,04,12,1,10,02)","15242","5555","7603","2084","1430","413"]]
>>>>>>>>>
>>>>>>>>> .html file :
>>>>>>>>>
>>>>>>>>> <html>
>>>>>>>>> <head>
>>>>>>>>> <script type='text/javascript' src='
>>>>>>>>> http://www.google.com/jsapi'></script>
>>>>>>>>> <script type="text/javascript" src="jquery.min.js"></script>
>>>>>>>>> <script type='text/javascript'>
>>>>>>>>> google.load('visualization', '1',
>>>>>>>>> {'packages':['annotatedtimeline']});
>>>>>>>>> google.setOnLoadCallback(drawChart);
>>>>>>>>>
>>>>>>>>> function drawChart() {
>>>>>>>>> var data = new google.visualization.DataTable();
>>>>>>>>> data.addColumn('datetime', 'Date');
>>>>>>>>> data.addColumn('number', 'n1');
>>>>>>>>> data.addColumn('number', 'n2');
>>>>>>>>> data.addColumn('number', 'n3');
>>>>>>>>> data.addColumn('number', 'n4');
>>>>>>>>> data.addColumn('number', 'n5');
>>>>>>>>> data.addColumn('number', 'n6');
>>>>>>>>> var now = new Date();
>>>>>>>>>
>>>>>>>>> var chart = new
>>>>>>>>> google.visualization.AnnotatedTimeLine(document.getElementById('chart_div'));
>>>>>>>>> function updateData () {
>>>>>>>>> $.ajax({
>>>>>>>>> url: 'http://localhost/db_chartjson.php',
>>>>>>>>> dataType: 'json',
>>>>>>>>> type: 'POST',
>>>>>>>>> crossDomain: true,
>>>>>>>>> success: function (json) {
>>>>>>>>> data.removeRows(0, data.getNumberOfRows());
>>>>>>>>> data.addRows(json);
>>>>>>>>> chart.draw(data,{width: 400, height: 240});
>>>>>>>>> // refresh data in 1 minute
>>>>>>>>> setTimeout(function () {
>>>>>>>>> updateData();
>>>>>>>>> }, 60000);
>>>>>>>>> }
>>>>>>>>> });
>>>>>>>>> }
>>>>>>>>> }
>>>>>>>>>
>>>>>>>>> </script>
>>>>>>>>> </head>
>>>>>>>>> <body>
>>>>>>>>> <div id='chart_div' ></div>
>>>>>>>>> </body>
>>>>>>>>> </html>
>>>>>>>>>
>>>>>>>>> On Monday, November 12, 2012 5:50:49 PM UTC-5, asgallant wrote:
>>>>>>>>>>
>>>>>>>>>> Can you post your source code?
>>>>>>>>>>
>>>>>>>>>> Since you're using xampp, I assume you're accessing the HTML file
>>>>>>>>>> through the webserver rather than locally, but if you're not, then
>>>>>>>>>> this
>>>>>>>>>> could be a Flash security issue (see the
>>>>>>>>>> Notes<https://developers.google.com/chart/interactive/docs/gallery/annotatedtimeline#notes>section
>>>>>>>>>> in the ATL documentation for details).
>>>>>>>>>>
>>>>>>>>>> On Monday, November 12, 2012 5:22:37 PM UTC-5, sam wrote:
>>>>>>>>>>>
>>>>>>>>>>> Hi,
>>>>>>>>>>> I am using mysql/php to create json data, in addition have
>>>>>>>>>>> test.html that read json and draws annotated timeline,
>>>>>>>>>>>
>>>>>>>>>>> keep getting "OPTIONS http://www.google.com/jsapi 405
>>>>>>>>>>> (Method Not Allowed)" error
>>>>>>>>>>>
>>>>>>>>>>> "XMLHttpRequest cannot load http://www.google.com/jsapi.
>>>>>>>>>>> Origin http://nova.it.rit.edu is not allowed by
>>>>>>>>>>> Access-Control-Allow-Origin."
>>>>>>>>>>>
>>>>>>>>>>> need urgent help, I am using xampp
>>>>>>>>>>>
>>>>>>>>>>> thanks
>>>>>>>>>>>
>>>>>>>>>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/UKY00KR3TH0J.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
