PHP多维数组如何分别获取ClientId与CampaignId用于SQL查询

你的数组是一维数组嵌套关联子数组，单层循环就能遍历每个子项并取值，不需要双层循环。以下是具体实现方案：

1. 基础遍历与取值 #

直接遍历外层数组，每个元素就是包含ClientId和CampaignId的关联数组，通过键名即可直接获取对应值：

// 你的目标数组
$targetArray = [
    ['ClientId' => 47063, 'CampaignId' => 2169],
    ['ClientId' => 49786, 'CampaignId' => 2169],
    ['ClientId' => 47063, 'CampaignId' => 2168],
    ['ClientId' => 49786, 'CampaignId' => 2168],
];

// 初始化条件片段和参数数组（用于预处理SQL，避免注入）
$conditionParts = [];
$bindParams = [];

foreach ($targetArray as $item) {
    // 直接通过键名提取对应值
    $campaignId = $item['CampaignId'];
    $clientId = $item['ClientId'];
    
    // 构建一组(CampaignId=? AND ClientId=?)的条件片段
    $conditionParts[] = '(CampaignId = ? AND ClientId = ?)';
    // 存入对应参数，后续用于SQL预处理绑定
    $bindParams[] = $campaignId;
    $bindParams[] = $clientId;
}

// 拼接成完整WHERE子句
$whereClause = '';
if (!empty($conditionParts)) {
    $whereClause = 'WHERE ' . implode(' OR ', $conditionParts);
}

// 最终SQL示例（需配合PDO或mysqli的预处理执行）
$sql = "SELECT * FROM your_target_table $whereClause";

2. 之前取值失败的原因 #

如果之前用了双层循环（比如遍历外层数组后，再遍历子数组的键值对），会把ClientId和CampaignId的键或值单独拆分，无法同时获取一组对应的两个ID，这就是你拼接字符串出错的核心原因。

3. 可选优化：按CampaignId分组构建条件 #

如果需要更紧凑的SQL结构，可以先按CampaignId分组整理ClientId，再构建条件：

$groupedData = [];
foreach ($targetArray as $item) {
    $groupedData[$item['CampaignId']][] = $item['ClientId'];
}

$groupConditions = [];
$bindParams = [];
foreach ($groupedData as $campaignId => $clientIds) {
    // 生成ClientId对应的占位符
    $clientPlaceholders = implode(',', array_fill(0, count($clientIds), '?'));
    $groupConditions[] = "(CampaignId = ? AND ClientId IN ($clientPlaceholders))";
    $bindParams[] = $campaignId;
    $bindParams = array_merge($bindParams, $clientIds);
}

$whereClause = !empty($groupConditions) ? 'WHERE ' . implode(' OR ', $groupConditions) : '';

内容的提问来源于stack exchange，提问作者user19626118