回答編集履歴
1
追記
answer
CHANGED
|
@@ -6,8 +6,7 @@
|
|
|
6
6
|
|
|
7
7
|
$search = filter_input(INPUT_POST, 'search');
|
|
8
8
|
|
|
9
|
-
// 日別ごとに格納と言うけれど、示されていないので知らん。よしなにやってくれ。
|
|
10
|
-
$sql = "SELECT sum(complete) as complete, sum(profit) as profit FROM report WHERE date LIKE ? GROUP BY
|
|
9
|
+
$sql = "SELECT sum(complete) as complete, sum(profit) as profit FROM report WHERE date LIKE ? GROUP BY YEAR(`date`), MONTH(`date`)";
|
|
11
10
|
$stmt = $dsn->prepare($sql);
|
|
12
11
|
$stmt->execute(['%' . $search . '%']);
|
|
13
12
|
|