回答編集履歴
3
修正
test
CHANGED
@@ -26,19 +26,17 @@
|
|
26
26
|
|
27
27
|
|
28
28
|
|
29
|
-
if ($name
|
29
|
+
if ($name) {
|
30
30
|
|
31
31
|
$sql .= "AND name like :name ";
|
32
32
|
|
33
|
-
$params[':name'] = $name;
|
33
|
+
$params[':name'] = sprintf('%%%s%%', $name);
|
34
34
|
|
35
35
|
}
|
36
36
|
|
37
|
-
if ($
|
37
|
+
if ($category) {
|
38
38
|
|
39
|
-
$sql .= "AND
|
39
|
+
$sql .= "AND category = :category ";
|
40
|
-
|
41
|
-
$params[':name'] = sprintf('%%%s%%', $name);
|
42
40
|
|
43
41
|
$params[':category'] = sprintf('%%%s%%', $category);
|
44
42
|
|
2
修正
test
CHANGED
@@ -28,7 +28,7 @@
|
|
28
28
|
|
29
29
|
if ($name && empty($category) && empty($rank)) {
|
30
30
|
|
31
|
-
$sql = "AND name like :name ";
|
31
|
+
$sql .= "AND name like :name ";
|
32
32
|
|
33
33
|
$params[':name'] = $name;
|
34
34
|
|
@@ -36,7 +36,7 @@
|
|
36
36
|
|
37
37
|
if ($name && $category && empty($rank)) {
|
38
38
|
|
39
|
-
$sql = "AND name like :name AND category = :category ";
|
39
|
+
$sql .= "AND name like :name AND category = :category ";
|
40
40
|
|
41
41
|
$params[':name'] = sprintf('%%%s%%', $name);
|
42
42
|
|
1
修正
test
CHANGED
@@ -32,7 +32,9 @@
|
|
32
32
|
|
33
33
|
$params[':name'] = $name;
|
34
34
|
|
35
|
+
}
|
36
|
+
|
35
|
-
|
37
|
+
if ($name && $category && empty($rank)) {
|
36
38
|
|
37
39
|
$sql = "AND name like :name AND category = :category ";
|
38
40
|
|