質問編集履歴
4
\$data = mysqli_fetch_assoc\(\$recordSet\);が必要なかったので削除
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($data
|
87
|
+
while($data = mysqli_fetch_assoc($recordSet)) {
|
90
88
|
|
91
|
-
print '<option value="' . htmlspecialchars($data
|
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の\*を詳細に
test
CHANGED
File without changes
|
test
CHANGED
@@ -68,7 +68,7 @@
|
|
68
68
|
|
69
69
|
$id = $_REQUEST['id'];
|
70
70
|
|
71
|
-
$sql = sprintf("SELECT
|
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に統一
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">に修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -82,7 +82,7 @@
|
|
82
82
|
|
83
83
|
|
84
84
|
|
85
|
-
<select name="
|
85
|
+
<select name="information">
|
86
86
|
|
87
87
|
<?php
|
88
88
|
|