質問編集履歴
3
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -19,7 +19,7 @@
|
|
|
19
19
|
exit();
|
|
20
20
|
}
|
|
21
21
|
|
|
22
|
-
$query = "SELECT tmp FROM ******";
|
|
22
|
+
$query = "SELECT hour,tmp FROM ******";
|
|
23
23
|
|
|
24
24
|
if ($result = $mysqli->query($query)) {
|
|
25
25
|
while ($row = $result->fetch_assoc()) {
|
2
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -8,7 +8,7 @@
|
|
|
8
8
|
hour,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19
|
|
9
9
|
tmp,12.5,13.6,16.2,14.3,18.2,16.8,15.5,15.6,15.5,16.3,16.5,16.6,15.8,15.8,15.6,15.1,14.7,13.3,12.0
|
|
10
10
|
|
|
11
|
-
という配列
|
|
11
|
+
という配列でcsvファイルに書き込む方法を教えて頂きたいです。
|
|
12
12
|
|
|
13
13
|
```
|
|
14
14
|
<?php
|
|
@@ -37,5 +37,6 @@
|
|
|
37
37
|
}
|
|
38
38
|
```
|
|
39
39
|
|
|
40
|
+
|
|
40
41
|
すみませんが力をお貸しください。
|
|
41
42
|
よろしくお願いします。
|
1
文章の修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -10,6 +10,32 @@
|
|
|
10
10
|
|
|
11
11
|
という配列にしてcsvファイルを作成したいです。
|
|
12
12
|
|
|
13
|
+
```
|
|
14
|
+
<?php
|
|
15
|
+
$mysqli = new mysqli("******", "******", "******", "******");
|
|
13
16
|
|
|
17
|
+
if ($mysqli->connect_errno) {
|
|
18
|
+
printf("Connect failed: %s\n", $mysqli->connect_error);
|
|
19
|
+
exit();
|
|
20
|
+
}
|
|
21
|
+
|
|
22
|
+
$query = "SELECT tmp FROM ******";
|
|
23
|
+
|
|
24
|
+
if ($result = $mysqli->query($query)) {
|
|
25
|
+
while ($row = $result->fetch_assoc()) {
|
|
26
|
+
$contents = "\"" . $row["hour"] . "\",\""
|
|
27
|
+
. $row["tmp"] . "\"\n";
|
|
28
|
+
|
|
29
|
+
$fp = fopen('test.csv', 'w');
|
|
30
|
+
|
|
31
|
+
foreach($contents as $fields) {
|
|
32
|
+
fputcsv($fp, $fields);
|
|
33
|
+
print $fields;
|
|
34
|
+
}
|
|
35
|
+
}
|
|
36
|
+
$result->free();
|
|
37
|
+
}
|
|
38
|
+
```
|
|
39
|
+
|
|
14
40
|
すみませんが力をお貸しください。
|
|
15
41
|
よろしくお願いします。
|