質問編集履歴
6
修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -134,7 +134,17 @@
|
|
134
134
|
|
135
135
|
}
|
136
136
|
|
137
|
-
|
137
|
+
$where = "";
|
138
|
+
|
139
|
+
if(count($where_list) > 0){
|
140
|
+
|
141
|
+
$where = " where ".implode(" and ",$where_list);
|
142
|
+
|
143
|
+
}
|
144
|
+
|
145
|
+
$sql = "SELECT * FROM theme ".$where;
|
146
|
+
|
147
|
+
$result = pg_query($con,$sql);
|
138
148
|
|
139
149
|
|
140
150
|
|
5
指摘事項の修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -84,13 +84,9 @@
|
|
84
84
|
|
85
85
|
```PHP
|
86
86
|
|
87
|
-
|
88
|
-
|
89
87
|
//php部分
|
90
88
|
|
91
|
-
|
89
|
+
session_start();
|
92
|
-
|
93
|
-
|
94
90
|
|
95
91
|
$connect = "host=$P_IP port=$P_PORT dbname=$P_DBNAME user=$P_DBUSER password=$P_DBPASS";
|
96
92
|
|
@@ -126,9 +122,9 @@
|
|
126
122
|
|
127
123
|
|
128
124
|
|
129
|
-
|
125
|
+
|
130
|
-
|
131
|
-
|
126
|
+
|
127
|
+
|
132
128
|
|
133
129
|
$word3 = "";
|
134
130
|
|
4
指摘箇所の追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -112,10 +112,34 @@
|
|
112
112
|
|
113
113
|
|
114
114
|
|
115
|
+
if($_SERVER["REQUEST_METHOD"] === "POST"){
|
116
|
+
|
117
|
+
$_SESSION['word'] = $_POST['word'];
|
118
|
+
|
119
|
+
$_SESSION['word1'] = $_POST['word1'];
|
120
|
+
|
121
|
+
$_SESSION['word2'] = $_POST['word2'];
|
122
|
+
|
123
|
+
$_SESSION['word3'] = $_POST['word3'];
|
124
|
+
|
125
|
+
}
|
126
|
+
|
127
|
+
|
128
|
+
|
115
129
|
session_start();
|
116
130
|
|
117
131
|
$_SESSION['word3'] =$KEY3;
|
118
132
|
|
133
|
+
$word3 = "";
|
134
|
+
|
135
|
+
if(array_key_exists("word3",$_SESSION) && !empty($_SESSION["word3"])){
|
136
|
+
|
137
|
+
$word3 = $_SESSION['word3'];
|
138
|
+
|
139
|
+
}
|
140
|
+
|
141
|
+
|
142
|
+
|
119
143
|
|
120
144
|
|
121
145
|
if (!isset($_GET['page'])) {
|
@@ -194,9 +218,9 @@
|
|
194
218
|
|
195
219
|
</form>
|
196
220
|
|
197
|
-
<p><a href="
|
221
|
+
<p><a href="user669.php?page=<?php echo ($page + 1); ?>&<?php echo $word3;?>"action='<?= $PHP_SELF ?>';>next</a></p>
|
198
|
-
|
222
|
+
|
199
|
-
<p><a href="
|
223
|
+
<p><a href="user669.php?page=<?php echo ($page - 1); ?>&<?php echo $word3;?>">back</a></p>
|
200
224
|
|
201
225
|
</div>
|
202
226
|
|
3
現在のコード
test
CHANGED
File without changes
|
test
CHANGED
@@ -112,6 +112,12 @@
|
|
112
112
|
|
113
113
|
|
114
114
|
|
115
|
+
session_start();
|
116
|
+
|
117
|
+
$_SESSION['word3'] =$KEY3;
|
118
|
+
|
119
|
+
|
120
|
+
|
115
121
|
if (!isset($_GET['page'])) {
|
116
122
|
|
117
123
|
$page = 1; // 最初のアクセス
|
@@ -126,11 +132,11 @@
|
|
126
132
|
|
127
133
|
|
128
134
|
|
129
|
-
|
135
|
+
$offset = ($page-1) * 5;
|
130
|
-
|
131
|
-
|
132
|
-
|
136
|
+
|
137
|
+
|
138
|
+
|
133
|
-
$result = pg_query($con, "SELECT * FROM theme WHERE(theme_ans LIKE '%{$KEY3}%') OR (theme_que LIKE '%{$KEY3}%')limit 5 offset $
|
139
|
+
$result = pg_query($con, "SELECT * FROM theme WHERE(theme_ans LIKE '%{$KEY3}%') OR (theme_que LIKE '%{$KEY3}%')limit 5 offset $offset");
|
134
140
|
|
135
141
|
|
136
142
|
|
@@ -188,7 +194,9 @@
|
|
188
194
|
|
189
195
|
</form>
|
190
196
|
|
191
|
-
<p><a href="https://portal.e
|
197
|
+
<p><a href="https://portal.egg-net.co.jp/egg/user/user669.php?page=<?php echo ($page + 1); ?>&<?php echo $KEY3;?>">next</a></p>
|
198
|
+
|
199
|
+
<p><a href="https://portal.egg-net.co.jp/egg/user/user669.php?page=<?php echo ($page - 1); ?>&<?php echo $KEY3;?>">back</a></p>
|
192
200
|
|
193
201
|
</div>
|
194
202
|
|
2
コードの整合性の修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -140,9 +140,43 @@
|
|
140
140
|
|
141
141
|
|
142
142
|
|
143
|
-
|
143
|
+
<form method="post" action='<?= $PHP_SELF ?>'>
|
144
|
-
|
144
|
+
|
145
|
-
<p1>
|
145
|
+
<p1>製品種別</p1>
|
146
|
+
|
147
|
+
<select class="soft_select" name="word1">
|
148
|
+
|
149
|
+
<option value="0" name="word1" >0.全て</option>
|
150
|
+
|
151
|
+
<option value="1" name="word1" >1.</option>
|
152
|
+
|
153
|
+
<option value="2" name="word1" > 2.</option>
|
154
|
+
|
155
|
+
<option value="3" name="word1" >3.</option>
|
156
|
+
|
157
|
+
<option value="3" name="word1" >4.</option>
|
158
|
+
|
159
|
+
|
160
|
+
|
161
|
+
</select>
|
162
|
+
|
163
|
+
<p1>質問種別</p1>
|
164
|
+
|
165
|
+
<select class="type_select" name="word2">
|
166
|
+
|
167
|
+
<option value="0" name="word2" >0.全て</option>
|
168
|
+
|
169
|
+
<option value="1" name="word2" >1.</option>
|
170
|
+
|
171
|
+
<option value="2" name="word2" > 2.</option>
|
172
|
+
|
173
|
+
<option value="3" name="word2" >3.</option>
|
174
|
+
|
175
|
+
<option value="4" name="word2" >4.</option>
|
176
|
+
|
177
|
+
<option value="5" name="word2" >5.</option>
|
178
|
+
|
179
|
+
</select> <p1>ワード</p1>
|
146
180
|
|
147
181
|
|
148
182
|
|
@@ -154,7 +188,7 @@
|
|
154
188
|
|
155
189
|
</form>
|
156
190
|
|
157
|
-
<p><a href="https://portal.e
|
191
|
+
<p><a href="https://portal.e######/user669.php?page={$back}">next</a></p>
|
158
192
|
|
159
193
|
</div>
|
160
194
|
|
@@ -204,7 +238,7 @@
|
|
204
238
|
|
205
239
|
}
|
206
240
|
|
207
|
-
?>
|
241
|
+
?></table>
|
208
242
|
|
209
243
|
|
210
244
|
|
1
コードブロックで囲む
test
CHANGED
File without changes
|
test
CHANGED
@@ -82,7 +82,9 @@
|
|
82
82
|
|
83
83
|
### 該当のソースコード
|
84
84
|
|
85
|
-
|
85
|
+
```PHP
|
86
|
+
|
87
|
+
|
86
88
|
|
87
89
|
//php部分
|
88
90
|
|
@@ -203,3 +205,7 @@
|
|
203
205
|
}
|
204
206
|
|
205
207
|
?>
|
208
|
+
|
209
|
+
|
210
|
+
|
211
|
+
```
|