php - 如何组合 3 个数组
问题描述
你好社区
我只是想问一下我的代码。我只想结合我的 3 个变量
$result = mysqli_query($con, "SELECT disease,age,SUM(CASE WHEN gender = 'm' THEN 1 ELSE 0 END) AS `totalM`, SUM(CASE WHEN gender = 'f' THEN 1 ELSE 0 END) AS `totalF` FROM mdr where disease = '$diseaseselection' GROUP BY disease , age");
$chart_data = '';
while($row = mysqli_fetch_array($result))
{
$tabx[]=$row['age'];
$taby[]=$row['totalM'];
$tabz[]=$row['totalF'];
}
$tableau=array_combine($tabx,$taby,$tabz);
foreach($tableau as $key=>$value){
$string[]=array('age'=>$key,'totalM'=>$value,'totalF'=>$value);
}
echo json_encode($string);
这段代码可以正常工作。有 2 个变量。我希望它由树变量完成
$result = mysqli_query($con, "SELECT disease,age,SUM(CASE WHEN gender = 'm' THEN 1 ELSE 0 END) AS `totalM`, SUM(CASE WHEN gender = 'f' THEN 1 ELSE 0 END) AS `totalF` FROM mdr where disease = '$diseaseselection' GROUP BY disease , age");
$chart_data = '';
while($row = mysqli_fetch_array($result))
{
$tabx[]=$row['age'];
$taby[]=$row['totalM'];
}
$tableau=array_combine($tabx,$taby);
foreach($tableau as $key=>$value){
$string[]=array('age'=>$key,'totalM'=>$value);
}
echo json_encode($string);
这是我的预期输出
{ age:'0-1', totalM:2, totalF:1},
{ age:'1-4', totalM:1, totalF:0},
{ age:'10-14', totalM:0, totalF:1},
{ age:'15-19', totalM:0, totalF:1},
{ age:'5-9', totalM:0, totalF:3},
{ age:'55-59', totalM:6, totalF:0}
解决方案
$result = mysqli_query($con, "SELECT disease,age,SUM(CASE WHEN gender = 'm' THEN 1 ELSE 0 END) AS `totalM`, SUM(CASE WHEN gender = 'f' THEN 1 ELSE 0 END) AS `totalF` FROM mdr where disease = '$diseaseselection' GROUP BY disease , age");
$chart_data = '';
$data = [];
while($row = mysqli_fetch_array($result)) {
$data[] = [
'age' => $row['age'],
'totalM' => $row['totalM'],
'totalF' => $row['totalF']
];
}
echo json_encode($data);
推荐阅读
- javascript - JavaScript:函数 - 如何激活取消按钮
- android - 导航组件:如何列出返回栈上的片段?
- netsuite - 如何在 netsuite 中使用 portlet 脚本类型(SuiteScript 2.0)显示饼图?以及如何在我们的 portlet 脚本中包含 HTML 文件。
- c++ - 在具有可变参数模板的基于模板的类中完美转发?
- git - 在 git 存储库中维护相同自述文件的两个副本
- python - Matplotlib x 轴上的毫秒刻度
- android - 在 RecyclerView OnItemClickListener 上显示对话框
- flutter - 如何将下载的数据从 API 保存到 Flutter 中的 RAM?
- python - Django 自动建模多对多关系添加
- r - 如何计算期权的 Black-Scholes 看跌期权