在PHP中对数组的一部分排序



我有这样一个数组:

array ('project'=>'My project','leader'=>'Michael Phepps','partner1'=>'John Campbell','partner2'=>'Phillip Prescott','agepartner1'=>25, 'agepartner2'=>'44', 'budget'=>'80000');

这个数组是在不同的表中查询的结果:项目表字段:项目、负责人、预算。合伙人字段:合伙人、年龄

数组的顺序由用户定义,并像这样执行:

foreach ($userarray as $field) {loadField($field)};

由于操作是针对每个字段,我在'partner1'之后获得'partner2',但我需要在'partner1'之后获得'agepartner1',因为它们在那之后显示在html表中。

你有什么建议吗?

array ('project'=>'My project','leader'=>'Michael Phepps','partner1'=>'John Campbell', 'agepartner1'=>25, 'partner2'=>'Phillip Prescott', 'agepartner2'=>'44', 'budget'=>'80000');

虽然可能不是你想要的答案,但我认为可能有一个更好的方法来处理你的情况:

$data = array('key1' => 'is', 'key2' => 'test', 'key3' => 'This');
$order = array('key3', 'key1', 'key2');
foreach($order as $key){
  print_r($data[$key]);
}
输出:

This is test.

对于你的数据:

$userarray = array ('project'=>'My project',
                    'leader'=>'Michael Phepps',
                    'partner1'=>'John Campbell',
                    'partner2'=>'Phillip Prescott',
                    'agepartner1'=>25, 
                    'agepartner2'=>'44', 
                    'budget'=>'80000');
$order = array('project',
               'leader',
               'partner1', 
               'agepartner1', 
               'partner2', 
               'agepartner2', 
               'budget');
foreach($order as $field) {
  loadField($userarray[$field]);
}

不能直接对数组的一部分进行排序。您只能将数组划分为要排序的部分,然后对这些部分进行排序,然后对数组数据应用该排序。因为你不能改变键的位置。正如蒂姆·利特尔所建议的那样,获取密钥,对它们进行排序,然后就有了解决方案。这稍微减少了问题。

自然有解决办法。但是,请记住,您的数据结构排序非常笨拙。我做了以下操作:

  • 获取密钥
  • 对键进行分类:如果不包含数字,则分类为键本身;如果包含数字,则分类为数字。
  • 将所有密钥按类别分组。这意味着,每次类别改变时,一个新的组开始:在您的情况下是ALPHA, DIGIT, ALPHA
  • 打通所有群组并处理。DIGIT组可能需要排序,所以我对它们进行了排序(例如,如果agepartnerpartner之前,我只是做了a-z排序+反向)。
  • 再次将所有部件平铺成一个键数组。键排序完成。
  • 根据新的key-order和原始数组中的值创建一个$sorted数组。

如果您需要对数字进行排序(例如,首先是1,然后是2),您可以通过对内部数组进行键排序(ksort)对每个DIGIT组进行排序。由于您的数据结构如此复杂,下面的代码示例带有调试输出和一些注释,因此至少对您来说更容易浏览和使用它:

$array = array ('project'=>'My project','leader'=>'Michael Phepps','partner1'=>'John Campbell','partner2'=>'Phillip Prescott','agepartner1'=>25, 'agepartner2'=>'44', 'budget'=>'80000');
// reduce the problem: If we can sort the keys, we have the solution.
$keys = array_keys($array);
echo "Keys:n";
var_dump($keys);
// categorize keys: alpha-only or alpha and digits at the end
$categories = array();
foreach($keys as $key)
{
    $r = preg_match('/^([a-z]+)(d*)$/', $key, $matches);
    assert('$r !== FALSE');
    list(,$alpha, $digits) = $matches;
    $category = $digits ? $digits : $alpha; 
    $categories[$category][] = $key;
}
echo "Categories:n";
var_dump($categories);
// group categories together in their order: ALPHA blocks and DIGIT blocks
define('GROUP_ALPHA', 1);
define('GROUP_DIGIT', 2);
$last = GROUP_ALPHA;
$group = array(); // start with an empty group to add to, pointer
$groups = array(array(GROUP_ALPHA => &$group));
foreach($categories as $vkey => $category)
{
    $current = is_int($vkey) ? GROUP_DIGIT : GROUP_ALPHA;
    if ($current != $last)
    {
        // add new group
        unset($group);
        $group = array();
        $groups[] = array($current => &$group);
    }
    $group[] = $category;
    $last = $current;
}
unset($group); // remove pointer
echo "Groups:n";
var_dump($groups);
// sort and flatten groups
$ungroup = array();
foreach($groups as $type => $group)
{
    if ($type == GROUP_DIGIT)
    {
        // if digit groups need to be sorted: partner, agepartner
        foreach($group as &$items)
        {
            sort($items);
            array_reverse($items);
            unset($items);
        }
    }
    // flatten the group
    $group = call_user_func_array('array_merge', $group);
    $group = call_user_func_array('array_merge', $group);
    $ungroup = array_merge($ungroup, $group);
}
echo "Un-Grouped:n";
var_dump($ungroup);
// solve
$sorted = array();
foreach($ungroup as $key)
{
    $sorted[$key] = $array[$key];
}
echo "Sorted:n";
var_dump($sorted);
输出:

Keys:
array(7) {
  [0]=>
  string(7) "project"
  [1]=>
  string(6) "leader"
  [2]=>
  string(8) "partner1"
  [3]=>
  string(8) "partner2"
  [4]=>
  string(11) "agepartner1"
  [5]=>
  string(11) "agepartner2"
  [6]=>
  string(6) "budget"
}
Categories:
array(5) {
  ["project"]=>
  array(1) {
    [0]=>
    string(7) "project"
  }
  ["leader"]=>
  array(1) {
    [0]=>
    string(6) "leader"
  }
  [1]=>
  array(2) {
    [0]=>
    string(8) "partner1"
    [1]=>
    string(11) "agepartner1"
  }
  [2]=>
  array(2) {
    [0]=>
    string(8) "partner2"
    [1]=>
    string(11) "agepartner2"
  }
  ["budget"]=>
  array(1) {
    [0]=>
    string(6) "budget"
  }
}
Groups:
array(3) {
  [0]=>
  array(1) {
    [1]=>
    array(2) {
      [0]=>
      array(1) {
        [0]=>
        string(7) "project"
      }
      [1]=>
      array(1) {
        [0]=>
        string(6) "leader"
      }
    }
  }
  [1]=>
  array(1) {
    [2]=>
    array(2) {
      [0]=>
      array(2) {
        [0]=>
        string(8) "partner1"
        [1]=>
        string(11) "agepartner1"
      }
      [1]=>
      array(2) {
        [0]=>
        string(8) "partner2"
        [1]=>
        string(11) "agepartner2"
      }
    }
  }
  [2]=>
  array(1) {
    [1]=>
    array(1) {
      [0]=>
      array(1) {
        [0]=>
        string(6) "budget"
      }
    }
  }
}
Un-Grouped:
array(7) {
  [0]=>
  string(7) "project"
  [1]=>
  string(6) "leader"
  [2]=>
  string(8) "partner1"
  [3]=>
  string(11) "agepartner1"
  [4]=>
  string(8) "partner2"
  [5]=>
  string(11) "agepartner2"
  [6]=>
  string(6) "budget"
}
Sorted:
array(7) {
  ["project"]=>
  string(10) "My project"
  ["leader"]=>
  string(14) "Michael Phepps"
  ["partner1"]=>
  string(13) "John Campbell"
  ["agepartner1"]=>
  int(25)
  ["partner2"]=>
  string(16) "Phillip Prescott"
  ["agepartner2"]=>
  string(2) "44"
  ["budget"]=>
  string(5) "80000"
}

最新更新