回答編集履歴
3
gender is string
test
CHANGED
@@ -8,11 +8,11 @@
|
|
8
8
|
|
9
9
|
$id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT);
|
10
10
|
|
11
|
-
if ($name && $id &&
|
11
|
+
if ($name && $id && $gender) {
|
12
12
|
|
13
13
|
$stmt = $mysqli->prepare("UPDATE studentinfo SET Name=?, Gender=? WHERE id=?");
|
14
14
|
|
15
|
-
$stmt->bind_param('si
|
15
|
+
$stmt->bind_param('ssi', $name, $gender, $id);
|
16
16
|
|
17
17
|
...
|
18
18
|
|
2
gender
test
CHANGED
@@ -2,17 +2,17 @@
|
|
2
2
|
|
3
3
|
```php
|
4
4
|
|
5
|
+
$name = filter_input(INPUT_POST, 'Name');
|
5
6
|
|
6
|
-
|
7
|
-
$n
|
7
|
+
$gender = filter_input(INPUT_POST, 'Gender');
|
8
8
|
|
9
9
|
$id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT);
|
10
10
|
|
11
|
-
if ($name && $id) {
|
11
|
+
if ($name && $id && !empty($gender)) {
|
12
12
|
|
13
|
-
$stmt = $mysqli->prepare("UPDATE studentinfo SET Name=? WHERE id=?");
|
13
|
+
$stmt = $mysqli->prepare("UPDATE studentinfo SET Name=?, Gender=? WHERE id=?");
|
14
14
|
|
15
|
-
$stmt->bind_param('si', $name, $id);
|
15
|
+
$stmt->bind_param('sii', $name, $gender, $id);
|
16
16
|
|
17
17
|
...
|
18
18
|
|
1
mysqli
test
CHANGED
@@ -2,26 +2,20 @@
|
|
2
2
|
|
3
3
|
```php
|
4
4
|
|
5
|
-
//(注)$_POSTはバリデーションしてから使いましょう
|
6
|
-
|
7
|
-
$stmt = $mysqli->prepare("UPDATE studentinfo SET Name=? WHERE id=?");
|
8
|
-
|
9
|
-
$sth->bindParam(1, $_POST['Name']);
|
10
|
-
|
11
|
-
$sth->bindParam(2, $_POST['id'], PDO::PARAM_INT); //intだと仮定しています
|
12
5
|
|
13
6
|
|
7
|
+
$name = filter_input(INPUT_POST, 'Name');
|
14
8
|
|
15
|
-
|
9
|
+
$id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT);
|
16
10
|
|
17
|
-
|
11
|
+
if ($name && $id) {
|
18
12
|
|
19
|
-
$stmt->e
|
13
|
+
$stmt = $mysqli->prepare("UPDATE studentinfo SET Name=? WHERE id=?");
|
20
14
|
|
21
|
-
|
15
|
+
$stmt->bind_param('si', $name, $id);
|
22
16
|
|
23
|
-
|
17
|
+
...
|
24
18
|
|
25
|
-
|
19
|
+
}
|
26
20
|
|
27
21
|
```
|