I attached a chart file and a data source file that should work for you (though you may need to tweak them a bit, depending on your data).
On Monday, March 4, 2013 4:01:39 PM UTC-5, Vojtěch Piska wrote: > > Thank you a lot, but i dont know what do you think could you guide me what > to do in my code please:/ ? > > Dne pondělí, 4. března 2013 21:56:44 UTC+1 asgallant napsal(a): >> >> You have to format the data in the manner expected by the DataTable >> constructor. See this >> post<https://groups.google.com/d/msg/google-visualization-api/UdOFybnvFo0/wx_FK4fjh4AJ>for >> sample code you can use to get started. >> >> On Monday, March 4, 2013 3:38:13 PM UTC-5, Vojtěch Piska wrote: >>> >>> Hi friends, >>> I have problem i want to display some data from my mysql DB in line >>> chart, but still doesnt work. I am tired... because i dont know why, and I >>> read many, many forums.. >>> >>> my MySQL table: >>> >>> >>> <https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> >>> <https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> code in file *graf.php >>> :*<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> <?php<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>$con >>> >>> = >>> mysql_connect("localhost","root","123456");<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>mysql_select_db("aplikace", >>> >>> $con);<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>$result >>> >>> = mysql_query("SELECT * FROM >>> data");<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> >>> <https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>while >>> >>> ($row=mysql_fetch_array($result)){<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> $pole[]= >>> array(<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> 'cas' >>> => >>> $row['cas'],<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> 'data'=> >>> $row['data']<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> >>> );<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> >>> <https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> }<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> echo >>> json_encode($pole);<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> **<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> *?><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> * >>> >>> <https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>Code >>> >>> in* >>> get_json.html*<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> **<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> * >>> >>> <https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> <html><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> <head><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG><script >>> >>> type="text/javascript" >>> src="https://www.google.com/jsapi";></script><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG><script >>> >>> type="text/javascript" >>> src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js";></script><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG><script >>> >>> type="text/javascript"><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>google.load("visualization", >>> >>> "1", >>> {packages:["corechart"]});<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> google.setOnLoadCallback(drawChart);<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>function >>> >>> drawChart() >>> {<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>var >>> >>> jsonData = >>> $.ajax({<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>url: >>> >>> "graf.php",<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> dataType:"json",<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>async: >>> >>> false<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> }).responseText;<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>// >>> >>> Create our data table out of JSON data loaded from >>> server.<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>var >>> >>> data = new >>> google.visualization.DataTable(jsonData);<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>var >>> >>> options = >>> {<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>width: >>> >>> 800, height: >>> 480,<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>title: >>> >>> 'Company >>> Performance'<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> };<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>var >>> >>> chart = new >>> google.visualization.LineChart(document.getElementById('chart_div'));<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>chart.draw(data, >>> >>> options);<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> }<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> </script><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> </head><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> >>> <https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> <body><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG><div >>> >>> id="chart_div"></div><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> </body><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> </html><https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> >>> <https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG>If >>> >>> you can help me plese, I really dont know what to do and time is kicking >>> me:/ >>> I also added source files. Thanks a >>> lot:)<https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> * >>> >>> <https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> >>> <https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> >>> <https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> >>> <https://lh4.googleusercontent.com/-zNtE_GTwImI/UTUEqT1N5qI/AAAAAAAAAmE/DFaiXsPWc-8/s1600/tab.JPG> >>> >> -- 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 google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
<<attachment: get_json.php>>
<<attachment: graf.php>>
