質問編集履歴
3
閉じる箇所変更
test
CHANGED
File without changes
|
test
CHANGED
@@ -10,7 +10,7 @@
|
|
10
10
|
|
11
11
|
<?php
|
12
12
|
|
13
|
-
|
13
|
+
/*
|
14
14
|
|
15
15
|
顧客管理データベース csv出力php
|
16
16
|
|
@@ -18,96 +18,76 @@
|
|
18
18
|
|
19
19
|
テーブル table_hikitsugi
|
20
20
|
|
21
|
-
|
21
|
+
*/
|
22
22
|
|
23
|
-
|
23
|
+
//CSVのファイル名・ヘッダー名を定義
|
24
|
+
|
25
|
+
$file_path = "customer.csv";
|
26
|
+
|
27
|
+
$export_csv_title = ["ID", "月", "日", "内容", "担当", "カテゴリ", "進行状況"];
|
28
|
+
|
29
|
+
$export_sql = "SELECT id, month,day,naiyou,tantou,category,shinkou FROM table_hikitsugi";
|
24
30
|
|
25
31
|
|
26
32
|
|
27
|
-
|
33
|
+
//データベースに接続する
|
28
34
|
|
29
|
-
|
35
|
+
require_once 'db_config.php';
|
30
36
|
|
31
|
-
|
37
|
+
$dbh = new PDO('mysql:host=localhost;dbname=hikitsugi_db1;charset=utf8', $user, $pass);
|
38
|
+
|
39
|
+
$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
|
40
|
+
|
41
|
+
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
32
42
|
|
33
43
|
|
34
44
|
|
45
|
+
// 文字コードをSJIS-winにエンコード
|
35
46
|
|
47
|
+
foreach ($export_csv_title as $key => $val) {
|
36
48
|
|
37
|
-
//データベースに接続する
|
38
|
-
|
39
|
-
|
40
|
-
|
41
|
-
|
42
|
-
|
43
|
-
require_once 'db_config.php';
|
44
|
-
|
45
|
-
$dbh = new PDO('mysql:host=localhost;dbname=hikitsugi_db1;charset=utf8', $user, $pass);
|
46
|
-
|
47
|
-
$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
|
48
|
-
|
49
|
-
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
50
|
-
|
51
|
-
|
52
|
-
|
53
|
-
|
54
|
-
|
55
|
-
|
56
|
-
|
57
|
-
// 文字コードをSJIS-winにエンコード
|
58
|
-
|
59
|
-
foreach( $export_csv_title as $key => $val ){
|
60
|
-
|
61
|
-
|
62
|
-
|
63
|
-
|
49
|
+
$export_header[] = mb_convert_encoding($val, 'SJIS-win', 'UTF-8');
|
64
|
-
|
65
|
-
}
|
66
|
-
|
67
|
-
|
68
|
-
|
69
|
-
//CSV書き込み出力
|
70
|
-
|
71
|
-
|
72
|
-
|
73
|
-
if(touch($file_path)){
|
74
|
-
|
75
|
-
$file = new SplFileObject($file_path, "w");
|
76
50
|
|
77
51
|
}
|
78
52
|
|
79
53
|
|
80
54
|
|
81
|
-
|
55
|
+
//CSV書き込み出力
|
82
56
|
|
83
|
-
|
57
|
+
if (touch($file_path)) {
|
58
|
+
|
59
|
+
$file = new SplFileObject($file_path, "w");
|
84
60
|
|
85
61
|
|
86
62
|
|
87
|
-
|
63
|
+
// write csv header
|
88
64
|
|
89
|
-
$sql = "SELECT * FROM table_hikitsugi";
|
90
|
-
|
91
|
-
|
65
|
+
$file->fputcsv($export_header);
|
92
66
|
|
93
67
|
|
94
68
|
|
95
|
-
|
69
|
+
// query database
|
96
70
|
|
97
|
-
|
71
|
+
$sql = "SELECT * FROM table_hikitsugi";
|
98
72
|
|
99
|
-
|
73
|
+
$stmt = $dbh->query($export_sql);
|
100
74
|
|
101
75
|
|
102
76
|
|
77
|
+
// create csv sentences
|
78
|
+
|
79
|
+
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
|
80
|
+
|
81
|
+
$file->fputcsv($row);
|
82
|
+
|
103
|
-
|
83
|
+
}
|
84
|
+
|
85
|
+
}
|
104
86
|
|
105
87
|
|
106
88
|
|
107
|
-
|
89
|
+
// close database connection
|
108
90
|
|
109
|
-
|
91
|
+
$dbh = null;
|
110
|
-
|
111
|
-
?>
|
112
92
|
|
113
93
|
```
|
2
指摘内容変更修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -74,6 +74,8 @@
|
|
74
74
|
|
75
75
|
$file = new SplFileObject($file_path, "w");
|
76
76
|
|
77
|
+
}
|
78
|
+
|
77
79
|
|
78
80
|
|
79
81
|
// write csv header
|
1
抜け箇所追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -84,9 +84,9 @@
|
|
84
84
|
|
85
85
|
// query database
|
86
86
|
|
87
|
-
|
87
|
+
$sql = "SELECT * FROM table_hikitsugi";
|
88
88
|
|
89
|
-
|
89
|
+
$stmt = $dbh->query($export_sql);
|
90
90
|
|
91
91
|
|
92
92
|
|