回答編集履歴
2
typo
answer
CHANGED
|
@@ -5,11 +5,11 @@
|
|
|
5
5
|
$sql="SELECT * FROM table WHERE 1 ";
|
|
6
6
|
$data=[];
|
|
7
7
|
if(!is_null($category)){
|
|
8
|
-
$sql.="AND 分類=?";
|
|
8
|
+
$sql.="AND 分類=? ";
|
|
9
9
|
$data[]=$category;
|
|
10
10
|
}
|
|
11
11
|
if(!is_null($color)){
|
|
12
|
-
$sql.="AND 色=?";
|
|
12
|
+
$sql.="AND 色=? ";
|
|
13
13
|
$data[]=$color;
|
|
14
14
|
}
|
|
15
15
|
$stmt = $pdo->prepare($sql);
|
1
修正
answer
CHANGED
|
@@ -12,6 +12,6 @@
|
|
|
12
12
|
$sql.="AND 色=?";
|
|
13
13
|
$data[]=$color;
|
|
14
14
|
}
|
|
15
|
-
$stmt = $pdo->prepare(
|
|
15
|
+
$stmt = $pdo->prepare($sql);
|
|
16
16
|
$stmt->execute($data);
|
|
17
17
|
```
|