在ChartJS和PHP中分组数据

// HTML
<canvas id="myChart"></canvas>

// JavaScript
var ctx = document.getElementById('myChart').getContext('2d');
var chart = new Chart(ctx, {
  type: 'bar',
  data: {
    labels: ['Group 1', 'Group 2', 'Group 3'],
    datasets: [
      {
        label: 'Data 1',
        data: [10, 20, 30],
        backgroundColor: 'rgba(255, 99, 132, 0.5)'
      },
      {
        label: 'Data 2',
        data: [15, 25, 35],
        backgroundColor: 'rgba(54, 162, 235, 0.5)'
      }
    ]
  },
  options: {
    responsive: true,
    scales: {
      x: {
        stacked: true
      },
      y: {
        stacked: true
      }
    }
  }
});

$data = [
  ['Group 1', 10],
  ['Group 1', 20],
  ['Group 2', 15],
  ['Group 2', 25],
  ['Group 3', 30],
  ['Group 3', 35]
];

$groups = [];
foreach ($data as $item) {
  $group = $item[0];
  $value = $item[1];
  
  if (!isset($groups[$group])) {
    $groups[$group] = [];
  }
  
  $groups[$group][] = $value;
}

// 输出每个数据组的值
foreach ($groups as $group => $values) {
  echo "Group: $group\n";
  echo "Values: " . implode(', ', $values) . "\n";
}