将数组传递给mysql [重复]

$ids = array(1, 2, 3, 4);$ids = join(', ', $ids);$query = "SELECt * FROM business WHERe business_id IN ($ids)";// $query => SELECt * FROM business WHERe business_id IN (1, 2, 3, 4)

通常的SQL注入警告仍然适用，您可能需要先循环遍历id以进行验证或转义。另外，如果希望使用字符串而不是数字，请使用以下命令：

$ids = array('a', 'b', 'c', 'd');$ids = join("', '", $ids);$query = "SELECt * FROM business WHERe business_id IN ('$ids')";// $query => SELECt * FROM business WHERe business_id IN ('a', 'b', 'c', 'd')