回答編集履歴

2

2

2016/09/17 14:39

投稿

takasima20
takasima20

スコア7458

test CHANGED
@@ -53,3 +53,5 @@
53
53
  }
54
54
 
55
55
  ```
56
+
57
+ //あ、こっちはSQLそのままって前提です。

1

1

2016/09/17 14:39

投稿

takasima20
takasima20

スコア7458

test CHANGED
@@ -5,3 +5,51 @@
5
5
  $sth = $dbh->prepare("SELECT day_id, sum(maru) as maru, sum(batu) as batu FROM data WHERE num1 = ? AND num2 = ? group by day_id");
6
6
 
7
7
  ```
8
+
9
+ --- 追加 ---
10
+
11
+ //かぶったのでコードの方も(^_^;
12
+
13
+ ```PHP
14
+
15
+ $Data = array();
16
+
17
+ while($row = $sth->fetch(PDO::FETCH_ASSOC)){
18
+
19
+ $id = $row['day_id'];
20
+
21
+ if (!isset($Data[$id]) {
22
+
23
+ $Data[$id] = array();
24
+
25
+ $Data[$id]['maru'] = 0;
26
+
27
+ $Data[$id]['batu'] = 0;
28
+
29
+ }
30
+
31
+ $Data[$id]['maru'] += $row['maru'];
32
+
33
+ $Data[$id]['batu'] += $row['batu'];
34
+
35
+ }
36
+
37
+
38
+
39
+ $Data2 = array();
40
+
41
+ foreach ($Data as $k=>$a) {
42
+
43
+ $Data2[] = array(
44
+
45
+ 'day_id'=>$k,
46
+
47
+ 'maru'=>$a['maru'],
48
+
49
+ 'batu'=>$a['batu'],
50
+
51
+ );
52
+
53
+ }
54
+
55
+ ```