質問編集履歴
1
プログラムが読みにくいため、改行をいれました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -16,42 +16,69 @@
|
|
|
16
16
|
### 該当のソースコード
|
|
17
17
|
|
|
18
18
|
<?php
|
|
19
|
+
|
|
19
20
|
//データベース情報
|
|
21
|
+
|
|
20
22
|
$dbname = "dbname";
|
|
23
|
+
|
|
21
24
|
$username = "username";
|
|
25
|
+
|
|
22
26
|
$pwnm = "pwnm";
|
|
23
27
|
|
|
28
|
+
|
|
24
29
|
//データベース接続
|
|
30
|
+
|
|
25
31
|
$connection =oci_connect($username, $pw,$dbname);
|
|
26
32
|
|
|
33
|
+
|
|
27
34
|
//実行
|
|
35
|
+
|
|
28
36
|
$sql = select * from test_table;
|
|
37
|
+
|
|
29
|
-
$r=oci_parse($connection,$sql)
|
|
38
|
+
$r=oci_parse($connection,$sql);
|
|
39
|
+
|
|
30
|
-
$result=oci_execute ($r)
|
|
40
|
+
$result=oci_execute ($r);
|
|
41
|
+
|
|
31
42
|
|
|
32
43
|
//配列で出力
|
|
44
|
+
|
|
33
45
|
$data=″″;
|
|
46
|
+
|
|
34
47
|
$csvstr[0]=″ID,くだもの,やさい,¥n″; //列名の設定
|
|
48
|
+
|
|
35
49
|
while($row = oci_fetch_array($r, OCI_ASSOC+ OCI_RETURN_NULLS)){
|
|
50
|
+
|
|
36
51
|
$csvstr = "{$row['ID']},{$row['fruit']},{$row['vegetable']},¥n″;
|
|
52
|
+
|
|
37
53
|
}
|
|
38
54
|
|
|
55
|
+
|
|
39
56
|
//文字変換
|
|
57
|
+
|
|
40
58
|
foreach( $csvstr as $row){
|
|
59
|
+
|
|
41
60
|
$data .=mb_convert_encoding($row,"sjis","utf8")."¥n";
|
|
61
|
+
|
|
42
62
|
}
|
|
43
63
|
|
|
44
64
|
// ファイルを書き込み
|
|
65
|
+
|
|
45
66
|
$file_name = 'csv/test.csv'; // ファイルパス
|
|
67
|
+
|
|
46
68
|
$fp = fopen($file_name, "w");
|
|
69
|
+
|
|
47
70
|
fwrite($fp,$data);
|
|
71
|
+
|
|
48
72
|
fclose($fp);
|
|
49
73
|
|
|
50
74
|
header('Content-Type: application/octet-stream');
|
|
75
|
+
|
|
51
76
|
header('Content-Length: '.filesize($file_name));
|
|
77
|
+
|
|
52
78
|
header('Content-Disposition: attachment; filename='.$file_name);
|
|
53
79
|
|
|
54
80
|
readfile($file_name);
|
|
81
|
+
|
|
55
82
|
exit();
|
|
56
83
|
|
|
57
84
|
?>
|