我使用json输出按时间戳月份计数文章视图。我有这个代码：
$value = array();
$stats = Access::FETCH("SELECT COUNT(*) AS id FROM news_stats GROUP BY YEAR(date), MONTH(date)");
foreach($stats as $key => $value){
$rows2[] = $value['id'];
}
echo json_encode($rows2);
输出是： NOTE: this is count for month each month
["1","6"]
我需要像这样打印输出的月份名称：
["january","June"]
如何在打印月份中命名？Menaig是：1 , 6从哪个月开始计数？
尝试这个 ：
$value = array();
$stats = Access::FETCH("SELECT id, YEAR(FROM_UNIXTIME(date)) AS `YEAR`,
MONTHNAME(FROM_UNIXTIME(date)) AS `MONTH`,
COUNT(*) AS id
FROM news_stats GROUP BY `YEAR`, `MONTH` ORDER BY `YEAR` DESC, `MONTH`");
foreach($stats as $key => $value){
$rows2[] = $value['MONTH'];
}
echo json_encode($rows2);
输出为：
["June","August"]
请享用！！
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句