回答編集履歴

3

修正

2018/06/21 06:02

投稿

退会済みユーザー
test CHANGED
@@ -26,19 +26,17 @@
26
26
 
27
27
 
28
28
 
29
- if ($name && empty($category) && empty($rank)) {
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 ($name && $category && empty($rank)) {
37
+ if ($category) {
38
38
 
39
- $sql .= "AND name like :name AND category = :category ";
39
+ $sql .= "AND category = :category ";
40
-
41
- $params[':name'] = sprintf('%%%s%%', $name);
42
40
 
43
41
  $params[':category'] = sprintf('%%%s%%', $category);
44
42
 

2

修正

2018/06/21 06:02

投稿

退会済みユーザー
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

修正

2018/06/21 05:51

投稿

退会済みユーザー
test CHANGED
@@ -32,7 +32,9 @@
32
32
 
33
33
  $params[':name'] = $name;
34
34
 
35
+ }
36
+
35
- } elseif ($name && $category && empty($rank)) {
37
+ if ($name && $category && empty($rank)) {
36
38
 
37
39
  $sql = "AND name like :name AND category = :category ";
38
40