回答編集履歴

修正

2018/06/21 06:02

投稿

スコア0

answer CHANGED Viewed

@@ -12,13 +12,12 @@
 $params = [];
 $sql = "SELECT * FROM user WHERE 1 ";
-if ($name && empty($category) && empty($rank)) {
+if ($name) {
 	$sql .= "AND name like :name ";
-	$params[':name'] = $name;
+	$params[':name'] = sprintf('%%%s%%', $name);
 }
-if ($name && $category && empty($rank)) {
+if ($category) {
-	$sql .= "AND name like :name AND category = :category ";
+	$sql .= "AND category = :category ";
-	$params[':name'] = sprintf('%%%s%%', $name);
 	$params[':category'] = sprintf('%%%s%%', $category);
 }

修正

2018/06/21 06:02

投稿

スコア0

answer CHANGED Viewed

@@ -13,11 +13,11 @@
 $sql = "SELECT * FROM user WHERE 1 ";
 if ($name && empty($category) && empty($rank)) {
-	$sql = "AND name like :name ";
+	$sql .= "AND name like :name ";
 	$params[':name'] = $name;
 }
 if ($name && $category && empty($rank)) {
-	$sql = "AND name like :name AND category = :category ";
+	$sql .= "AND name like :name AND category = :category ";
 	$params[':name'] = sprintf('%%%s%%', $name);
 	$params[':category'] = sprintf('%%%s%%', $category);
 }

修正

2018/06/21 05:51

投稿

スコア0

answer CHANGED Viewed

@@ -15,7 +15,8 @@
 if ($name && empty($category) && empty($rank)) {
 	$sql = "AND name like :name ";
 	$params[':name'] = $name;
+}
-} elseif ($name && $category && empty($rank)) {
+if ($name && $category && empty($rank)) {
 	$sql = "AND name like :name AND category = :category ";
 	$params[':name'] = sprintf('%%%s%%', $name);
 	$params[':category'] = sprintf('%%%s%%', $category);