回答編集履歴
6
修正
test
CHANGED
@@ -8,7 +8,7 @@
|
|
8
8
|
|
9
9
|
$count_rev_date = [];
|
10
10
|
|
11
|
-
$record_rev_sql="SELECT date_format(rev_date,'%Y-%m-%d') rev_date, count(*) as cnt FROM review WHERE rev_date LIKE '$date_y_m%' group by 1";
|
11
|
+
$record_rev_sql="SELECT date_format(rev_date,'%Y-%m-%d') as rev_date, count(*) as cnt FROM review WHERE rev_date LIKE '$date_y_m%' group by 1";
|
12
12
|
|
13
13
|
$record_rev_stt=$dbh->prepare($record_rev_sql);
|
14
14
|
|
5
修正
test
CHANGED
@@ -8,7 +8,7 @@
|
|
8
8
|
|
9
9
|
$count_rev_date = [];
|
10
10
|
|
11
|
-
$record_rev_sql="SELECT date_format(rev_date,'%Y-%m-%d'), count(*) as cnt FROM review WHERE rev_date LIKE '$date_y_m%' group by 1";
|
11
|
+
$record_rev_sql="SELECT date_format(rev_date,'%Y-%m-%d') rev_date, count(*) as cnt FROM review WHERE rev_date LIKE '$date_y_m%' group by 1";
|
12
12
|
|
13
13
|
$record_rev_stt=$dbh->prepare($record_rev_sql);
|
14
14
|
|
4
変更
test
CHANGED
@@ -8,7 +8,7 @@
|
|
8
8
|
|
9
9
|
$count_rev_date = [];
|
10
10
|
|
11
|
-
$record_rev_sql="SELECT
|
11
|
+
$record_rev_sql="SELECT date_format(rev_date,'%Y-%m-%d'), count(*) as cnt FROM review WHERE rev_date LIKE '$date_y_m%' group by 1";
|
12
12
|
|
13
13
|
$record_rev_stt=$dbh->prepare($record_rev_sql);
|
14
14
|
|
3
変更
test
CHANGED
File without changes
|
2
変更
test
CHANGED
@@ -8,7 +8,7 @@
|
|
8
8
|
|
9
9
|
$count_rev_date = [];
|
10
10
|
|
11
|
-
$record_rev_sql="SELECT rev_date count(*) as cnt FROM review WHERE rev_date LIKE '$date_y_m%' group by
|
11
|
+
$record_rev_sql="SELECT rev_date::date, count(*) as cnt FROM review WHERE rev_date LIKE '$date_y_m%' group by 1";
|
12
12
|
|
13
13
|
$record_rev_stt=$dbh->prepare($record_rev_sql);
|
14
14
|
|
1
修正
test
CHANGED
@@ -1,12 +1,14 @@
|
|
1
|
-
カレンダーと結びつける一つの案としてです。
|
1
|
+
カレンダーと結びつける一つの案としてです。テーブル内容は想像して作成しています。
|
2
2
|
|
3
3
|
|
4
4
|
|
5
5
|
```php
|
6
6
|
|
7
|
+
//日毎にレビュー数を集計
|
8
|
+
|
7
9
|
$count_rev_date = [];
|
8
10
|
|
9
|
-
$record_rev_sql="SELECT * FROM review WHERE rev_date LIKE '$date_y_m%'";
|
11
|
+
$record_rev_sql="SELECT rev_date count(*) as cnt FROM review WHERE rev_date LIKE '$date_y_m%' group by rev_date";
|
10
12
|
|
11
13
|
$record_rev_stt=$dbh->prepare($record_rev_sql);
|
12
14
|
|
@@ -18,7 +20,7 @@
|
|
18
20
|
|
19
21
|
//ハッシュ配列に保存
|
20
22
|
|
21
|
-
$count_rev_date[$record_rev_result["rev_date"]] =
|
23
|
+
$count_rev_date[$record_rev_result["rev_date"]] = $record_rev_result["cnt"]
|
22
24
|
|
23
25
|
}
|
24
26
|
|
@@ -40,13 +42,13 @@
|
|
40
42
|
|
41
43
|
{
|
42
44
|
|
43
|
-
//レビューが有った日
|
45
|
+
//レビューが有った日
|
44
46
|
|
45
|
-
$cnt=$count_rev_date[$data[$i]];
|
47
|
+
$cnt=$count_rev_date[$data[$i]];
|
46
48
|
|
47
49
|
}else{
|
48
50
|
|
49
|
-
//レビューが無かった日
|
51
|
+
//レビューが無かった日
|
50
52
|
|
51
53
|
}
|
52
54
|
|