PHP-如何在mysql查询中添加数组值，并从每个类别中检索单个数据 - PHP - how to add array values in mysql query and retrieve single data from each category

PHP - how to add array values in mysql query and retrieve single data from each category

我有以下数组输出。。。我想在mysql查询中使用这个数组值。

数组值输出：

Array ( [0] => Array ( [0] => 144 [category_id] => 144 ) [1] => Array ( [0] => 98
[category_id] => 98 ) [2] => Array ( [0] => 146 [category_id] => 146 ) [3] => 
Array ( [0] => 142 [category_id] => 142 ) ) 
Array Value : 144 98 146 142

我希望Sql查询获得与上述ID相关的四条记录（144 98 146 142）

$Sql_array = mysql_query("SELECT * FROM product_table")

谢谢你的帮助。。。。

尝试：

SELECT * FROM product_table WHERE id IN (144,98,146,142);

SELECT * FROM product_table WHERE category_id IN (1,2,3,4)

在您的示例中

$Sql_array = mysql_query("SELECT * FROM product_table WHERE category_ID IN (".join(',',$array).")")

你可以使用这样的循环

(string)$select;
foreach($array as $k){
 $select.= $k[0].",";
}
$select = substr_replace($select ,"",-1);
$query = "SELECT * FROM product_table WHERE id IN (".$select.")";