Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $objDbResultByModel = $objDatabase->Query($modelQuery);
- $return_arr = array();
- echo "<h3>Total Model No<br></h3><strong>";
- while ($mixRow = $objDbResultByModel->FetchArray()) {
- $row_array['Model No.'] = $mixRow['Manu']." - " .$mixRow['model'];
- $row_array['Quantity'] = $mixRow['total'];
- array_push($return_arr,$row_array);
- $jsonTable = json_encode($return_arr);
- echo $jsonTable;
- <script type="text/javascript">
- // Load the Visualization API and the piechart package.
- google.load('visualization', '1.0', {'packages':['corechart']});
- // Set a callback to run when the Google Visualization API is loaded.
- google.setOnLoadCallback(drawChart);
- // Callback that creates and populates a data table,
- // instantiates the pie chart, passes in the data and
- // draws it.
- function drawChart() {
- // Create the data table.
- var data = new google.visualization.DataTable();
- data.addColumn('string', 'Topping');
- data.addColumn('number', 'Slices');
- data.addRows([
- <?php echo $jsonTable; ?>
- ]);
- // Set chart options
- var options = {'title':'How Much Pizza I Ate Last Night',
- 'width':400,
- 'height':300};
- // Instantiate and draw our chart, passing in some options.
- var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
- chart.draw(data, options);
- }
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement