質問編集履歴
2
teisei
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -292,97 +292,7 @@
|
|
|
292
292
|
|
|
293
293
|
```
|
|
294
294
|
|
|
295
|
-
|
|
295
|
+
|
|
296
|
-
|
|
297
|
-
<?php
|
|
298
|
-
|
|
299
|
-
|
|
300
|
-
|
|
301
|
-
$dbname = "mfdb";
|
|
302
|
-
|
|
303
|
-
$link = mysqli_connect("localhost","root","",$dbname) or exit("MySQLへ接続できません。");
|
|
304
|
-
|
|
305
|
-
|
|
306
|
-
|
|
307
|
-
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
|
|
308
|
-
|
|
309
|
-
$companyoffice = mysql_real_escape_string($_POST["companyoffice"]);
|
|
310
|
-
|
|
311
|
-
$cmpNum1 = mysql_real_escape_string($_POST['cmpNum1']);
|
|
312
|
-
|
|
313
|
-
$cmpname1 = mysql_real_escape_string($_POST['cmpname1']);
|
|
314
|
-
|
|
315
|
-
$cmpname2 = mysql_real_escape_string($_POST['cmpname2']);
|
|
316
|
-
|
|
317
|
-
$mssa1 = mysql_real_escape_string($_POST['mssa1']);
|
|
318
|
-
|
|
319
|
-
$mssa2 = mysql_real_escape_string($_POST['mssa2']);
|
|
320
|
-
|
|
321
|
-
$mssapass = mysql_real_escape_string($_POST['mssapass']);
|
|
322
|
-
|
|
323
|
-
$mssaemail = mysql_real_escape_string($_POST['mssaemail']);
|
|
324
|
-
|
|
325
|
-
$mssafax1 = mysql_real_escape_string($_POST['mssafax1']);
|
|
326
|
-
|
|
327
|
-
$mssatel1 = mysql_real_escape_string($_POST['mssatel1']);
|
|
328
|
-
|
|
329
|
-
$mssazip = mysql_real_escape_string($_POST['mssazip']);
|
|
330
|
-
|
|
331
|
-
$mssaprefecture = mysql_real_escape_string($_POST['mssaprefecture']);
|
|
332
|
-
|
|
333
|
-
$MssaAddress = mysql_real_escape_string($_POST['MssaAddress']);
|
|
334
|
-
|
|
335
|
-
$sjs = mysql_real_escape_string($_POST['sjs']);
|
|
336
|
-
|
|
337
|
-
|
|
338
|
-
|
|
339
|
-
if (!empty($companyoffice) &&!empty($cmpNum1) &&!empty($cmpname1) &&!empty($cmpname2) && !empty($mssa1)&& !empty($mssa2)
|
|
340
|
-
|
|
341
|
-
&& !empty($mssapass)&& !empty($mssaemail) &&!empty($mssafax1) &&!empty($mssatel1)&& !empty($mssazip)&& !empty($mssaprefecture)
|
|
342
|
-
|
|
343
|
-
&& !empty($MssaAddress) && !empty($sjs)) {
|
|
344
|
-
|
|
345
|
-
$query = "INSERT INTO office(companyoffice, cmpNum1, cmpname1, cmpname2,
|
|
346
|
-
|
|
347
|
-
mssa1, mssa2, mssapass, mssaemail, mssatel1, mssafax1, mssazip, mssaprefecture, MssaAddress, sjs)
|
|
348
|
-
|
|
349
|
-
VALUES ('$companyoffice','$cmpNum1','$cmpname1','$cmpname2','$mssa1','$mssa2','$mssapass',
|
|
350
|
-
|
|
351
|
-
'$mssaemail','$mssatel1','$mssafax1','$mssazip','$mssaprefecture','$MssaAddress','$sjs')";
|
|
352
|
-
|
|
353
|
-
$stmt = mysqli_prepare($link, $query);
|
|
354
|
-
|
|
355
|
-
if (!$stmt) {
|
|
356
|
-
|
|
357
|
-
die('クエリーが失敗しました。'.mysql_error());
|
|
358
|
-
|
|
359
|
-
}
|
|
360
|
-
|
|
361
|
-
mysql_set_charset('utf8');
|
|
362
|
-
|
|
363
|
-
|
|
364
|
-
|
|
365
|
-
|
|
366
|
-
|
|
367
|
-
}else {
|
|
368
|
-
|
|
369
|
-
echo "<p style='color:red';>ERROR:フォームがすべて入力されてません</p>";
|
|
370
|
-
|
|
371
|
-
}
|
|
372
|
-
|
|
373
|
-
}else {
|
|
374
|
-
|
|
375
|
-
echo "<p>下記内容をご記入とご確認の上で会員登録を押してください。</p>";
|
|
376
|
-
|
|
377
|
-
echo "<p>＊運用地が事業所の支店である場合は<br>支店登録票にも記入してください。</p>";
|
|
378
|
-
|
|
379
|
-
}
|
|
380
|
-
|
|
381
|
-
|
|
382
|
-
|
|
383
|
-
|
|
384
|
-
|
|
385
|
-
?>
|
|
386
296
|
|
|
387
297
|
```
|
|
388
298
|
|
1
指摘された文法を改善しました
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -288,7 +288,103 @@
|
|
|
288
288
|
|
|
289
289
|
```
|
|
290
290
|
|
|
291
|
-
|
|
291
|
+
クエリーが失敗しましたのエラーは変更されました。しかし、DBに内容が反映されません。
|
|
292
|
+
|
|
293
|
+
```
|
|
294
|
+
|
|
295
|
+
修正
|
|
296
|
+
|
|
297
|
+
<?php
|
|
298
|
+
|
|
299
|
+
|
|
300
|
+
|
|
301
|
+
$dbname = "mfdb";
|
|
302
|
+
|
|
303
|
+
$link = mysqli_connect("localhost","root","",$dbname) or exit("MySQLへ接続できません。");
|
|
304
|
+
|
|
305
|
+
|
|
306
|
+
|
|
307
|
+
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
|
|
308
|
+
|
|
309
|
+
$companyoffice = mysql_real_escape_string($_POST["companyoffice"]);
|
|
310
|
+
|
|
311
|
+
$cmpNum1 = mysql_real_escape_string($_POST['cmpNum1']);
|
|
312
|
+
|
|
313
|
+
$cmpname1 = mysql_real_escape_string($_POST['cmpname1']);
|
|
314
|
+
|
|
315
|
+
$cmpname2 = mysql_real_escape_string($_POST['cmpname2']);
|
|
316
|
+
|
|
317
|
+
$mssa1 = mysql_real_escape_string($_POST['mssa1']);
|
|
318
|
+
|
|
319
|
+
$mssa2 = mysql_real_escape_string($_POST['mssa2']);
|
|
320
|
+
|
|
321
|
+
$mssapass = mysql_real_escape_string($_POST['mssapass']);
|
|
322
|
+
|
|
323
|
+
$mssaemail = mysql_real_escape_string($_POST['mssaemail']);
|
|
324
|
+
|
|
325
|
+
$mssafax1 = mysql_real_escape_string($_POST['mssafax1']);
|
|
326
|
+
|
|
327
|
+
$mssatel1 = mysql_real_escape_string($_POST['mssatel1']);
|
|
328
|
+
|
|
329
|
+
$mssazip = mysql_real_escape_string($_POST['mssazip']);
|
|
330
|
+
|
|
331
|
+
$mssaprefecture = mysql_real_escape_string($_POST['mssaprefecture']);
|
|
332
|
+
|
|
333
|
+
$MssaAddress = mysql_real_escape_string($_POST['MssaAddress']);
|
|
334
|
+
|
|
335
|
+
$sjs = mysql_real_escape_string($_POST['sjs']);
|
|
336
|
+
|
|
337
|
+
|
|
338
|
+
|
|
339
|
+
if (!empty($companyoffice) &&!empty($cmpNum1) &&!empty($cmpname1) &&!empty($cmpname2) && !empty($mssa1)&& !empty($mssa2)
|
|
340
|
+
|
|
341
|
+
&& !empty($mssapass)&& !empty($mssaemail) &&!empty($mssafax1) &&!empty($mssatel1)&& !empty($mssazip)&& !empty($mssaprefecture)
|
|
342
|
+
|
|
343
|
+
&& !empty($MssaAddress) && !empty($sjs)) {
|
|
344
|
+
|
|
345
|
+
$query = "INSERT INTO office(companyoffice, cmpNum1, cmpname1, cmpname2,
|
|
346
|
+
|
|
347
|
+
mssa1, mssa2, mssapass, mssaemail, mssatel1, mssafax1, mssazip, mssaprefecture, MssaAddress, sjs)
|
|
348
|
+
|
|
349
|
+
VALUES ('$companyoffice','$cmpNum1','$cmpname1','$cmpname2','$mssa1','$mssa2','$mssapass',
|
|
350
|
+
|
|
351
|
+
'$mssaemail','$mssatel1','$mssafax1','$mssazip','$mssaprefecture','$MssaAddress','$sjs')";
|
|
352
|
+
|
|
353
|
+
$stmt = mysqli_prepare($link, $query);
|
|
354
|
+
|
|
355
|
+
if (!$stmt) {
|
|
356
|
+
|
|
357
|
+
die('クエリーが失敗しました。'.mysql_error());
|
|
358
|
+
|
|
359
|
+
}
|
|
360
|
+
|
|
361
|
+
mysql_set_charset('utf8');
|
|
362
|
+
|
|
363
|
+
|
|
364
|
+
|
|
365
|
+
|
|
366
|
+
|
|
367
|
+
}else {
|
|
368
|
+
|
|
369
|
+
echo "<p style='color:red';>ERROR:フォームがすべて入力されてません</p>";
|
|
370
|
+
|
|
371
|
+
}
|
|
372
|
+
|
|
373
|
+
}else {
|
|
374
|
+
|
|
375
|
+
echo "<p>下記内容をご記入とご確認の上で会員登録を押してください。</p>";
|
|
376
|
+
|
|
377
|
+
echo "<p>＊運用地が事業所の支店である場合は<br>支店登録票にも記入してください。</p>";
|
|
378
|
+
|
|
379
|
+
}
|
|
380
|
+
|
|
381
|
+
|
|
382
|
+
|
|
383
|
+
|
|
384
|
+
|
|
385
|
+
?>
|
|
386
|
+
|
|
387
|
+
```
|
|
292
388
|
|
|
293
389
|
###補足情報(言語/FW/ツール等のバージョンなど)
|
|
294
390
|
|