php - 使用 PHP MySQL 在折线图中不显示月份

Question

在这里，我绘制line chart以显示统计细节。在这里，我想将详细信息显示为Monthly wise. 下面是我尝试过的代码。

// line chart starts
$stmt3 = $conn->prepare("SELECT decease_name, DATE_FORMAT(date, '%M') as dates, count(*) Consultations from prescription WHERE decease_name !='Reconsultation Need' AND date BETWEEN ADDDATE(NOW(),-365) AND NOW()  group by decease_name , DATE_FORMAT(date, '%M')");

$stmt3->execute();
$result3 = $stmt3->get_result();
$chart_datass = '';
$label1 = '';
$label2 = '';
?>

    datasets: [
        
<?php

       while($row = mysqli_fetch_array($result3)){
      
            $chart_datass = "".$row['decease_name']." ";
            $label1 = "'".$row['Consultations']."', ";
            $label2 = "'".$row['dates']."' ";

?>
{
        labels: [<?php echo $label2; ?>],
        data: [<?php echo $label1; ?>],
        label: "<?php echo $chart_datass; ?>",
        borderColor: getRandomColor(),
        fill: false
      },

      <?php   } ?> 
        
    ]

中database，records如下图所示。

+---------------+------------+
| Decease NAME  |    Date    |
+---------------+------------+
| Diabetis      | 2021-09-15 |
| Dengue        | 2021-08-10 |
+---------------+------------+

但在line chart它显示如下。

我看不到month name它，它group不像month。有人可以帮我改进我的代码。提前致谢。

标签： phpmysqlchartslinechart