使用PHP和MySQl的Google图表工具

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

$conn = new mysqli($servername, $username, $password, $dbname);

// 查询数据
$sql = "SELECT year, sales FROM sales_data";
$result = $conn->query($sql);

// 将数据转换成JSON格式
$data = array();
$data[] = array('Year', 'Sales');
while ($row = $result->fetch_assoc()) {
    $data[] = array($row['year'], $row['sales']);
}
$json_data = json_encode($data);

// 绘制图表
echo '<div id="chart_div" style="width: 800px; height: 400px;"></div>';
echo<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>';
echo<script type="text/javascript">';
echo "google.charts.load('current', {packages: ['corechart']});";
echo "google.charts.setOnLoadCallback(drawChart);";
echo "function drawChart() {";
echo "var data = google.visualization.arrayToDataTable(". $json_data .");";
echo "var options = { title: 'Sales Data', is3D: true };";
echo "var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));";
echo "chart.draw(data, options);";
echo "}";
echo "</script>";

// 关闭数据库连接
$conn->close();
?>