php - highcharts 从数据库表中提取数据

Question

我正在使用的演示:http://jsfiddle.net/98Fuq/4/

我使用

在 x 轴上显示职位编号

$sql = "SELECT * FROM view_job_budgetreport";
$result = mysqli_query($dbc3, $sql);
while($row = mysqli_fetch_assoc($result)) {
    $jobNum[] = $row['Job_Num'];
}

然后在我的代码中:

var colors = Highcharts.getOptions().colors,
categories = [<?php echo join($jobNum, ',') ?>], //I display the job nums here
name = '% of budgeted hours',
level = 0,
data = [{
      y: 300,
      color: colors[0],
      drilldown: {
         name: 'Job # Detailed Overview',
         categories: ['Surfacing', 'Design', 'Details', 'Ejector', 'EDM', 'GD/BM', 'CNC', 'Mold Making', 'Spotting', 'Spotting Line', 'Handwork', 'Tryout'  ],
         level: 1,
         data: [{
             y: 30,
             drilldown: {
                 level: 2,
                 name: 'Job # Machining Overview',
                 categories: ['CNC 1', 'CNC 2', 'CNC 3', 'CNC4', 'Gun Drill 1', 'Gun Drill 2', 'Boring Mill 1', 'Boring Mill 2', 'EDM 1', 'EDM 2', 'EDM 3'],
                 data: [23,54,47, 58, 42, 10, 34, 78, 10, 55, 25],
                 color: colors[3]
             }
         }, 40, 7.35, 2.41, 200, 100, 50, 75, 86, 95, 75, 25],
         color: colors[2]
      }
   }

现在这部分工作得很好，但是我一生都无法弄清楚深入分析的第 2 层和第 3 层。我尝试使用与处理职位编号相同的方法。

表结构:

Answer 1

像这样更改你的 php，这样你就可以获得所需的所有值；

$sql = "SELECT * FROM view_job_budgetreport";
$result = mysqli_query($dbc3, $sql);
while($row = mysqli_fetch_assoc($result)) {
    $jobNum[] = $row['Job_Num'];
    $jobData[$row['Job_Num']] = $row['Job_Y'];
    $jobDrillData[$row['Job_Num']][] = $row;
}

然后在 highcharts 中循环这些变量