回答編集履歴
1
若干修正
test
CHANGED
|
@@ -6,21 +6,19 @@
|
|
|
6
6
|
|
|
7
7
|
```PHP
|
|
8
8
|
|
|
9
|
-
<form method="post">
|
|
10
|
-
|
|
11
|
-
<input type="text" name="k" value=" a b c ">
|
|
12
|
-
|
|
13
|
-
<input type="submit" value="go">
|
|
14
|
-
|
|
15
|
-
</form>
|
|
16
|
-
|
|
17
|
-
<?php
|
|
18
|
-
|
|
19
9
|
$k=trim(filter_input(INPUT_POST,'k'));
|
|
20
10
|
|
|
21
11
|
$keywords=preg_split("/\s+/",$k);
|
|
22
12
|
|
|
23
13
|
$sql="select * from mytable where 1";
|
|
14
|
+
|
|
15
|
+
if(count($keywords)==1 and $keywords[0]===""){
|
|
16
|
+
|
|
17
|
+
$sql.=" and 0";
|
|
18
|
+
|
|
19
|
+
print "検索：".$sql.";<br>";
|
|
20
|
+
|
|
21
|
+
}else{
|
|
24
22
|
|
|
25
23
|
foreach($keywords as $val){
|
|
26
24
|
|
|
@@ -38,8 +36,10 @@
|
|
|
38
36
|
|
|
39
37
|
print "or検索：".$sql.";<br>";
|
|
40
38
|
|
|
39
|
+
}
|
|
40
|
+
|
|
41
41
|
?>
|
|
42
42
|
|
|
43
43
|
```
|
|
44
44
|
|
|
45
|
-
実際のデータ
|
|
45
|
+
実際のデータ投入の際にはPDOのprepare処理が必要になります
|