php - MYSQL使用存储在单独表中的过滤器从产品表中选择

Question

我有一个包含两个重要表的数据库。一张表包含我们的整个产品目录。另一个是从后端面板中选择用于搜索的过滤器列表。由于某种原因，执行时显示空白屏幕。我很确定我很愚蠢并且错过了一些愚蠢的事情。

MYSQL日志显示

SELECT * FROM product_list WHERE product_list.PRODUCT_NAME IN ('\'product1\' OR \'product2\' //etcetc

有人有什么想法吗？我的脚本如下:

echo "<table class='inventorydata'><tr><td>SKU</td><td></td><td>Title</td><td>Quanitity</td></tr><tr><td colspan='4'></td></tr>";
//table header

$filterproducts = $dbh->prepare("SELECT * FROM table_filter_selection ORDER BY filter ASC");
$filterproducts->execute();
$filterselect = $filterproducts->fetchAll();
//select all set filters from the table

$filteroptions = "'";
foreach($filterselect as $filterRow){
$filteroptions .= $filterRow['filter'] . "' OR '";
}
//set filters in to a string

$truesearch = $dbh->prepare("SELECT * FROM product_list WHERE product_list.PRODUCT_NAME IN (:filterchoice)");
$truesearch->bindParam(":filterchoice", $filteroptions, PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$truesearch->execute();
//use filters set as parameters for searching through products

foreach($truesearch as $rows){
echo "<tr><td>" . $rows['SKU'] ."<td/><td>". $rows['PRODUCT_NAME'] ."</td><td>". $rows['QTY'] . "</td></tr>";
}
//display products

echo "</table>";

Answer 1

我暂时通过循环每个过滤器并在每个循环打开一个连接来解决这个问题。不是最漂亮的，但暂时就可以了。谢谢您的帮助。