Advertisement
Guest User

Untitled

a guest
Jul 24th, 2014
192
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.46 KB | None | 0 0
  1. $objDbResultByModel = $objDatabase->Query($modelQuery);
  2. $return_arr = array();
  3. echo "<h3>Total Model No<br></h3><strong>";
  4. while ($mixRow = $objDbResultByModel->FetchArray()) {
  5. $row_array['Model No.'] = $mixRow['Manu']." - " .$mixRow['model'];
  6. $row_array['Quantity'] = $mixRow['total'];
  7.  
  8. array_push($return_arr,$row_array);
  9. $jsonTable = json_encode($return_arr);
  10. echo $jsonTable;
  11.  
  12. <script type="text/javascript">
  13.  
  14. // Load the Visualization API and the piechart package.
  15. google.load('visualization', '1.0', {'packages':['corechart']});
  16.  
  17. // Set a callback to run when the Google Visualization API is loaded.
  18. google.setOnLoadCallback(drawChart);
  19.  
  20. // Callback that creates and populates a data table,
  21. // instantiates the pie chart, passes in the data and
  22. // draws it.
  23. function drawChart() {
  24.  
  25. // Create the data table.
  26. var data = new google.visualization.DataTable();
  27. data.addColumn('string', 'Topping');
  28. data.addColumn('number', 'Slices');
  29. data.addRows([
  30.  
  31. <?php echo $jsonTable; ?>
  32.  
  33. ]);
  34.  
  35. // Set chart options
  36. var options = {'title':'How Much Pizza I Ate Last Night',
  37. 'width':400,
  38. 'height':300};
  39.  
  40. // Instantiate and draw our chart, passing in some options.
  41. var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
  42. chart.draw(data, options);
  43. }
  44. </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement