PHP/mySQL-在关联数组中选择WHERE多个值 - PHP/mySQL - Select WHERE multiple values in an associative array

PHP/mySQL - Select WHERE multiple values in an associative array

本文关键字：WHERE 选择数组 mySQL- 关联 PHP | 更新日期: 2023-09-27

$skuArray = array(00240=>123,00241=>456);
$getSkus = mysql_query("SELECT sku FROM data WHERE sku IN($skuArray)");

我上面的代码不起作用，我如何让它SELECT所有sku的FROM数据WHERE sku=$skuArray中的任何键名？(本例为00240和00241(

希望这是合理的，谢谢。

试试这个：

<?php
$skuArray = array('00240'=>123, '00241'=>456);
$inSkus = array();
foreach (array_keys($skuArray) as $key)
{
    $inSkus[] = '"' . $key . '"';
}
$sql = 'SELECT sku FROM data WHERE sku IN (' . implode(', ', $inSkus) . ')';
echo $sql;

您需要将键作为字符串，然后需要将它们封装在SQL查询的括号中。

$skuArray = array('00240'=>123,'00241'=>456);
$keys = array_keys($skuArray);
$getSkus = mysql_query("SELECT sku FROM data WHERE sku IN('" . join("','", $keys) . "')");

 foreach($skuArray  as $value=>$key){
    if($where=="")
       $where= $value" = '".$key."'";
    else
       $where.= $value" = '".$key."'";
 }
 $getSkus = mysql_query("SELECT sku FROM data " .($where)?" WHERE   $where )":"");