teratail
回答率
85.48%
質問するログイン新規登録
トップに関する質問php言語でデータベースに登録する方法？

編集履歴

質問編集履歴

7

シンタックス

2017/01/01 16:06

投稿

NaokiTatsumi
NaokiTatsumi

スコア7

test CHANGED
File without changes
test CHANGED
@@ -70,15 +70,21 @@
70
70
 
71
71
  ?>```
72
72
 
73
+
74
+
73
75
  htmlの部分に
74
76
 
75
77
 
76
78
 
77
79
 
78
80
 
79
- HTML
81
+ ```HTML
82
+
80
-
83
+ ```
84
+
85
+ ```
86
+
81
- ```<form action="exec.php" method="post">
87
+ <form action="exec.php" method="post">
82
88
 
83
89
  <input type="hidden" name="companyname" value="<?php echo $companyname; ?>">
84
90
 
@@ -150,76 +156,80 @@
150
156
 
151
157
  exec.php {
152
158
 
159
+ ```PHP
160
+
161
+
162
+
163
+
164
+
165
+ PHP
166
+
167
+ <?php
168
+
169
+ session_start();
170
+
171
+ if(empty($_SESSION["fudougiken"]) || $_SESSION["fudougiken"]!=1) exit();
172
+
173
+ // データベースへの接続初期化
174
+
175
+ mysql_connect("localhost","root","");
176
+
177
+ mysql_select_db("fudougiken");
178
+
179
+ mysql_query("set names utf8;");
180
+
181
+ if(empty($_POST["companyname"]) || empty($_POST["department"]) || empty($_POST["contactname"]) || empty($_POST["furiga"]) || empty($_POST["acsesss"]) || empty($_POST["pref"]) || empty($_POST["city"]) || empty($_POST["town"]) || empty($_POST["build"]) || empty($_POST["tell"]) || empty($_POST["fax"]) || empty($_POST["email"]) || empty($_POST["opinion"])) exit();
182
+
183
+ $companyname=mysql_real_escape_string($_POST["companyname"]);
184
+
185
+ $department=mysql_real_escape_string($_POST["department"]);
186
+
187
+ $contactname=mysql_real_escape_string($_POST["contactname"]);
188
+
189
+ $contactname=mysql_real_escape_string($_POST["furiga"]);
190
+
191
+ $contactname=mysql_real_escape_string($_POST["acsesss"]);
192
+
193
+ $contactname=mysql_real_escape_string($_POST["pref"]);
194
+
195
+ $contactname=mysql_real_escape_string($_POST["city"]);
196
+
197
+ $contactname=mysql_real_escape_string($_POST["town"]);
198
+
199
+ $contactname=mysql_real_escape_string($_POST["build"]);
200
+
201
+ $contactname=mysql_real_escape_string($_POST["tell"]);
202
+
203
+ $contactname=mysql_real_escape_string($_POST["fax"]);
204
+
205
+ $contactname=mysql_real_escape_string($_POST["email"]);
206
+
207
+ $contactname=mysql_real_escape_string($_POST["opinion"]);
208
+
209
+ $sql="insert into otoiawase(companyname,department,contactname,furiga,acsesss,pref,city,town,buile,tell,fax,email,opinion) values(\"".$companyname."\",\"".$department."\",\"".$contactname."\",\"".$furiga."\",\"".$acsesss."\",\"".$pref."\",\"".$city."\",\"".$town."\",\"".$build."\",\"".$tell."\",\"".$fax."\",\"".$femail."\",\"".$fopinion."\");";
210
+
211
+ $res=mysql_query($sql);
212
+
213
+ if($res){
214
+
215
+ $msg=1;
216
+
217
+ }else{
218
+
219
+ $msg=0;
220
+
221
+ }
222
+
223
+ header("Location:../fudougiken/finish.php?msg=".$msg);
224
+
225
+ exit();
226
+
227
+ ?>
228
+
229
+ }
230
+
153
231
  ```
154
232
 
155
- PHP
156
-
157
- <?php
158
-
159
- session_start();
160
-
161
- if(empty($_SESSION["fudougiken"]) || $_SESSION["fudougiken"]!=1) exit();
162
-
163
- // データベースへの接続初期化
164
-
165
- mysql_connect("localhost","root","");
166
-
167
- mysql_select_db("fudougiken");
168
-
169
- mysql_query("set names utf8;");
170
-
171
- if(empty($_POST["companyname"]) || empty($_POST["department"]) || empty($_POST["contactname"]) || empty($_POST["furiga"]) || empty($_POST["acsesss"]) || empty($_POST["pref"]) || empty($_POST["city"]) || empty($_POST["town"]) || empty($_POST["build"]) || empty($_POST["tell"]) || empty($_POST["fax"]) || empty($_POST["email"]) || empty($_POST["opinion"])) exit();
172
-
173
- $companyname=mysql_real_escape_string($_POST["companyname"]);
174
-
175
- $department=mysql_real_escape_string($_POST["department"]);
176
-
177
- $contactname=mysql_real_escape_string($_POST["contactname"]);
178
-
179
- $contactname=mysql_real_escape_string($_POST["furiga"]);
180
-
181
- $contactname=mysql_real_escape_string($_POST["acsesss"]);
182
-
183
- $contactname=mysql_real_escape_string($_POST["pref"]);
184
-
185
- $contactname=mysql_real_escape_string($_POST["city"]);
186
-
187
- $contactname=mysql_real_escape_string($_POST["town"]);
188
-
189
- $contactname=mysql_real_escape_string($_POST["build"]);
190
-
191
- $contactname=mysql_real_escape_string($_POST["tell"]);
192
-
193
- $contactname=mysql_real_escape_string($_POST["fax"]);
194
-
195
- $contactname=mysql_real_escape_string($_POST["email"]);
196
-
197
- $contactname=mysql_real_escape_string($_POST["opinion"]);
198
-
199
- $sql="insert into otoiawase(companyname,department,contactname,furiga,acsesss,pref,city,town,buile,tell,fax,email,opinion) values(\"".$companyname."\",\"".$department."\",\"".$contactname."\",\"".$furiga."\",\"".$acsesss."\",\"".$pref."\",\"".$city."\",\"".$town."\",\"".$build."\",\"".$tell."\",\"".$fax."\",\"".$femail."\",\"".$fopinion."\");";
200
-
201
- $res=mysql_query($sql);
202
-
203
- if($res){
204
-
205
- $msg=1;
206
-
207
- }else{
208
-
209
- $msg=0;
210
-
211
- }
212
-
213
- header("Location:../fudougiken/finish.php?msg=".$msg);
214
-
215
- exit();
216
-
217
- ?>
218
-
219
- }'****
220
-
221
- ```
222
-
223
233
  記載しています。
224
234
 
225
235
  ###試したこと

6

シンタックス

2017/01/01 16:06

投稿

NaokiTatsumi
NaokiTatsumi

スコア7

test CHANGED
File without changes
test CHANGED
@@ -74,9 +74,11 @@
74
74
 
75
75
 
76
76
 
77
+
78
+
77
- ```HTML
79
+ HTML
78
-
80
+
79
- <form action="exec.php" method="post">
81
+ ```<form action="exec.php" method="post">
80
82
 
81
83
  <input type="hidden" name="companyname" value="<?php echo $companyname; ?>">
82
84
 
@@ -148,7 +150,9 @@
148
150
 
149
151
  exec.php {
150
152
 
151
- ```PHP
153
+ ```
154
+
155
+ PHP
152
156
 
153
157
  <?php
154
158
 

5

シンタックス

2017/01/01 16:01

投稿

NaokiTatsumi
NaokiTatsumi

スコア7

test CHANGED
File without changes
test CHANGED
@@ -32,7 +32,7 @@
32
32
 
33
33
  'infoexec.php{
34
34
 
35
- ```<?php
35
+ ```PHP<?php
36
36
 
37
37
  session_start();
38
38
 
@@ -72,9 +72,9 @@
72
72
 
73
73
  htmlの部分に
74
74
 
75
- ```
75
+
76
-
76
+
77
- HTML
77
+ ```HTML
78
78
 
79
79
  <form action="exec.php" method="post">
80
80
 
@@ -140,80 +140,82 @@
140
140
 
141
141
  </form>
142
142
 
143
+ }
144
+
143
- }```
145
+ ```
144
146
 
145
147
 
146
148
 
147
149
  exec.php {
148
150
 
151
+ ```PHP
152
+
153
+ <?php
154
+
155
+ session_start();
156
+
157
+ if(empty($_SESSION["fudougiken"]) || $_SESSION["fudougiken"]!=1) exit();
158
+
159
+ // データベースへの接続初期化
160
+
161
+ mysql_connect("localhost","root","");
162
+
163
+ mysql_select_db("fudougiken");
164
+
165
+ mysql_query("set names utf8;");
166
+
167
+ if(empty($_POST["companyname"]) || empty($_POST["department"]) || empty($_POST["contactname"]) || empty($_POST["furiga"]) || empty($_POST["acsesss"]) || empty($_POST["pref"]) || empty($_POST["city"]) || empty($_POST["town"]) || empty($_POST["build"]) || empty($_POST["tell"]) || empty($_POST["fax"]) || empty($_POST["email"]) || empty($_POST["opinion"])) exit();
168
+
169
+ $companyname=mysql_real_escape_string($_POST["companyname"]);
170
+
171
+ $department=mysql_real_escape_string($_POST["department"]);
172
+
173
+ $contactname=mysql_real_escape_string($_POST["contactname"]);
174
+
175
+ $contactname=mysql_real_escape_string($_POST["furiga"]);
176
+
177
+ $contactname=mysql_real_escape_string($_POST["acsesss"]);
178
+
179
+ $contactname=mysql_real_escape_string($_POST["pref"]);
180
+
181
+ $contactname=mysql_real_escape_string($_POST["city"]);
182
+
183
+ $contactname=mysql_real_escape_string($_POST["town"]);
184
+
185
+ $contactname=mysql_real_escape_string($_POST["build"]);
186
+
187
+ $contactname=mysql_real_escape_string($_POST["tell"]);
188
+
189
+ $contactname=mysql_real_escape_string($_POST["fax"]);
190
+
191
+ $contactname=mysql_real_escape_string($_POST["email"]);
192
+
193
+ $contactname=mysql_real_escape_string($_POST["opinion"]);
194
+
195
+ $sql="insert into otoiawase(companyname,department,contactname,furiga,acsesss,pref,city,town,buile,tell,fax,email,opinion) values(\"".$companyname."\",\"".$department."\",\"".$contactname."\",\"".$furiga."\",\"".$acsesss."\",\"".$pref."\",\"".$city."\",\"".$town."\",\"".$build."\",\"".$tell."\",\"".$fax."\",\"".$femail."\",\"".$fopinion."\");";
196
+
197
+ $res=mysql_query($sql);
198
+
199
+ if($res){
200
+
201
+ $msg=1;
202
+
203
+ }else{
204
+
205
+ $msg=0;
206
+
207
+ }
208
+
209
+ header("Location:../fudougiken/finish.php?msg=".$msg);
210
+
211
+ exit();
212
+
213
+ ?>
214
+
215
+ }'****
216
+
149
217
  ```
150
218
 
151
- <?php
152
-
153
- session_start();
154
-
155
- if(empty($_SESSION["fudougiken"]) || $_SESSION["fudougiken"]!=1) exit();
156
-
157
- // データベースへの接続初期化
158
-
159
- mysql_connect("localhost","root","");
160
-
161
- mysql_select_db("fudougiken");
162
-
163
- mysql_query("set names utf8;");
164
-
165
- if(empty($_POST["companyname"]) || empty($_POST["department"]) || empty($_POST["contactname"]) || empty($_POST["furiga"]) || empty($_POST["acsesss"]) || empty($_POST["pref"]) || empty($_POST["city"]) || empty($_POST["town"]) || empty($_POST["build"]) || empty($_POST["tell"]) || empty($_POST["fax"]) || empty($_POST["email"]) || empty($_POST["opinion"])) exit();
166
-
167
- $companyname=mysql_real_escape_string($_POST["companyname"]);
168
-
169
- $department=mysql_real_escape_string($_POST["department"]);
170
-
171
- $contactname=mysql_real_escape_string($_POST["contactname"]);
172
-
173
- $contactname=mysql_real_escape_string($_POST["furiga"]);
174
-
175
- $contactname=mysql_real_escape_string($_POST["acsesss"]);
176
-
177
- $contactname=mysql_real_escape_string($_POST["pref"]);
178
-
179
- $contactname=mysql_real_escape_string($_POST["city"]);
180
-
181
- $contactname=mysql_real_escape_string($_POST["town"]);
182
-
183
- $contactname=mysql_real_escape_string($_POST["build"]);
184
-
185
- $contactname=mysql_real_escape_string($_POST["tell"]);
186
-
187
- $contactname=mysql_real_escape_string($_POST["fax"]);
188
-
189
- $contactname=mysql_real_escape_string($_POST["email"]);
190
-
191
- $contactname=mysql_real_escape_string($_POST["opinion"]);
192
-
193
- $sql="insert into otoiawase(companyname,department,contactname,furiga,acsesss,pref,city,town,buile,tell,fax,email,opinion) values(\"".$companyname."\",\"".$department."\",\"".$contactname."\",\"".$furiga."\",\"".$acsesss."\",\"".$pref."\",\"".$city."\",\"".$town."\",\"".$build."\",\"".$tell."\",\"".$fax."\",\"".$femail."\",\"".$fopinion."\");";
194
-
195
- $res=mysql_query($sql);
196
-
197
- if($res){
198
-
199
- $msg=1;
200
-
201
- }else{
202
-
203
- $msg=0;
204
-
205
- }
206
-
207
- header("Location:../fudougiken/finish.php?msg=".$msg);
208
-
209
- exit();
210
-
211
- ?>
212
-
213
- }'****
214
-
215
- ```
216
-
217
219
  記載しています。
218
220
 
219
221
  ###試したこと

4

シンタックス

2017/01/01 15:59

投稿

NaokiTatsumi
NaokiTatsumi

スコア7

test CHANGED
File without changes
test CHANGED
@@ -28,182 +28,188 @@
28
28
 
29
29
  ###該当のソースコード
30
30
 
31
+
32
+
33
+ 'infoexec.php{
34
+
35
+ ```<?php
36
+
37
+ session_start();
38
+
39
+ $_SESSION["fudougiken"]=1;
40
+
41
+ $flag=false;
42
+
43
+ $companyname=htmls
44
+
45
+ pecialchars($_POST["companyname"],ENT_QUOTES);
46
+
47
+ $department=htmlspecialchars($_POST["department"],ENT_QUOTES);
48
+
49
+ empty($_POST["contactname"]) ? $flag=true : $contactname=htmlspecialchars($_POST["contactname"],ENT_QUOTES);
50
+
51
+ empty($_POST["furiga"]) ? $flag=true : $furiga=htmlspecialchars($_POST["furiga"],ENT_QUOTES);
52
+
53
+ $acsesss=htmlspecialchars($_POST["acsesss"],ENT_QUOTES);
54
+
55
+ empty($_POST["pref"]) ? $flag=true : $pref=htmlspecialchars($_POST["pref"],ENT_QUOTES);
56
+
57
+ empty($_POST["city"]) ? $flag=true : $city=htmlspecialchars($_POST["city"],ENT_QUOTES);
58
+
59
+ empty($_POST["town"]) ? $flag=true : $town=htmlspecialchars($_POST["town"],ENT_QUOTES);
60
+
61
+ $build=htmlspecialchars($_POST["build"],ENT_QUOTES);
62
+
63
+ $tell=htmlspecialchars($_POST["tell"],ENT_QUOTES);
64
+
65
+ $fax=htmlspecialchars($_POST["fax"],ENT_QUOTES);
66
+
67
+ empty($_POST["email"]) ? $flag=true : $email=htmlspecialchars($_POST["email"],ENT_QUOTES);
68
+
69
+ empty($_POST["opinion"]) ? $flag=true : $opinion=htmlspecialchars($_POST["opinion"],ENT_QUOTES);
70
+
71
+ ?>```
72
+
73
+ htmlの部分に
74
+
75
+ ```
76
+
77
+ HTML
78
+
79
+ <form action="exec.php" method="post">
80
+
81
+ <input type="hidden" name="companyname" value="<?php echo $companyname; ?>">
82
+
83
+ <input type="hidden" name="department" value="<?php echo $department; ?>">
84
+
85
+ <input type="hidden" name="contactname" value="<?php echo $contactname; ?>">
86
+
87
+ <input type="hidden" name="furiga" value="<?php echo $furiga; ?>">
88
+
89
+ <input type="hidden" name="acsesss" value="<?php echo $acsesss; ?>">
90
+
91
+ <input type="hidden" name="pref" value="<?php echo $pref; ?>">
92
+
93
+ <input type="hidden" name="city" value="<?php echo $city; ?>">
94
+
95
+ <input type="hidden" name="town" value="<?php echo $town; ?>">
96
+
97
+ <input type="hidden" name="build" value="<?php echo $build; ?>">
98
+
99
+ <input type="hidden" name="tell" value="<?php echo $tell; ?>">
100
+
101
+ <input type="hidden" name="fax" value="<?php echo $fax; ?>">
102
+
103
+ <input type="hidden" name="email" value="<?php echo $email; ?>">
104
+
105
+ <input type="hidden" name="opinion" value="<?php echo $opinion; ?>">
106
+
107
+ <input type="submit" name="sub1" value="送信する">
108
+
109
+ </form>
110
+
111
+ <form action="info.php" method="post">
112
+
113
+ <input type="hidden" name="companyname" value="<?php echo $companyname; ?>">
114
+
115
+ <input type="hidden" name="department" value="<?php echo $department; ?>">
116
+
117
+ <input type="hidden" name="contactname" value="<?php echo $contactname; ?>">
118
+
119
+ <input type="hidden" name="furiga" value="<?php echo $furiga; ?>">
120
+
121
+ <input type="hidden" name="acsesss" value="<?php echo $acsesss; ?>">
122
+
123
+ <input type="hidden" name="pref" value="<?php echo $pref; ?>">
124
+
125
+ <input type="hidden" name="city" value="<?php echo $city; ?>">
126
+
127
+ <input type="hidden" name="town" value="<?php echo $town; ?>">
128
+
129
+ <input type="hidden" name="build" value="<?php echo $build; ?>">
130
+
131
+ <input type="hidden" name="tell" value="<?php echo $tell; ?>">
132
+
133
+ <input type="hidden" name="fax" value="<?php echo $fax; ?>">
134
+
135
+ <input type="hidden" name="email" value="<?php echo $email; ?>">
136
+
137
+ <input type="hidden" name="opinion" value="<?php echo $opinion; ?>">
138
+
139
+ <input type="submit" name="sub1" value="修正する">
140
+
141
+ </form>
142
+
143
+ }```
144
+
145
+
146
+
147
+ exec.php {
148
+
31
149
  ```
32
150
 
33
- 'infoexec.php{
34
-
35
151
  <?php
36
152
 
37
153
  session_start();
38
154
 
39
- $_SESSION["fudougiken"]=1;
40
-
41
- $flag=false;
42
-
43
- $companyname=htmls
44
-
45
- pecialchars($_POST["companyname"],ENT_QUOTES);
46
-
47
- $department=htmlspecialchars($_POST["department"],ENT_QUOTES);
48
-
49
- empty($_POST["contactname"]) ? $flag=true : $contactname=htmlspecialchars($_POST["contactname"],ENT_QUOTES);
50
-
51
- empty($_POST["furiga"]) ? $flag=true : $furiga=htmlspecialchars($_POST["furiga"],ENT_QUOTES);
52
-
53
- $acsesss=htmlspecialchars($_POST["acsesss"],ENT_QUOTES);
54
-
55
- empty($_POST["pref"]) ? $flag=true : $pref=htmlspecialchars($_POST["pref"],ENT_QUOTES);
56
-
57
- empty($_POST["city"]) ? $flag=true : $city=htmlspecialchars($_POST["city"],ENT_QUOTES);
58
-
59
- empty($_POST["town"]) ? $flag=true : $town=htmlspecialchars($_POST["town"],ENT_QUOTES);
60
-
61
- $build=htmlspecialchars($_POST["build"],ENT_QUOTES);
62
-
63
- $tell=htmlspecialchars($_POST["tell"],ENT_QUOTES);
64
-
65
- $fax=htmlspecialchars($_POST["fax"],ENT_QUOTES);
66
-
67
- empty($_POST["email"]) ? $flag=true : $email=htmlspecialchars($_POST["email"],ENT_QUOTES);
68
-
69
- empty($_POST["opinion"]) ? $flag=true : $opinion=htmlspecialchars($_POST["opinion"],ENT_QUOTES);
155
+ if(empty($_SESSION["fudougiken"]) || $_SESSION["fudougiken"]!=1) exit();
156
+
157
+ // データベースへの接続初期化
158
+
159
+ mysql_connect("localhost","root","");
160
+
161
+ mysql_select_db("fudougiken");
162
+
163
+ mysql_query("set names utf8;");
164
+
165
+ if(empty($_POST["companyname"]) || empty($_POST["department"]) || empty($_POST["contactname"]) || empty($_POST["furiga"]) || empty($_POST["acsesss"]) || empty($_POST["pref"]) || empty($_POST["city"]) || empty($_POST["town"]) || empty($_POST["build"]) || empty($_POST["tell"]) || empty($_POST["fax"]) || empty($_POST["email"]) || empty($_POST["opinion"])) exit();
166
+
167
+ $companyname=mysql_real_escape_string($_POST["companyname"]);
168
+
169
+ $department=mysql_real_escape_string($_POST["department"]);
170
+
171
+ $contactname=mysql_real_escape_string($_POST["contactname"]);
172
+
173
+ $contactname=mysql_real_escape_string($_POST["furiga"]);
174
+
175
+ $contactname=mysql_real_escape_string($_POST["acsesss"]);
176
+
177
+ $contactname=mysql_real_escape_string($_POST["pref"]);
178
+
179
+ $contactname=mysql_real_escape_string($_POST["city"]);
180
+
181
+ $contactname=mysql_real_escape_string($_POST["town"]);
182
+
183
+ $contactname=mysql_real_escape_string($_POST["build"]);
184
+
185
+ $contactname=mysql_real_escape_string($_POST["tell"]);
186
+
187
+ $contactname=mysql_real_escape_string($_POST["fax"]);
188
+
189
+ $contactname=mysql_real_escape_string($_POST["email"]);
190
+
191
+ $contactname=mysql_real_escape_string($_POST["opinion"]);
192
+
193
+ $sql="insert into otoiawase(companyname,department,contactname,furiga,acsesss,pref,city,town,buile,tell,fax,email,opinion) values(\"".$companyname."\",\"".$department."\",\"".$contactname."\",\"".$furiga."\",\"".$acsesss."\",\"".$pref."\",\"".$city."\",\"".$town."\",\"".$build."\",\"".$tell."\",\"".$fax."\",\"".$femail."\",\"".$fopinion."\");";
194
+
195
+ $res=mysql_query($sql);
196
+
197
+ if($res){
198
+
199
+ $msg=1;
200
+
201
+ }else{
202
+
203
+ $msg=0;
204
+
205
+ }
206
+
207
+ header("Location:../fudougiken/finish.php?msg=".$msg);
208
+
209
+ exit();
70
210
 
71
211
  ?>
72
212
 
73
- htmlの部分に
74
-
75
- <form action="exec.php" method="post">
76
-
77
- <input type="hidden" name="companyname" value="<?php echo $companyname; ?>">
78
-
79
- <input type="hidden" name="department" value="<?php echo $department; ?>">
80
-
81
- <input type="hidden" name="contactname" value="<?php echo $contactname; ?>">
82
-
83
- <input type="hidden" name="furiga" value="<?php echo $furiga; ?>">
84
-
85
- <input type="hidden" name="acsesss" value="<?php echo $acsesss; ?>">
86
-
87
- <input type="hidden" name="pref" value="<?php echo $pref; ?>">
88
-
89
- <input type="hidden" name="city" value="<?php echo $city; ?>">
90
-
91
- <input type="hidden" name="town" value="<?php echo $town; ?>">
92
-
93
- <input type="hidden" name="build" value="<?php echo $build; ?>">
94
-
95
- <input type="hidden" name="tell" value="<?php echo $tell; ?>">
96
-
97
- <input type="hidden" name="fax" value="<?php echo $fax; ?>">
98
-
99
- <input type="hidden" name="email" value="<?php echo $email; ?>">
100
-
101
- <input type="hidden" name="opinion" value="<?php echo $opinion; ?>">
102
-
103
- <input type="submit" name="sub1" value="送信する">
104
-
105
- </form>
106
-
107
- <form action="info.php" method="post">
108
-
109
- <input type="hidden" name="companyname" value="<?php echo $companyname; ?>">
110
-
111
- <input type="hidden" name="department" value="<?php echo $department; ?>">
112
-
113
- <input type="hidden" name="contactname" value="<?php echo $contactname; ?>">
114
-
115
- <input type="hidden" name="furiga" value="<?php echo $furiga; ?>">
116
-
117
- <input type="hidden" name="acsesss" value="<?php echo $acsesss; ?>">
118
-
119
- <input type="hidden" name="pref" value="<?php echo $pref; ?>">
120
-
121
- <input type="hidden" name="city" value="<?php echo $city; ?>">
122
-
123
- <input type="hidden" name="town" value="<?php echo $town; ?>">
124
-
125
- <input type="hidden" name="build" value="<?php echo $build; ?>">
126
-
127
- <input type="hidden" name="tell" value="<?php echo $tell; ?>">
128
-
129
- <input type="hidden" name="fax" value="<?php echo $fax; ?>">
130
-
131
- <input type="hidden" name="email" value="<?php echo $email; ?>">
132
-
133
- <input type="hidden" name="opinion" value="<?php echo $opinion; ?>">
134
-
135
- <input type="submit" name="sub1" value="修正する">
136
-
137
- </form>
138
-
139
- }
140
-
141
-
142
-
143
- exec.php {
144
-
145
- <?php
146
-
147
- session_start();
148
-
149
- if(empty($_SESSION["fudougiken"]) || $_SESSION["fudougiken"]!=1) exit();
150
-
151
- // データベースへの接続初期化
152
-
153
- mysql_connect("localhost","root","");
154
-
155
- mysql_select_db("fudougiken");
156
-
157
- mysql_query("set names utf8;");
158
-
159
- if(empty($_POST["companyname"]) || empty($_POST["department"]) || empty($_POST["contactname"]) || empty($_POST["furiga"]) || empty($_POST["acsesss"]) || empty($_POST["pref"]) || empty($_POST["city"]) || empty($_POST["town"]) || empty($_POST["build"]) || empty($_POST["tell"]) || empty($_POST["fax"]) || empty($_POST["email"]) || empty($_POST["opinion"])) exit();
160
-
161
- $companyname=mysql_real_escape_string($_POST["companyname"]);
162
-
163
- $department=mysql_real_escape_string($_POST["department"]);
164
-
165
- $contactname=mysql_real_escape_string($_POST["contactname"]);
166
-
167
- $contactname=mysql_real_escape_string($_POST["furiga"]);
168
-
169
- $contactname=mysql_real_escape_string($_POST["acsesss"]);
170
-
171
- $contactname=mysql_real_escape_string($_POST["pref"]);
172
-
173
- $contactname=mysql_real_escape_string($_POST["city"]);
174
-
175
- $contactname=mysql_real_escape_string($_POST["town"]);
176
-
177
- $contactname=mysql_real_escape_string($_POST["build"]);
178
-
179
- $contactname=mysql_real_escape_string($_POST["tell"]);
180
-
181
- $contactname=mysql_real_escape_string($_POST["fax"]);
182
-
183
- $contactname=mysql_real_escape_string($_POST["email"]);
184
-
185
- $contactname=mysql_real_escape_string($_POST["opinion"]);
186
-
187
- $sql="insert into otoiawase(companyname,department,contactname,furiga,acsesss,pref,city,town,buile,tell,fax,email,opinion) values(\"".$companyname."\",\"".$department."\",\"".$contactname."\",\"".$furiga."\",\"".$acsesss."\",\"".$pref."\",\"".$city."\",\"".$town."\",\"".$build."\",\"".$tell."\",\"".$fax."\",\"".$femail."\",\"".$fopinion."\");";
188
-
189
- $res=mysql_query($sql);
190
-
191
- if($res){
192
-
193
- $msg=1;
194
-
195
- }else{
196
-
197
- $msg=0;
198
-
199
- }
200
-
201
- header("Location:../fudougiken/finish.php?msg=".$msg);
202
-
203
- exit();
204
-
205
- ?>
206
-
207
213
  }'****
208
214
 
209
215
  ```

3

シンタックス機能

2017/01/01 15:57

投稿

NaokiTatsumi
NaokiTatsumi

スコア7

test CHANGED
File without changes
test CHANGED
@@ -40,178 +40,174 @@
40
40
 
41
41
  $flag=false;
42
42
 
43
+ $companyname=htmls
44
+
45
+ pecialchars($_POST["companyname"],ENT_QUOTES);
46
+
47
+ $department=htmlspecialchars($_POST["department"],ENT_QUOTES);
48
+
49
+ empty($_POST["contactname"]) ? $flag=true : $contactname=htmlspecialchars($_POST["contactname"],ENT_QUOTES);
50
+
51
+ empty($_POST["furiga"]) ? $flag=true : $furiga=htmlspecialchars($_POST["furiga"],ENT_QUOTES);
52
+
53
+ $acsesss=htmlspecialchars($_POST["acsesss"],ENT_QUOTES);
54
+
55
+ empty($_POST["pref"]) ? $flag=true : $pref=htmlspecialchars($_POST["pref"],ENT_QUOTES);
56
+
57
+ empty($_POST["city"]) ? $flag=true : $city=htmlspecialchars($_POST["city"],ENT_QUOTES);
58
+
59
+ empty($_POST["town"]) ? $flag=true : $town=htmlspecialchars($_POST["town"],ENT_QUOTES);
60
+
61
+ $build=htmlspecialchars($_POST["build"],ENT_QUOTES);
62
+
63
+ $tell=htmlspecialchars($_POST["tell"],ENT_QUOTES);
64
+
65
+ $fax=htmlspecialchars($_POST["fax"],ENT_QUOTES);
66
+
67
+ empty($_POST["email"]) ? $flag=true : $email=htmlspecialchars($_POST["email"],ENT_QUOTES);
68
+
69
+ empty($_POST["opinion"]) ? $flag=true : $opinion=htmlspecialchars($_POST["opinion"],ENT_QUOTES);
70
+
71
+ ?>
72
+
73
+ htmlの部分に
74
+
75
+ <form action="exec.php" method="post">
76
+
77
+ <input type="hidden" name="companyname" value="<?php echo $companyname; ?>">
78
+
79
+ <input type="hidden" name="department" value="<?php echo $department; ?>">
80
+
81
+ <input type="hidden" name="contactname" value="<?php echo $contactname; ?>">
82
+
83
+ <input type="hidden" name="furiga" value="<?php echo $furiga; ?>">
84
+
85
+ <input type="hidden" name="acsesss" value="<?php echo $acsesss; ?>">
86
+
87
+ <input type="hidden" name="pref" value="<?php echo $pref; ?>">
88
+
89
+ <input type="hidden" name="city" value="<?php echo $city; ?>">
90
+
91
+ <input type="hidden" name="town" value="<?php echo $town; ?>">
92
+
93
+ <input type="hidden" name="build" value="<?php echo $build; ?>">
94
+
95
+ <input type="hidden" name="tell" value="<?php echo $tell; ?>">
96
+
97
+ <input type="hidden" name="fax" value="<?php echo $fax; ?>">
98
+
99
+ <input type="hidden" name="email" value="<?php echo $email; ?>">
100
+
101
+ <input type="hidden" name="opinion" value="<?php echo $opinion; ?>">
102
+
103
+ <input type="submit" name="sub1" value="送信する">
104
+
105
+ </form>
106
+
107
+ <form action="info.php" method="post">
108
+
109
+ <input type="hidden" name="companyname" value="<?php echo $companyname; ?>">
110
+
111
+ <input type="hidden" name="department" value="<?php echo $department; ?>">
112
+
113
+ <input type="hidden" name="contactname" value="<?php echo $contactname; ?>">
114
+
115
+ <input type="hidden" name="furiga" value="<?php echo $furiga; ?>">
116
+
117
+ <input type="hidden" name="acsesss" value="<?php echo $acsesss; ?>">
118
+
119
+ <input type="hidden" name="pref" value="<?php echo $pref; ?>">
120
+
121
+ <input type="hidden" name="city" value="<?php echo $city; ?>">
122
+
123
+ <input type="hidden" name="town" value="<?php echo $town; ?>">
124
+
125
+ <input type="hidden" name="build" value="<?php echo $build; ?>">
126
+
127
+ <input type="hidden" name="tell" value="<?php echo $tell; ?>">
128
+
129
+ <input type="hidden" name="fax" value="<?php echo $fax; ?>">
130
+
131
+ <input type="hidden" name="email" value="<?php echo $email; ?>">
132
+
133
+ <input type="hidden" name="opinion" value="<?php echo $opinion; ?>">
134
+
135
+ <input type="submit" name="sub1" value="修正する">
136
+
137
+ </form>
138
+
139
+ }
140
+
141
+
142
+
143
+ exec.php {
144
+
145
+ <?php
146
+
147
+ session_start();
148
+
149
+ if(empty($_SESSION["fudougiken"]) || $_SESSION["fudougiken"]!=1) exit();
150
+
151
+ // データベースへの接続初期化
152
+
153
+ mysql_connect("localhost","root","");
154
+
155
+ mysql_select_db("fudougiken");
156
+
157
+ mysql_query("set names utf8;");
158
+
159
+ if(empty($_POST["companyname"]) || empty($_POST["department"]) || empty($_POST["contactname"]) || empty($_POST["furiga"]) || empty($_POST["acsesss"]) || empty($_POST["pref"]) || empty($_POST["city"]) || empty($_POST["town"]) || empty($_POST["build"]) || empty($_POST["tell"]) || empty($_POST["fax"]) || empty($_POST["email"]) || empty($_POST["opinion"])) exit();
160
+
161
+ $companyname=mysql_real_escape_string($_POST["companyname"]);
162
+
163
+ $department=mysql_real_escape_string($_POST["department"]);
164
+
165
+ $contactname=mysql_real_escape_string($_POST["contactname"]);
166
+
167
+ $contactname=mysql_real_escape_string($_POST["furiga"]);
168
+
169
+ $contactname=mysql_real_escape_string($_POST["acsesss"]);
170
+
171
+ $contactname=mysql_real_escape_string($_POST["pref"]);
172
+
173
+ $contactname=mysql_real_escape_string($_POST["city"]);
174
+
175
+ $contactname=mysql_real_escape_string($_POST["town"]);
176
+
177
+ $contactname=mysql_real_escape_string($_POST["build"]);
178
+
179
+ $contactname=mysql_real_escape_string($_POST["tell"]);
180
+
181
+ $contactname=mysql_real_escape_string($_POST["fax"]);
182
+
183
+ $contactname=mysql_real_escape_string($_POST["email"]);
184
+
185
+ $contactname=mysql_real_escape_string($_POST["opinion"]);
186
+
187
+ $sql="insert into otoiawase(companyname,department,contactname,furiga,acsesss,pref,city,town,buile,tell,fax,email,opinion) values(\"".$companyname."\",\"".$department."\",\"".$contactname."\",\"".$furiga."\",\"".$acsesss."\",\"".$pref."\",\"".$city."\",\"".$town."\",\"".$build."\",\"".$tell."\",\"".$fax."\",\"".$femail."\",\"".$fopinion."\");";
188
+
189
+ $res=mysql_query($sql);
190
+
191
+ if($res){
192
+
193
+ $msg=1;
194
+
195
+ }else{
196
+
197
+ $msg=0;
198
+
199
+ }
200
+
201
+ header("Location:../fudougiken/finish.php?msg=".$msg);
202
+
203
+ exit();
204
+
205
+ ?>
206
+
207
+ }'****
208
+
43
209
  ```
44
210
 
45
- $companyname=htmls
46
-
47
- ```pecialchars($_POST["companyname"],ENT_QUOTES);
48
-
49
- $department=htmlspecialchars($_POST["department"],ENT_QUOTES);
50
-
51
- empty($_POST["contactname"]) ? $flag=true : $contactname=htmlspecialchars($_POST["contactname"],ENT_QUOTES);
52
-
53
- empty($_POST["furiga"]) ? $flag=true : $furiga=htmlspecialchars($_POST["furiga"],ENT_QUOTES);
54
-
55
- $acsesss=htmlspecialchars($_POST["acsesss"],ENT_QUOTES);
56
-
57
- empty($_POST["pref"]) ? $flag=true : $pref=htmlspecialchars($_POST["pref"],ENT_QUOTES);
58
-
59
- empty($_POST["city"]) ? $flag=true : $city=htmlspecialchars($_POST["city"],ENT_QUOTES);
60
-
61
- empty($_POST["town"]) ? $flag=true : $town=htmlspecialchars($_POST["town"],ENT_QUOTES);
62
-
63
- $build=htmlspecialchars($_POST["build"],ENT_QUOTES);
64
-
65
- $tell=htmlspecialchars($_POST["tell"],ENT_QUOTES);
66
-
67
- $fax=htmlspecialchars($_POST["fax"],ENT_QUOTES);
68
-
69
- empty($_POST["email"]) ? $flag=true : $email=htmlspecialchars($_POST["email"],ENT_QUOTES);
70
-
71
- empty($_POST["opinion"]) ? $flag=true : $opinion=htmlspecialchars($_POST["opinion"],ENT_QUOTES);
72
-
73
- ?>
74
-
75
- htmlの部分に
76
-
77
- <form action="exec.php" method="post">
78
-
79
- <input type="hidden" name="companyname" value="<?php echo $companyname; ?>">
80
-
81
- <input type="hidden" name="department" value="<?php echo $department; ?>">
82
-
83
- <input type="hidden" name="contactname" value="<?php echo $contactname; ?>">
84
-
85
- <input type="hidden" name="furiga" value="<?php echo $furiga; ?>">
86
-
87
- <input type="hidden" name="acsesss" value="<?php echo $acsesss; ?>">
88
-
89
- <input type="hidden" name="pref" value="<?php echo $pref; ?>">
90
-
91
- <input type="hidden" name="city" value="<?php echo $city; ?>">
92
-
93
- <input type="hidden" name="town" value="<?php echo $town; ?>">
94
-
95
- <input type="hidden" name="build" value="<?php echo $build; ?>">
96
-
97
- <input type="hidden" name="tell" value="<?php echo $tell; ?>">
98
-
99
- <input type="hidden" name="fax" value="<?php echo $fax; ?>">
100
-
101
- <input type="hidden" name="email" value="<?php echo $email; ?>">
102
-
103
- <input type="hidden" name="opinion" value="<?php echo $opinion; ?>">
104
-
105
- <input type="submit" name="sub1" value="送信する">
106
-
107
- </form>
108
-
109
- <form action="info.php" method="post">
110
-
111
- <input type="hidden" name="companyname" value="<?php echo $companyname; ?>">
112
-
113
- <input type="hidden" name="department" value="<?php echo $department; ?>">
114
-
115
- <input type="hidden" name="contactname" value="<?php echo $contactname; ?>">
116
-
117
- <input type="hidden" name="furiga" value="<?php echo $furiga; ?>">
118
-
119
- <input type="hidden" name="acsesss" value="<?php echo $acsesss; ?>">
120
-
121
- <input type="hidden" name="pref" value="<?php echo $pref; ?>">
122
-
123
- <input type="hidden" name="city" value="<?php echo $city; ?>">
124
-
125
- <input type="hidden" name="town" value="<?php echo $town; ?>">
126
-
127
- <input type="hidden" name="build" value="<?php echo $build; ?>">
128
-
129
- <input type="hidden" name="tell" value="<?php echo $tell; ?>">
130
-
131
- <input type="hidden" name="fax" value="<?php echo $fax; ?>">
132
-
133
- <input type="hidden" name="email" value="<?php echo $email; ?>">
134
-
135
- <input type="hidden" name="opinion" value="<?php echo $opinion; ?>">
136
-
137
- <input type="submit" name="sub1" value="修正する">
138
-
139
- </form>
140
-
141
- }
142
-
143
-
144
-
145
- exec.php {
146
-
147
- <?php
148
-
149
- session_start();
150
-
151
- if(empty($_SESSION["fudougiken"]) || $_SESSION["fudougiken"]!=1) exit();
152
-
153
- // データベースへの接続初期化
154
-
155
- mysql_connect("localhost","root","");
156
-
157
- mysql_select_db("fudougiken");
158
-
159
- mysql_query("set names utf8;");
160
-
161
- if(empty($_POST["companyname"]) || empty($_POST["department"]) || empty($_POST["contactname"]) || empty($_POST["furiga"]) || empty($_POST["acsesss"]) || empty($_POST["pref"]) || empty($_POST["city"]) || empty($_POST["town"]) || empty($_POST["build"]) || empty($_POST["tell"]) || empty($_POST["fax"]) || empty($_POST["email"]) || empty($_POST["opinion"])) exit();
162
-
163
- $companyname=mysql_real_escape_string($_POST["companyname"]);
164
-
165
- $department=mysql_real_escape_string($_POST["department"]);
166
-
167
- $contactname=mysql_real_escape_string($_POST["contactname"]);
168
-
169
- $contactname=mysql_real_escape_string($_POST["furiga"]);
170
-
171
- $contactname=mysql_real_escape_string($_POST["acsesss"]);
172
-
173
- $contactname=mysql_real_escape_string($_POST["pref"]);
174
-
175
- $contactname=mysql_real_escape_string($_POST["city"]);
176
-
177
- $contactname=mysql_real_escape_string($_POST["town"]);
178
-
179
- $contactname=mysql_real_escape_string($_POST["build"]);
180
-
181
- $contactname=mysql_real_escape_string($_POST["tell"]);
182
-
183
- $contactname=mysql_real_escape_string($_POST["fax"]);
184
-
185
- $contactname=mysql_real_escape_string($_POST["email"]);
186
-
187
- $contactname=mysql_real_escape_string($_POST["opinion"]);
188
-
189
- $sql="insert into otoiawase(companyname,department,contactname,furiga,acsesss,pref,city,town,buile,tell,fax,email,opinion) values(\"".$companyname."\",\"".$department."\",\"".$contactname."\",\"".$furiga."\",\"".$acsesss."\",\"".$pref."\",\"".$city."\",\"".$town."\",\"".$build."\",\"".$tell."\",\"".$fax."\",\"".$femail."\",\"".$fopinion."\");";
190
-
191
- $res=mysql_query($sql);
192
-
193
- if($res){
194
-
195
- $msg=1;
196
-
197
- }else{
198
-
199
- $msg=0;
200
-
201
- }
202
-
203
- header("Location:../fudougiken/finish.php?msg=".$msg);
204
-
205
- exit();
206
-
207
- ?>
208
-
209
- }'****
210
-
211
- ```
212
-
213
- ```
214
-
215
211
  記載しています。
216
212
 
217
213
  ###試したこと

2

シンタックス機能

2017/01/01 15:05

投稿

NaokiTatsumi
NaokiTatsumi

スコア7

test CHANGED
File without changes
test CHANGED
@@ -28,7 +28,9 @@
28
28
 
29
29
  ###該当のソースコード
30
30
 
31
+ ```
32
+
31
- **###**'infoexec.php{
33
+ 'infoexec.php{
32
34
 
33
35
  <?php
34
36
 
@@ -38,7 +40,11 @@
38
40
 
39
41
  $flag=false;
40
42
 
43
+ ```
44
+
45
+ $companyname=htmls
46
+
41
- $companyname=htmlspecialchars($_POST["companyname"],ENT_QUOTES);
47
+ ```pecialchars($_POST["companyname"],ENT_QUOTES);
42
48
 
43
49
  $department=htmlspecialchars($_POST["department"],ENT_QUOTES);
44
50
 
@@ -202,6 +208,10 @@
202
208
 
203
209
  }'****
204
210
 
211
+ ```
212
+
213
+ ```
214
+
205
215
  記載しています。
206
216
 
207
217
  ###試したこと
@@ -269,3 +279,7 @@
269
279
 
270
280
 
271
281
  となっています。宜しく御願いします。
282
+
283
+
284
+
285
+ 後、こちらのサイトのヘルプを見ながらやりましたが、シンタックス機能での色変更ができません。どうしてでしょうか？

1

文字の色を変更

2017/01/01 15:03

投稿

NaokiTatsumi
NaokiTatsumi

スコア7

test CHANGED
File without changes
test CHANGED
@@ -28,7 +28,7 @@
28
28
 
29
29
  ###該当のソースコード
30
30
 
31
- infoexec.php{
31
+ **###**'infoexec.php{
32
32
 
33
33
  <?php
34
34
 
@@ -200,7 +200,7 @@
200
200
 
201
201
  ?>
202
202
 
203
- }
203
+ }'****
204
204
 
205
205
  記載しています。
206
206