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/-/U96X1H3W1LYJ.
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.
