2018-07-05 18:14 阅读 80


Hello I am having a slight issue rendering a chart using chart.js,pulling data from a mysql db, It works when I am using an external file, to pull the data, However I am trying to code the entire thing on one File, but this is giving some trouble I am assuming the json_encode data is not being supplied properly the code is listed below:

<!DOCTYPE html>
<title>Demo Charts</title>  
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <script type="text/javascript" src="js/jquery.min.js"></script>
    <script type="text/javascript" src="js/Chart.min.js"></script>
    <script src="js/jquery-ui.min.js"></script>
$conn = mysqli_connect("localhost","root","password","db1");

$sqlQuery = "SELECT student_id,student_name,marks FROM tbl_marks ORDER BY student_id";
$result = mysqli_query($conn,$sqlQuery);
$data = array();
foreach ($result as $row) {
    $data[] = $row;
$json = json_encode($data);
            <span><h3>Pie Chart</h3></span>
            <canvas id="pieCanvas"></canvas>
        <script type="text/javascript"> 
        $(document).ready(function () {

        function showGraph2()
                var data = <?php echo $json; ?>;
               // $.post("api/data.php", `==>>THIS WORKS`
                     var name = [];
                    var marks = [];
                    var coloR = [];

                     var dynamicColors = function() {
                    var r = Math.floor(Math.random() * 255);
                    var g = Math.floor(Math.random() * 255);
                    var b = Math.floor(Math.random() * 255);
                    return "rgb(" + r + "," + g + "," + b + ")";

                    for (var i in data) {

                    var chartdata = {
                        labels: name,
                        datasets: [
                                label: 'Student Marks',
                                backgroundColor: '#49e2ff',
                                //borderColor: '#46d5f1',
                                backgroundColor: coloR,
                                hoverBackgroundColor: '#CCCCCC',
                                hoverBorderColor: '#666666',
                                data: marks

                    var graphTarget = $("#pieCanvas");

                    var barGraph = new Chart(graphTarget, {
                        type: 'pie',
                        data: chartdata



  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    drbxr86044 drbxr86044 2018-07-05 18:55

    Here's the relevant JavaScript part:

    const useAJAX = false;
    $(document).ready(function () {
      if (useAJAX) $.getJSON('api/data.php').then(showGraph);
      else showGraph(<?= $json ?>);
    function showGraph(data) {
      var name = [];
      var marks = [];
      var coloR = [];
      // etc, etc

    I have completely separated a) obtaining the data and b) processing the data. This way you can nicely switch between the two.

    I have directly inserted the JSON into the script, like you did. Not super clean or good practice, but will work fine for now.

    I have rewritten the AJAX part slightly, I'm using $.getJSON instead, assuming that the file doesn't require any POST parameters anyway. And I used .then(), taking advantage of the fact that jQuery AJAX methods return Promises.

    Final tip: don't mix PHP and HTML/JS like that. Move all your PHP stuff to the very top, set all your variables before your first echo / plain text. Then use ?><!DOCTYPE html> to move to HTML.

    点赞 评论 复制链接分享