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