質問編集履歴

4

\$data = mysqli_fetch_assoc\(\$recordSet\);が必要なかったので削除

2017/01/06 12:16

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -76,8 +76,6 @@
76
76
 
77
77
  $recordSet = mysqli_query($db, $sql);
78
78
 
79
- $data = mysqli_fetch_assoc($recordSet);
80
-
81
79
  ?>
82
80
 
83
81
 
@@ -86,9 +84,9 @@
86
84
 
87
85
  <?php
88
86
 
89
- while($data2 = mysqli_fetch_assoc($recordSet)) {
87
+ while($data = mysqli_fetch_assoc($recordSet)) {
90
88
 
91
- print '<option value="' . htmlspecialchars($data2['photo'], ENT_QUOTES) . '">' . htmlspecialchars($data2['photo'], ENT_QUOTES) . '</option>' . PHP_EOL;
89
+ print '<option value="' . htmlspecialchars($data['photo'], ENT_QUOTES) . '">' . htmlspecialchars($data['photo'], ENT_QUOTES) . '</option>' . PHP_EOL;
92
90
 
93
91
  }
94
92
 

3

selectの\*を詳細に

2017/01/06 12:16

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -68,7 +68,7 @@
68
68
 
69
69
  $id = $_REQUEST['id'];
70
70
 
71
- $sql = sprintf("SELECT * FROM staff WHERE id=%d",
71
+ $sql = sprintf("SELECT name, age, phone, address, info FROM staff WHERE id=%d",
72
72
 
73
73
  mysqli_real_escape_string($db, $id)
74
74
 

2

sqlをsqliに統一

2017/01/06 11:56

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -86,7 +86,7 @@
86
86
 
87
87
  <?php
88
88
 
89
- while($data2 = mysql_fetch_assoc($recordSet)) {
89
+ while($data2 = mysqli_fetch_assoc($recordSet)) {
90
90
 
91
91
  print '<option value="' . htmlspecialchars($data2['photo'], ENT_QUOTES) . '">' . htmlspecialchars($data2['photo'], ENT_QUOTES) . '</option>' . PHP_EOL;
92
92
 

1

<select name="photo">を<select name="information">に修正

2017/01/06 11:52

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -82,7 +82,7 @@
82
82
 
83
83
 
84
84
 
85
- <select name="photo">
85
+ <select name="information">
86
86
 
87
87
  <?php
88
88