嗨,我写以下查询
SELECT *
FROM `product`
WHERE (`color` IN ('black'))
OR (`pattern` IN ('pattern-1', 'pattern-2', 'pattern-3'))
AND `p_category` LIKE '%Blind%'
AND id NOT IN('20', '19', '18', '17', '11')
ORDER BY id DESC
但由于某种原因,它显示的产品ID为'20', '19', '18', '17', '11'
我认为这些信息足以解决这个问题.
更新
在这里,我不知道我需要改变的地方.在这里,我正在使用 阿贾克斯 . 所有操作都发生在该页面中。 发布变量到达 ajax 调用页面我执行的操作是
$keyword_array= ( [keyword] => Array (
[0] => color*black
[1] => pattern*pattern-1
[2] => pattern*pattern-2
[3] => pattern*pattern-3 )
[y_id] => Array (
[0] => 20
[1] => 19
[2] => 18
[3] => 17
[4] => 11 )
[category] => Romex Blind );
foreach ( $keyword_array as $value) {
list($before, $after) = explode('*', $value);
$elements[$before][] = $after;
}
$parts = [];
foreach ($elements as $column => $values) {
$parts[] = "(`$column` IN ('" . implode("', '", $values) . "'))";
}
$appear=implode("', '", $_POST['y_id']);
$query = "SELECT * FROM `product` WHERE " . implode(' OR ', $parts). " AND `p_category` LIKE '%".$_POST['category']."%' AND id NOT IN('{$appear}') ORDER BY id DESC";
请告诉此查询中的错误是什么。
在 or 表达式周围做断点:
SELECT *
FROM `product`
WHERE (`color` IN ('black')
OR `pattern` IN ('pattern-1', 'pattern-2', 'pattern-3'))
AND `p_category` LIKE '%Blind%'
AND id NOT IN('20', '19', '18', '17', '11')
ORDER BY id DESC
更新尝试
$query = "SELECT * FROM `product` WHERE (" . implode(' OR ', $parts). ") AND `p_category``
你可以
这样写查询
SELECT * FROM product WHERE (color = 'black' OR pattern IN ('pattern-1', 'pattern-2', 'pattern-3')) AND p_category LIKE '%Blind%' AND id NOT IN (20, 19, 18, 17, 11) ORDER BY id
如果有两个或更多条件并且只需要一个答案,例如
在您查询的情况下,查询似乎错误的数据将得到