谷歌 chart 問題官方文件 https://google-developers.app...
$.getJSON('XXX&m=' + m, function(json) {
var data = new google.visualization.DataTable(json);
data.addColumn('string', '');
data.addColumn('number', '');
data.addRows(json);
console.log(json);
php
$chartData = $pdo->query(
"SELECT DISTINCT
FROM_UNIXTIME(add_time, '%m/%d') as add_time,
count(view_id) as viewTime
FROM `view`
GROUP BY `add_time` "
);
foreach ($chartData as $key) {
if (substr($key['add_time'] ,0 ,2) == $_GET['m']) {
$data[] = array(
$key['add_time'], (int) $key['viewTime']
);
}
}
echo json_encode($data ,JSON_UNESCAPED_SLASHES);
我每一筆 view 都有一個(gè) add_time 時(shí)間戳我上面是把時(shí)間戳轉(zhuǎn)換為 mm/dd 格式，然后再透過 $_GET['m'] 帶來的日期，例如 05
output [["11/01",1],["11/02",1],["11/03",1],["11/05",1]]
但其實(shí) 11/01 ,11/02, 11/03, 11/05 都是多筆的
透過 count(view_id) as viewTime 算出來都是一筆～
所以我想不到怎么算出每個(gè)日期共有幾筆？
- 1 回答
- 0 關(guān)注
- 402 瀏覽
添加回答
舉報(bào)
0/150
提交
取消