Thanks for your reply, my problem is solved now my chart is displaying properly
On Fri, Nov 29, 2013 at 6:50 AM, asgallant <[email protected]>wrote: > The appropriate type is "number", which works for both floating-point and > integer numbers (as all numbers are floats in javascript). > > > On Thursday, November 28, 2013 11:00:10 AM UTC-5, Qurat Haider wrote: >> >> This is the my code i am using for column chart before the new release of >> Google Api and it is working fine. Now my chart is not displaying. i have >> checked the new release changes but i found noting relevant. the first >> problem appears with the data type in array, float data type is not legal >> and if i replaced it with some other data type then chart still not >> displayed. if i change the float to string then error will appear that >> string data type will not be used on X-axis. I have plotted time on X-axis >> and Distance on Y-axis. If any one knows how to change the code according >> to new release of Google Api please share your code or some information. >> >>> >>> >>> // Connect to server and select database. >>> $con=mysql_connect("$host", "$username")or die("cannot connect"); >>> mysql_select_db("$db_name")or die("cannot select DB"); >>> >>> $data = mysql_query("select SUM(Distance) as Distance, CAST( Time AS date) >>> as Time from gprs where DeviceId=25 and Time between '2013-08-08' and >>> '2013-09-31' group by CAST(Time AS date) order by CAST( Time AS date)") >>> or die(mysql_error()); >>> >>> $table = array(); >>> $table['cols'] = array( >>> >>> array('label' => 'TIME', 'type' => 'string'), >>> array('label' => 'Distance', 'type' => 'float') >>> ); >>> $rows = array();while ($nt = mysql_fetch_assoc($data)) >>> { >>> >>> $temp = array(); >>> $temp[] = array('v' => (string)$nt['TIME']); >>> $temp[] = array('v' =>(float) $nt['Distance']); >>> $rows[]['c'] = $temp; >>> } >>> $table['rows'] = $rows; >>> $jsonTable = json_encode($table); >>> ?> >>> >>> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" >>> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> >>> <html xmlns="http://www.w3.org/1999/xhtml";> >>> <head> >>> <meta http-equiv="content-type" content="text/html; charset=utf-8"/> >>> <title> >>> Google Visualization API Sample >>> </title> >>> <script type="text/javascript" src="//www.google.com/jsapi"></script> >>> <script type="text/javascript"> >>> google.load('visualization', '1', {packages: ['corechart']}); >>> </script> >>> <script type="text/javascript"> >>> function drawVisualization() { >>> // Create and populate the data table. >>> var data = new google.visualization.DataTable(<?=$jsonTable?>); >>> >>> // Create and draw the visualization. >>> new >>> google.visualization.ColumnChart(document.getElementById('visualization')). >>> draw(data); >>> } >>> >>> google.setOnLoadCallback(drawVisualization); >>> </script> >>> </head> >>> <body style="font-family: Arial;border: 0 none;"> >>> <div id="visualization" style="width: 600px; height: 300px;"></div> >>> </body> >>> </html> >>> >>> >>> -- > 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/-T4SrwPf1uM/unsubscribe > . > To unsubscribe from this group and all its topics, send an email to > [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
