PHP:如何将关联数组的每个键与其他键进行比较,跳过排列


PHP: how to compare each key of an associative array to to the others, skipping permutations?

我有一个(看似)简单的PHP问题:
我有一个关联数组(它反映了DB表的结构,但这与此无关),如以下所示:

----------------------------------
 id  | name            | phone
----------------------------------
   1 | alice           | 12345678
   3 | bob             | 56789012
   9 | zorro           | 90123456
 ... | ...             | ...
----------------------------------

我需要遍历数组来比较(比如检查没有两个人有相同的电话号码)每个密钥与所有其他密钥,避免重复检查,如check(1,3)和check(3,1)。。。(我想我可以根据一个等效的数学概念将这些命名为duplications)。

<?php
  $table = [
    [
      "id" => "1",
      "name" => "alice",
      "phone" => "12345678",
    ], [
    [
      "id" => "3",
      "name" => "bob",
      "phone" => "56789012",
    ], [
    [
      "id" => "9",
      "name" => "zorro",
      "phone" => "90123456",
    ],
  ];
?>

这就是我正在尝试的:

<?php
  foreach ($table as $record1) {
    foreach ($table as $record2) {
      check($record1["phone"], $record2["phone"]);
    }
  }
?>

但这当然是重复检查
通常(例如,在C language中),我会在数组中顺序迭代,从外循环当前索引旁边的索引开始内循环。。。但在PHP中,有人告诉我,我不能依次迭代关联数组…:-(

因此,问题是:如何迭代PHP关联数组,将函数应用于任何一对键,避免排列

您可以像在C:中一样执行此操作

$len = count($table);
for($i = 0; $i < $len - 1; $i++)
    for($j = $i + 1; $j < $len; $j++)
        compare table[$i] and table[$j]

如果您的密钥不是按顺序排列的,请迭代密钥数组(按顺序排列),而不是实际数组:

$keys = array_keys($table);
$len = count($keys);
for($i = 0; $i < $len - 1; $i++)
    for($j = $i + 1; $j < $len; $j++)
        compare table[keys[$i]] and table[keys[$j]]

您可以使用in_array进行以下操作:

foreach ($table as $record1) {
   if(in_array($record1["phone"], $table){
   }
}

这将检查当前值是否存在于数组中。点击此处阅读更多信息:http://php.net/manual/en/function.in-array.php

试试这个:)

<?php
$data = array(
    array('id'=>'1','name'=>'test1','phone'=>'1231231234'),
    array('id'=>'2','name'=>'test2','phone'=>'1231231235'),
    array('id'=>'3','name'=>'test2','phone'=>'1231231234')
);
// sort and find duplicate numbers
$ch = array();
$duplicate = array();
foreach($data as $k=>$d){
    if(in_array($d['phone'],$ch)){
        $duplicate[] = $k;
    }else{
        $ch[$k]=$d['phone'];
    }
}
// remove duplicated numbers from the initial table array
if($duplicate){
    foreach($duplicate as $r)
        unset($data[$r]);
}
// now we have only unique numbers
echo '<pre>';
print_r($data);
echo '</pre>';