PHP を使用して Web データを視覚化する方法

<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>

<?php
//从数据库中检索数据
$data = array();
while ($row = mysqli_fetch_array($result)) {
    $data[] = $row['value'];
}
?>

<script>
//将数据传递给JavaScript
var data = <?php echo json_encode($data); ?>;

//创建图表
var ctx = document.getElementById('myChart').getContext('2d');
var chart = new Chart(ctx, {
    type: 'bar',
    data: {
        labels: ['January', 'February', 'March', 'April', 'May', 'June', 'July'],
        datasets: [{
            label: 'Data',
            data: data,
            backgroundColor: 'rgba(255, 99, 132, 0.2)',
            borderColor: 'rgba(255, 99, 132, 1)',
            borderWidth: 1
        }]
    },
    options: {
        scales: {
            yAxes: [{
                ticks: {
                    beginAtZero: true
                }
            }]
        }
    }
});
</script>

<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>

<?php
//从数据库中检索数据
$data = array();
while ($row = mysqli_fetch_array($result)) {
    $data[] = array($row['month'], (int)$row['sales']);
}
?>

<script>
//加载图表库
google.charts.load('current', {'packages':['corechart']});

//设置回调函数
google.charts.setOnLoadCallback(drawChart);

//绘制图表
function drawChart() {
  //创建数据表格
  var data = new google.visualization.DataTable();
  data.addColumn('string', 'Month');
  data.addColumn('number', 'Sales');
  data.addRows(<?php echo json_encode($data); ?>);

  //设置选项
  var options = {'title':'Sales Report',
                 'width':400,
                 'height':300};

  //创建图表对象
  var chart = new google.visualization.LineChart(document.getElementById('myChart'));
  chart.draw(data, options);
}
</script>

<script src="https://d3js.org/d3.v5.min.js"></script>

<?php
//从数据库中检索数据
$data = array();
while ($row = mysqli_fetch_array($result)) {
    $data[] = array('label' => $row['product_name'], 'value' => (int)$row['sales']);
}
?>

<script>
//设置宽度和高度
var width = 800;
var height = 400;

//创建SVG并设置宽度和高度
var svg = d3.select("body")
            .append("svg")
            .attr("width", width)
            .attr("height", height);

//创建Pie图
var pie = d3.pie()
            .value(function(d) { return d.value; })(<?php echo json_encode($data); ?>);

//创建弧线对象
var arc = d3.arc()
            .outerRadius(Math.min(width, height) / 2 - 1)
            .innerRadius(0);

//创建Pie图表
var arcLabel = (() => {
  const radius = Math.min(width, height) / 2;
  return d3.arc().innerRadius(radius).outerRadius(radius);
})();

//创建颜色比例尺
var color = d3.scaleOrdinal().range(d3.schemeCategory10);

//绘制Pie图
var label = d3.arc().outerRadius(radius * 0.8).innerRadius(radius * 0.4);
  pie.forEach(function(d) {
    d.innerRadius = 0;
    d.outerRadius = radius - 40;
    d.color = color(d.data.label);
  });

//根据弧线对象创建路径
var path = svg.selectAll("path")
              .data(pie)
              .enter()
              .append("path")
              .attr("d", arc)
              .attr("fill", function(d) { return d.color; })
              .attr("stroke", "white")
              .style("stroke-width", "2px")
              .style("opacity", 0.7)
              .each(function(d) { this._current = d; });

//添加标签
var label = svg
  .selectAll('.label')
  .data(pie)
  .enter()
  .append('g')
  .attr('class', 'label-group')
  .attr('transform', function(d) {
    var centroid = arc.centroid(d);
    return 'translate(' + [centroid[0] * 1.5, centroid[1] * 1.5] + ')';
  });

label.append('text')
  .attr('class', 'label')
  .text(function(d) {
    return d.data.label;
  })
  .attr('text-anchor', 'middle')
  .style('fill', '#ffffff')
  .style('font-size', '12px');