I hate to say that I am not familiar with this. I will do some research and try this out.
Thanks On Wednesday, 8 July 2015 13:09:49 UTC+1, Daniel LaLiberte wrote: > Hi James, > > To debug this, I would suggest first using a Table chart, just to see > whether you are getting the data you expect. Check that your json data > looks right by going into the JavaScript debugger, and breaking on the line > where you create your DataTable. That might tell you enough to help you > proceed. Report here what you find if you are still stuck. > > On Wed, Jul 8, 2015 at 8:00 AM, James Moran <[email protected] > <javascript:>> wrote: > >> I am trying to create a line chart for displaying time vs products sold. >> >> The MySQL statement is tested fine and brings back the data I want from >> the two specific columns timecol and regular. >> >> I have attached the two files. If anyone can tell me why these are not >> working I would really appreciate it as I cant seem to find any decent >> example of MySQL into line charts. (OBVIOUSLY THE CONNECTION DETAILS HAVE >> BEEN REMOVED) >> >> Index.php >> >> <html> >> <head> >> <script type="text/javascript" src=" >> https://www.google.com/jsapi";></script> >> <script type="text/javascript" src=" >> http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js";></script >> > >> <script type="text/javascript"> >> // Load the Visualization API and the piechart package. >> google.load('visualization', '1', {'packages':['corechart']}); >> // Set a callback to run when the Google Visualization API is loaded. >> google.setOnLoadCallback(drawChart); >> function drawChart() { >> var json = $.ajax({ >> url: 'get_json.php', // make this url point to the data file >> dataType: 'json', >> async: false >> }).responseText; >> >> // Create our data table out of JSON data loaded from server. >> var data = new google.visualization.DataTable(json); >> var options = { >> title: 'Daily Sales', >> is3D: 'true', >> width: 800, >> height: 600 >> }; >> // Instantiate and draw our chart, passing in some options. >> //do not forget to check ur div ID >> var chart = new >> google.visualization.LineChart(document.getElementById('chart_div')); >> chart.draw(data, options); >> } >> </script> >> </head> >> <body> >> <div id="chart_div" style="width: 900px; height: 500px;"></div> >> </body> >> </html> >> >> get_json.php >> >> <?php >> >> $con = mysql_connect('**********', '***********', '**********') or >> die('Error connecting to server'); >> >> mysql_select_db("*********", $con); >> // write your SQL query here (you may use parameters from $_GET or $_POST >> if you need them) >> $query = mysql_query("SELECT timecol, regular FROM SalesData WHERE >> site='marketstreet' AND datecol='28062015' AND regular>=1 GROUP BY >> timecol"); >> $table = array(); >> $table['cols'] = array( >> /* define your DataTable columns here >> * each column gets its own array >> * syntax of the arrays is: >> * label => column label >> * type => data type of column (string, number, date, datetime, boolean) >> */ >> // I assumed your first column is a "string" type >> // and your second column is a "number" type >> // but you can change them if they are not >> array('label' => 'timecol', 'type' => 'string'), >> array('label' => 'regular', 'type' => 'string') >> ); >> $rows = array(); >> while($r = mysql_fetch_assoc($query)) { >> $temp = array(); >> // each column needs to have data inserted via the $temp array >> $temp[] = array('v' => (int) $r['timecol']); >> $temp[] = array('v' => (int) $r['regular']); // typecast all numbers to >> the appropriate type (int or float) as needed - otherwise they are input as >> strings >> >> // insert the temp array into $rows >> $rows[] = array('c' => $temp); >> } >> // populate the table with rows of data >> $table['rows'] = $rows; >> // encode the table as JSON >> $jsonTable = json_encode($table); >> // set up header; first two prevent IE from caching queries >> header('Cache-Control: no-cache, must-revalidate'); >> header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); >> header('Content-type: application/json'); >> // return the JSON data >> echo $jsonTable; >> ?> >> >> >> My long term goal is to show the data as time series but just to get a >> line chart working would be a good start. >> >> Thanks in advance. >> >> -- >> 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] >> <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at >> http://groups.google.com/group/google-visualization-api. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> > - 978-394-1058 > [email protected] <javascript:> 5CC, Cambridge MA > [email protected] <javascript:> 9 Juniper Ridge Road, Acton MA > -- 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/d/optout.
