質問するログイン新規登録

回答編集履歴

3

修正

2015/10/24 14:55

投稿

退会済みユーザー
answer CHANGED
@@ -75,7 +75,7 @@
75
75
  $arrPost = filter_input_array(INPUT_POST);
76
76
 
77
77
  $room_id = $arrPost['room_id'];
78
- $arrEquipmentId = (isset($arrPost['equipment'])) ? $arrPost['equipment'] : null;
78
+ $arrEquipmentId = (isset($arrPost['equipment'])) ? $arrPost['equipment'] : [];
79
79
 
80
80
  //$dbh =
81
81
 

2

修正

2015/10/24 14:55

投稿

退会済みユーザー
answer CHANGED
@@ -69,12 +69,13 @@
69
69
 
70
70
  追記
71
71
 
72
+ ```html
72
73
  <?php
73
- if (null != filter_input(INPUT_POST, 'equipment') &&
74
+ if (null != filter_input_array(INPUT_POST)) {
74
- 0 < filter_input(INPUT_POST, 'room_id')) {
75
+ $arrPost = filter_input_array(INPUT_POST);
75
76
 
76
- $room_id = filter_input(INPUT_POST, 'room_id');
77
+ $room_id = $arrPost['room_id'];
77
- $arrEquipmentId = filter_input(INPUT_POST, 'equipment');
78
+ $arrEquipmentId = (isset($arrPost['equipment'])) ? $arrPost['equipment'] : null;
78
79
 
79
80
  //$dbh =
80
81
 
@@ -106,3 +107,4 @@
106
107
  </form>
107
108
  </body>
108
109
  </html>
110
+ ```

1

追記

2015/10/24 14:47

投稿

退会済みユーザー
answer CHANGED
@@ -63,4 +63,46 @@
63
63
  <label><input type="checkbox" name="equipment[]" value="3" />インターネット</label>
64
64
  <label><input type="checkbox" name="equipment[]" value="4" />対面キッチン</label>
65
65
  </form>
66
- ```
66
+ ```
67
+
68
+ ---
69
+
70
+ 追記
71
+
72
+ <?php
73
+ if (null != filter_input(INPUT_POST, 'equipment') &&
74
+ 0 < filter_input(INPUT_POST, 'room_id')) {
75
+
76
+ $room_id = filter_input(INPUT_POST, 'room_id');
77
+ $arrEquipmentId = filter_input(INPUT_POST, 'equipment');
78
+
79
+ //$dbh =
80
+
81
+ foreach ($arrEquipmentId as $equipmentId) {
82
+ $vals = [];
83
+ $sql = 'INSERT INTO equipmet (id, room_id, euipment_id) VALUES (null, ?, ?)';
84
+ $vals[] = $room_id;
85
+ $vals[] = $equipmentId;
86
+
87
+ $stmt = $dbh->prepare($sql);
88
+ $stmt->execute($vals);
89
+ }
90
+ }
91
+ ?>
92
+ <!DOCTYPE HTML>
93
+ <html lang="en-US">
94
+ <head>
95
+ <meta charset="UTF-8">
96
+ <title></title>
97
+ </head>
98
+ <body>
99
+ <form action="" method="post">
100
+ <input type="hidden" name="room_id" value="1" />
101
+ <!-- master_euipment から動的に生成する -->
102
+ <label><input type="checkbox" name="equipment[]" value="1" />オートロック</label>
103
+ <label><input type="checkbox" name="equipment[]" value="2" />南向き</label>
104
+ <label><input type="checkbox" name="equipment[]" value="3" />インターネット</label>
105
+ <label><input type="checkbox" name="equipment[]" value="4" />対面キッチン</label>
106
+ </form>
107
+ </body>
108
+ </html>