个人中心
gpt4 book ai didi

javascript - 无法从 phpmyadmin 生成饼图

转载 作者：行者123 更新时间：2023-11-29 19:45:36 25 4
gpt4 key购买 nike

我想在从数据库获取表格的帮助下创建谷歌饼图...但直到现在我还没有得到输出...我搜索了几个网站..但我没有澄清任何事情...请检查我的编码并告诉

<?php

mysql_connect('localhost','root','');
mysql_select_db('chart');

$sqlquery1="select * from pie_chart";

$sqlresult1=mysql_query($sqlquery1);

$rows=array();

while($r=mysql_fetch_assoc($sqlresult1))
{
    $rows[]=$r;
}
$data= json_encode($rows);
?>
<html>
<head>
 <!--Load the AJAX API -->
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script      src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js" type="text/javascript"></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 data = new google.visualization.DataTable();
    data.addColumn("string", "Quarter");
    data.addColumn("number", "Number");

    data.addRows(<?php echo $data ?>); 

    ]); 

 //Create our data table out of JSON data loaded from server
 var data=new google.visualization.DataTable(jsonData);

 //Instantiate and draw our chart, passing in some options
 var chart=new      google.visualization.PieChart(document.getElementById('chart_div'));
  chart.draw(data,{width:400,height:240});
  }

  </script>
  </head>

  <body>
    <!--Div that will hold the pie chart -->
    <div id="chart_div"></div>
  </body>
  </html>

最佳答案 

<?php
/* Establish the database connection */
 $mysql =mysqli_connect('localhost', 'root', '', 'chart');
 /* select all the tasks from the table piechart */
 $result = $mysql->query('SELECT * FROM piechart');

 /*
  ---------------------------
  example data: Table (piechart)
  --------------------------
    Task        percent
  job             30
  daily           20
  working         35
  sleep           15       
 */


$rows = array();
$table = array();
$table['cols'] = array(

// Labels for your chart, these represent the column titles.
/* 
    note that one column is in "string" format and another one is in "number" format 
    as pie chart only required "numbers" for calculating percentage 
    and string will be used for Slice title
*/
               array('label' => 'task', 'type' => 'string'),
               array('label' => 'percent', 'type' => 'number')
               );

/* Extract the information from $result */
/* associate array are used in above ,so we used foreach loop*/
foreach($result as $r) 
{
  $temp = array();

   // The following line will be used to slice the Pie chart

   $temp[] = array('v' => (string) $r['task']); 

   // Values of the each slice

   $temp[] = array('v' => (int) $r['percent']);

   //rows of side title   
   $rows[] = array('c' => $temp);
 }
  $table['rows'] = $rows;

  // convert data into JSON format
  $jsonTable = json_encode($table);
  //echo $jsonTable;

 ?>

 <html>
 <head>
<!--Load the Ajax API-->
<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);

 // Load the Visualization API and the piechart package.
function drawChart()
{
 // Create our data table out of JSON data loaded from server.
 var bar_chart_data = new google.visualization.DataTable(<?php echo $jsonTable; ?>);

 var options = {
                title: 'Daily Work log',
                is3D: 'true',//3D effect true
                width: 900,
                height: 500
               };

  // Instantiate and draw our chart, passing in some options.
  // Do not forget to check your div ID
 var chart = new google.visualization.PieChart(document.getElementById('chart_div'));

 chart.draw(bar_chart_data, options);
}

   </script>
 </head>
           <body>
            <!--this is the div that will hold the pie chart-->
              <div id="chart_div" ></div>
           </body>
        </html>
   </script>
 </head>

关于javascript - 无法从 phpmyadmin 生成饼图，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/41011096/

25 4 0
文章推荐： javascript - 在 Typescript 中访问类的属性
文章推荐： javascript - AngularJS - ng-grid 和 data-ng-grid 之间的区别
文章推荐： android - 忽略 linkify 中的一个 url
文章推荐： javascript - 基于网格的环境中的 2D 光线转换
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com