質問編集履歴

3

閉じる箇所変更

2018/06/27 08:11

投稿

uep3vjz9wp
uep3vjz9wp

スコア20

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
- //CSVのファイル名・ヘッダー名を定義
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
- $file_path = "customer.csv";
33
+ //データベースに接続する
28
34
 
29
- $export_csv_title = ["ID", "月", "日", "内容","担当","カテゴリ","進行状況"];
35
+ require_once 'db_config.php';
30
36
 
31
- $export_sql = "SELECT id, month,day,naiyou,tantou,category,shinkou FROM table_hikitsugi";
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
- $export_header[] = mb_convert_encoding($val, 'SJIS-win', 'UTF-8');
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
- // write csv header
55
+ //CSV書き込み出力
82
56
 
83
- $file->fputcsv($export_header);
57
+ if (touch($file_path)) {
58
+
59
+ $file = new SplFileObject($file_path, "w");
84
60
 
85
61
 
86
62
 
87
- // query database
63
+ // write csv header
88
64
 
89
- $sql = "SELECT * FROM table_hikitsugi";
90
-
91
- $stmt = $dbh->query($export_sql);
65
+ $file->fputcsv($export_header);
92
66
 
93
67
 
94
68
 
95
- // create csv sentences
69
+ // query database
96
70
 
97
- while($row = $stmt->fetch(PDO::FETCH_ASSOC)){
71
+ $sql = "SELECT * FROM table_hikitsugi";
98
72
 
99
- $file->fputcsv($row);
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
- // close database connection
89
+ // close database connection
108
90
 
109
- $dbh = null;
91
+ $dbh = null;
110
-
111
- ?>
112
92
 
113
93
  ```

2

指摘内容変更修正

2018/06/27 08:11

投稿

uep3vjz9wp
uep3vjz9wp

スコア20

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

抜け箇所追加

2018/06/27 07:04

投稿

uep3vjz9wp
uep3vjz9wp

スコア20

test CHANGED
File without changes
test CHANGED
@@ -84,9 +84,9 @@
84
84
 
85
85
  // query database
86
86
 
87
- $sql = "SELECT * FROM table_hikitsugi";
87
+ $sql = "SELECT * FROM table_hikitsugi";
88
88
 
89
- $stmt = $dbh->query($export_sql);
89
+ $stmt = $dbh->query($export_sql);
90
90
 
91
91
 
92
92