PHP:chart_db.php<?phprequire_once ('dbh.inc.php');$JSON_Response = array();//Counts the number of Active$count_active = mysqli_query($db, "SELECT client_id FROM client WHERE status = 1");$JSON_Response['active'] = mysqli_num_rows($count_active);//Counts the number of Inactive$count_inactive = mysqli_query($db, "SELECT client_id FROM client WHERE status = 0");$JSON_Response['inactive'] = mysqli_num_rows($count_inactive);error_log('hello');echo json_encode($JSON_Response);?>JS: chart.js $(文檔).ready(函數(){ $.ajax({ url:"http://localhost/FAME/private/includes/chart_db.php", method: "GET", success: function(response){ var data = JSON.parse(response); var activeData = text(data.active); var inactiveData = text(data.inactive); console.log(activeData); var ctx = document.getElementById('piechart').getContext('2d'); var statusChart = new Chart(ctx, { type: 'doughnut', data: { labels: ['Active', 'Inactive'], datasets: [{ pointStyle: 'circle', backgroundColor: [ 'rgb(78, 115, 223)', 'rgb(25, 179, 211)' ], data: activeData, inactiveData }] }, options: { responsive: true, maintainAspectRatio: false, segmentShowStroke: false, cutoutPercentage: 70, legend: { onClick: false, position: 'bottom', labels: { usePointStyle: true } } } }); } });});問題:問題是圖表中的數據沒有顯示。沒有顯示整個圖表。使用 chrome 檢查的日志:它說有一個錯誤:“未捕獲的 ReferenceError:文本未定義”。
1 回答

萬千封印
TA貢獻1891條經驗 獲得超3個贊
這與 php、mysql 或 xampp 無關。您正在使用一個名為 的未定義方法text
。錯誤消息說明了一切。檢查 ajax 成功中的第三行和第四行。你有:
var activeData = text(data.active);
將其替換為:
var activeData = data.active;
看看會發生什么。
- 1 回答
- 0 關注
- 139 瀏覽
添加回答
舉報
0/150
提交
取消