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: graf.php>>
<<attachment: get_json.php>>
